System and method of querying data

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.

2. The method of claim 1 , wherein the table includes a plurality of instances.

3. The method of claim 1 , wherein the table includes a plurality of instances, wherein an instance is a repeatable item.

4. The method of claim 1 , wherein the table has a reference corresponding to a fully qualified path from a root node to a repeatable node, wherein the repeatable node represents the table.

5. The method of claim 1 , wherein the unified data model query includes an extension that specifies a target column as a distinct criteria.

6. The method of claim 1 , wherein the unified data model query includes an extension that specifies a target column in a where clause of a select statement.

7. The method of claim 1 , wherein the unified data model query includes a first extension that specifies a target column as a distinct criteria, and a second extension that specifies a target column in a where clause of a select statement.

8. The method of claim 1 , wherein the second data is output in a unified data model format.

9. The method of claim 1 , wherein the second data is output in a hierarchical format.

10. The method of claim 1 , wherein the second data is output in a relational format.

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.

12. The system of claim 11 , wherein the table includes a plurality of instances.

13. The system of claim 11 , wherein the table includes a plurality of instances, wherein an instance is a repeatable item.

14. The system of claim 11 , wherein the table has a reference corresponding to a fully qualified path from a root node to a repeatable node, wherein the repeatable node represents the table.

15. The system of claim 11 , wherein the unified data model query includes an extension that specifies a target column as a distinct criteria.

16. The system of claim 11 , wherein the unified data model query includes an extension that specifies a target column in a where clause of a select statement.

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.

18. The non-transitory computer readable medium of claim 17 , wherein the table includes a plurality of instances.

19. The non-transitory computer readable medium of claim 17 , wherein the table includes a plurality of instances, wherein an instance is a repeatable item.

20. The non-transitory computer readable medium of claim 17 , wherein the table has a reference corresponding to a fully qualified path from a root node to a repeatable node, wherein the repeatable node represents the table.