Data modeling system for runtime schema extensibility

• US 9,507,820 B1
• Filed: 10/23/2012
• Issued: 11/29/2016
• Est. Priority Date: 10/23/2012
• Status: Active Grant

• Current Assignee: Quest Software, Inc.
• Original Assignee: Dell Software, Inc. (Dell Technologies Inc.)
• Inventors: Hannah, Peter Douglas, Willis, Rodney Owen, Duenas, Jose Roberto Antonio II
• Primary Examiner(s): NGUYEN, THU N
• Application Number:
  US13/658,747
• Time in Patent Office: 1,498 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/245 Query processing

Abstract

Systems and methods for using a logical data model to at least partially address the deficiencies with existing ORM solutions are provided. In certain embodiments, the logical data model includes a layer that hides the underlying physical layout of tables in a database. The logical data model can act as a data management component that supports any subset of the following: 1) dynamic data modeling and schema management; 2) data set comparison and merge with historical tracking; and/or 3) data query.

Claims

1. A system for querying a database using a logical data model, the system comprising:

a logical data model comprising data representing a plurality of entities, each of the plurality of entities having one or more properties, and mappings to a plurality of physical database tables, the mappings configured to map the plurality of entities to the plurality of physical database tables in a physical database; and

a query engine comprising computer hardware, the query engine configured to;

receive, from a custom reporting application, a request for entity data of the logical data model, the requested-for entity data being related to first properties of a selected entity of the plurality of entities,

access the logical data model to identify two or more physical database tables of the plurality of physical database tables and associated columns in the two or more physical database tables to which the first properties of the selected entity are mapped,

construct a query to access the two or more physical database tables in the physical database,

pass the query to a database management system to cause the query to be executed on the physical database,

receive results of the query from the database management system, and

provide the results of the query to the custom reporting application to thereby enable the custom reporting application to generate a report, including the results of the query, for presentation to a user,

wherein the plurality of entities of the logical data model are dynamically bound such that updating the logical data model is performed without requiring recompilation of the logical data model or the physical database, thereby enabling the logical data model to be modified at runtime,

wherein the logical data model stores semantic relationships between the plurality of entities that mask relational relationships between the plurality of physical database tables, and

wherein the logical data model is configured to map an entity of the plurality of entities to multiple database tables of the plurality of physical database tables.

2. The system of claim 1, further comprising a data collector configured to collect data from a third party system and to provide the data for storage in the two or more physical database tables based on the logical data model.

3. The system of claim 1, wherein the query engine comprises one or more extension points, thereby enabling the query engine to be dynamically modified at runtime.

4. The system of claim 1, wherein the plurality of entities in the logical data model are stored in tables.

5. A system for querying a database using a logical data model, the system comprising:

a logical data model comprising data representing a plurality of entities, each of the plurality of entities having one or more properties, and mappings to a plurality of physical database tables, the mappings configured to map the plurality of entities to the plurality of physical database tables in a physical database; and

a query engine comprising computer hardware, the query engine configured to;

receive, from an application, a request for entity data of the logical data model, the requested-for entity data being related to first properties of a selected entity of the plurality of entities,

access the logical data model to identify two or more physical database tables of the plurality of physical database tables and associated columns in the two or more physical database tables to which the first properties of the selected entity are mapped,

construct a query to access the two or more physical database tables in the physical database,

cause the query to be executed on the physical database,

receive results of the query from the physical database,

provide the results of the query to the application,

wherein the plurality of entities of the logical data model are dynamically bound such that updating the logical data model is performed without requiring recompilation of the logical data model or the physical database, thereby enabling the logical data model to be modified at runtime,

wherein the logical data model stores semantic relationships between the plurality of entities that mask relational relationships between the plurality of physical database tables, and

wherein the logical data model is configured to map an entity of the plurality of entities to multiple database tables of the plurality of physical database tables.

6. The system of claim 5, wherein the query engine is further configured to cause the query to be executed on the physical database by providing the query to a database management system.

7. The system of claim 5, wherein the query engine is further configured to construct the query by joining the two or more physical database tables.

8. The system of claim 5, wherein the query engine is further configured to select a structured query language (SQL) dialect corresponding to a SQL dialect used by the physical database.

9. The system of claim 5, wherein the semantic relationships comprise inheritance relationships.

10. The system of claim 5, wherein the semantic relationships comprise parent-child relationships.

11. The system of claim 5, wherein the semantic relationships comprise possessive relationships.

12. The system of claim 5, wherein the physical database comprises a non-relational database.

13. Non-transitory physical computer storage comprising instructions stored thereon that, when executed by one or more processors, implement components for querying a database using a logical data model, the components comprising:

a logical data model comprising data representing a plurality of entities, each of the plurality of entities having one or more properties, and mappings to a plurality of physical database tables, the mappings configured to map the plurality of entities to the plurality of physical database tables in a physical database; and

a query engine configured to;

receive, from an application, a request for entity data of the logical data model, the requested-for entity data being related to first properties of a selected entity of the plurality of entities,

access the logical data model to identify two or more physical database tables of the plurality of physical database tables and associated columns in the two or more physical database tables to which the first properties of the selected entity are mapped,

construct a query to access the two or more physical database tables in the physical database,

pass the query to the physical database to thereby cause the query to be executed on the physical database,

receive results of the query from the physical database, and

provide the results of the query to application,

wherein the plurality of entities of the logical data model are dynamically bound such that updating the logical data model is performed without requiring recompilation of the logical data model or the physical database, thereby enabling the logical data model to be modified at runtime,

wherein the logical data model stores semantic relationships between the plurality of entities that mask relational relationships between the plurality of physical database tables, and

wherein the logical data model is configured to map an entity of the plurality of entities to multiple database tables of the plurality of physical database tables.

14. The non-transitory physical computer storage of claim 13, wherein the query engine is further configured to provide support for custom data types.

15. The non-transitory physical computer storage of claim 14, wherein the query engine can interpret the custom data types at runtime.

16. The non-transitory physical computer storage of claim 13, wherein each of the plurality of entities is mapped to one or more of the plurality of physical database tables.

17. The non-transitory physical computer storage of claim 13, in combination with a computer system comprising one or more physical computing devices.

18. A method of querying a database using a logical data model, the method comprising:

by a computer system comprising computer hardware;

receiving, from an application, a request for entity data of a logical data model, the logical data model comprising a plurality of entities, the requested-for entity data being related to properties of a selected entity of the plurality of entities;

accessing the logical data model to identify two or more physical database tables in a physical database and associated columns in the two or more physical database tables to which the properties of the selected entity are mapped;

constructing a query to access the two or more physical database tables in the physical database;

passing the query to a database management system configured to execute the query on the physical database;

receiving results of the query from the database management system; and

providing the results of the query to the application;

wherein the plurality of entities of the logical data model are dynamically bound such that updating the logical data model is performed without requiring recompilation of the logical data model or the physical database, thereby enabling the logical data model to be modified at runtime,

wherein the logical data model stores semantic relationships between the plurality of entities that mask relational relationships between a plurality of physical database tables; and

wherein the logical data model is configured to map an entity of the plurality of entities to multiple database tables of the two or more physical database tables.