System and method of querying data
First Claim
Patent Images
1. A computer-implemented method of outputting data, comprising:
- storing, by a computer system, first data in a first format, wherein the first format is one of a hierarchical format and a relational format;
transforming, by the computer system, the first data from the first format to a second format, wherein the second format is neither the hierarchical format nor the relational format, wherein the second format is a source structure according to a unified data model, wherein the unified data model has a hierarchical structure with a plurality of tree nodes and a plurality of leaf nodes, and wherein a leaf node of the plurality of leaf nodes contains a table, wherein the table includes at least a portion of the first data;
storing, by the computer system, the first data structured in the source structure;
executing, by the computer system, a unified data model query on the first data having been transformed into the source structure, to result in second data structured in a target structure according to the unified data model, wherein executing the unified data model query comprises;
creating the target structure as a second plurality of tree nodes and a second plurality of leaf nodes, wherein each of the second plurality of leaf nodes are repeatable, wherein each of the second plurality of tree nodes are not repeatable, and wherein the target structure differs from the source structure,computing a result of the unified data model query, wherein the result includes a second table that is based on at least a portion of the first data, andcontaining the second table in a second leaf node of the second plurality of leaf nodes, wherein the second leaf node differs from the leaf node that contains the table in the source structure; and
outputting, by the computer system, the second data structured in the target structure.
1 Assignment
0 Petitions
Accused Products
Abstract
A system and method of querying data. The method includes transforming first data according to a unified data model. The unified data model has a hierarchical structure with tree nodes and leaf nodes. A leaf node contains a table. The method further includes executing a unified data model query on the first data (having been transformed) to result in second data. The method further includes outputting the second data.
36 Citations
20 Claims
-
1. A computer-implemented method of outputting data, comprising:
-
storing, by a computer system, first data in a first format, wherein the first format is one of a hierarchical format and a relational format; transforming, by the computer system, the first data from the first format to a second format, wherein the second format is neither the hierarchical format nor the relational format, wherein the second format is a source structure according to a unified data model, wherein the unified data model has a hierarchical structure with a plurality of tree nodes and a plurality of leaf nodes, and wherein a leaf node of the plurality of leaf nodes contains a table, wherein the table includes at least a portion of the first data; storing, by the computer system, the first data structured in the source structure; executing, by the computer system, a unified data model query on the first data having been transformed into the source structure, to result in second data structured in a target structure according to the unified data model, wherein executing the unified data model query comprises; creating the target structure as a second plurality of tree nodes and a second plurality of leaf nodes, wherein each of the second plurality of leaf nodes are repeatable, wherein each of the second plurality of tree nodes are not repeatable, and wherein the target structure differs from the source structure, computing a result of the unified data model query, wherein the result includes a second table that is based on at least a portion of the first data, and containing the second table in a second leaf node of the second plurality of leaf nodes, wherein the second leaf node differs from the leaf node that contains the table in the source structure; and outputting, by the computer system, the second data structured in the target structure. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A computer system for outputting data, comprising:
-
a storage device that is configured to store first data in a first format, wherein the first format is one of a hierarchical format and a relational format; and a processor that is configured to control the computer system to transform first data from the first format to a second format, wherein the second format is neither the hierarchical format nor the relational format, wherein the second format is a source structure according to a unified data model, wherein the unified data model has a hierarchical structure with a plurality of tree nodes and a plurality of leaf nodes, and wherein a leaf node of the plurality of leaf nodes contains a table, wherein the table includes at least a portion of the first data, wherein the storage device is configured to store the first data structured in the source structure, wherein the processor is configured to control the computer system to execute a unified data model query on the first data having been transformed into the source structure, to result in second data structured in a target structure according to the unified data model, wherein executing the unified data model query comprises; creating the target structure as a second plurality of tree nodes and a second plurality of leaf nodes, wherein each of the second plurality of leaf nodes are repeatable, wherein each of the second plurality of tree nodes are not repeatable, and wherein the target structure differs from the source structure, computing a result of the unified data model query, wherein the result includes a second table that is based on at least a portion of the first data, and containing the second table in a second leaf node of the second plurality of leaf nodes, wherein the second leaf node differs from the leaf node that contains the table in the source structure, and wherein the processor is configured to control the computer system to output the second data structured in the target structure. - View Dependent Claims (12, 13, 14, 15, 16)
-
-
17. A non-transitory computer readable medium storing instructions to control a computer system for outputting data, comprising:
-
a storing component that is configured to control the computer system to store first data in a first format, wherein the first format is one of a hierarchical format and a relational format; a transforming component that is configured to control the computer system to transform the first data from the first format to a second format, wherein the second format is neither the hierarchical format nor the relational format, wherein the second format is a source structure according to a unified data model, wherein the unified data model has a hierarchical structure with a plurality of tree nodes and a plurality of leaf nodes, and wherein a leaf node of the plurality of leaf nodes contains a table, wherein the table includes at least a portion of the first data, wherein the storage device is configured to store the first data structured in the source structure, a processing component that is configured to control the computer system to execute a unified data model query on the first data having been transformed into the source structure, to result in second data structured in a target structure according to the unified data model, wherein executing the unified data model query comprises; creating the target structure as a second plurality of tree nodes and a second plurality of leaf nodes, wherein each of the second plurality of leaf nodes are repeatable, wherein each of the second plurality of tree nodes are not repeatable, and wherein the target structure differs from the source structure, computing a result of the unified data model query, wherein the result includes a second table that is based on at least a portion of the first data, and containing the second table in a second leaf node of the second plurality of leaf nodes, wherein the second leaf node differs from the leaf node that contains the table in the source structure; and an output component that is configured to control the computer system to output the second data structured in the target structure. - View Dependent Claims (18, 19, 20)
-
Specification