Data modeling system for runtime schema extensibility

• US 8,838,654 B1
• Filed: 10/23/2012
• Issued: 09/16/2014
• 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, CAM LINH T
• Application Number:
  US13/658,732
• Time in Patent Office: 693 Days
• Field of Search: 707/802, 707/803, 707/810
• US Class Current: 707/803
• CPC Class Codes: G06F 16/212 with details for data modelling support

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 method of extending a logical data model during runtime, the method comprising:

by one or more first computer systems comprising computer hardware;

tracking data regarding a plurality of attributes associated with a second computer system with a data collector;

receiving a request to track data on a new attribute associated with the second computer system, the new attribute not previously having been tracked by the data collector;

updating a logical data model to include the new attribute, the logical data model comprising a plurality of entities mapped to a schema of a physical database;

modifying the schema of the physical database to include the new attribute;

collecting data for the new attribute with the data collector; and

using the logical data model to store the collected data in the physical database according to the modified schema;

wherein the logical data model is dynamically bound, such that said updating the logical data model is performed without requiring recompilation of the data collector, the logical data model, or the physical database;

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

2. The method of claim 1, further comprising generating a custom report including the new attribute.

3. The method of claim 1, wherein said modifying the schema of the physical database comprises creating a new table to include the new attribute.

4. The method of claim 1, wherein said modifying the schema of the physical database comprises extending an existing table in the schema to include the new attribute.

5. The method of claim 1, further comprising outputting an attribute extension user interface enabling a user to specify the new attribute to be tracked.

6. The method of claim 1, wherein the second computer system comprises one or more of the following:

a Microsoft Active Directory™

system, a Windows Management Instrumentation™

system, a registry, or a storage system.

7. A system for extending a logical data model during runtime, the system comprising:

a data collector implemented in a first computer system comprising computer hardware, the data collector configured to collect data regarding a plurality of attributes associated with a second computer system;

an attribute extender configured to;

receive a request to track data on a new attribute associated with the second computer system, the new attribute not previously having been tracked by the data collector, and

update a logical data model to include the new attribute, the logical data model comprising a plurality of entities mapped to a schema of a physical database;

a logical data model layer configured to;

receive the new attribute from the attribute extender,

adjust metadata in the logical data model to include the new attribute, and

dynamically extend a schema of a physical database to include the new attribute during runtime without recompilation, thereby enabling the data collector to store data for the new attribute using the logical data model;

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

8. The system of claim 7, wherein the entities of the logical data model are decoupled from the schema of the physical database, thereby enabling developer interaction with the data to be performed without directly accessing the physical database.

9. The system of claim 7, wherein data types of the data stored in the physical database are strongly typed.

10. The system of claim 7, wherein each of the entities is mapped to two or more tables of the physical database.

11. The system of claim 7, wherein the semantic relationships comprise inheritance relationships.

12. The system of claim 7, wherein the semantic relationships comprise parent-child relationships.

13. The system of claim 7, wherein the semantic relationships comprise possessive relationships.

14. Non-transitory physical computer storage comprising instructions stored thereon that, when executed by one or more processors, implement components for extending a logical data model during runtime, the components comprising:

a data collector implemented in a first computer system comprising computer hardware, the data collector configured to collect data regarding a plurality of attributes associated with a second computer system;

an attribute extender configured to;

receive a request to track data on a new attribute associated with the second computer system, the new attribute not previously having been tracked by the data collector, and

update a logical data model to include the new attribute, the logical data model comprising a plurality of entities mapped to a schema of a physical database;

a logical data model layer configured to;

receive the new attribute from the attribute extender,

adjust metadata in the logical data model to include the new attribute, and

dynamically extend a schema of a physical database to include the new attribute during runtime without recompilation, thereby enabling the data collector to store data for the new attribute using the logical data model;

wherein the logical data model stores semantic relationships between the entities that mask relational relationships between the physical database tables.

15. The non-transitory physical computer storage of claim 14, wherein the attribute extender is further configured to modify the schema of the physical database by at least creating a new table to include the new attribute.

16. The non-transitory physical computer storage of claim 14, wherein the attribute extender is further configured to modify the schema of the physical database by at least extending an existing table in the schema to include the new attribute.

17. The non-transitory physical computer storage of claim 14, wherein data types of the data stored in the physical database are strongly typed.

18. The non-transitory physical computer storage of claim 14, wherein each of the entities is mapped to two or more tables of the physical database.