Data management system having a common database infrastructure

• US 20040054675A1
• Filed: 09/13/2002
• Published: 03/18/2004
• Est. Priority Date: 09/13/2002
• Status: Active Grant

• Current Assignee: GM Global Technology Operations LLC (General Motors Company)
• Original Assignee: GM Global Technology Operations Incorporated (Motors Liquidation Co. GUC Trust)
• Inventors: Li, Dennis Fuk-Kuen
• Granted Patent: US 7,395,255 B2
• Time in Patent Office: Days
• US Class Current: 707/100
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing

Abstract

A data management system for use in accessing a plurality of diverse and distributed data sources over a computer network. Within the system, data from the data sources is represented by common data objects that encapsulate the actual data along with the methods and properties needed for use of the data. The system includes a common data model, a plurality of service managers, and a data services coordinator that coordinates operation of the service managers in utilizing the common data model to instantiate the common data objects that represent the data being accessed. The service managers include at least one data access manager for creation of the common data objects and a plurality of ancillary service managers that each provide one or more data service functions such as, for example, meta-data management, data management, data versioning, data transport, data update notification, data security, data presentation, and data translation.

Claims

1. A data management system for use in accessing a plurality of data sources having data stored in different formats, comprising:

a computer network including a group of two or more computers interconnected to each other such that they can exchange data over a communications path;

a common data model stored on one or more of the computers and including a data class having a plurality of attributes defining properties of the data class;

a plurality of service managers including at least a data access manager and an ancillary service manager, wherein the data access manager is operable to access the common data model and to access data from one or more of the data sources for use in instantiating a common data object containing the accessed data, and wherein the ancillary service manager is operable to provide a data service function; and

a data services coordinator responsive to requests for access to data available from one or more of the data sources, wherein the data services coordinator is operable to coordinate operation of at least some of the service managers in creating and utilizing the common data object to supply the requested data.

2. A data management system as defined in claim 1, wherein the service managers and data services coordinator each comprise at least one computer program stored on one or more of the computers.

3. A data management system as defined in claim 1, wherein the common data model includes information concerning global logical and physical data definitions, mapping to and from local data source models, and the location of various data sources and data items stored in the data sources.

4. A data management system as defined in claim 1, wherein the data class includes a plurality of subclasses, each of which is directed to one or more specific data structures.

5. A data management system as defined in claim 1, wherein the common data model is implemented using an object oriented modeling language.

6. A data management system as defined in claim 1, further comprising a second data access manager, wherein the data access managers include a data view manager and a data source adapter manager that together access the common data model and data used in instantiating the common data object.

7. A data management system as defined in claim 6, wherein the data view manager is operable to instantiate the data class in response to a request to obtain data from one or more of the data sources to thereby create the common data object containing the requested data.

8. A data management system as defined in claim 6, wherein the data source adapter manager is operable to control the extraction of data from at least one of the data sources for use by the data view manager in creating the common data object.

9. A data management system as defined in claim 6, wherein the data source adapter manager is operable to control the storage of data in at least one of the data sources.

10. A data management system as defined in claim 6, wherein the data source adapter manager comprises a first data source adapter manager and wherein the data management system further comprises a second data source adapter manager, the first adapter manager being operable to control the extraction of data from a first type of data source and the second adapter manager being operable to control the extraction of data from a second type of data source.

11. A data management system as defined in claim 10, wherein the first type of data source is a relational database and the first adapter manager is operable to control the extraction of data from the relational database.

12. A data management system as defined in claim 6, further comprising a set of view manager interface modules, at least one of which interfaces the data source view manager with the adapter manager.

13. A data management system as defined in claim 6, further comprising a set of adapter interface modules, each of which permits the adapter manager to be interfaced to at least one of the data sources.

14. A data management system as defined in claim 6, wherein the data source view manager includes data properties information used in instantiating the common data object.

15. A data management system as defined in claim 6, wherein said data view manager is operable to provide a meta-data management function that enables creation, update, deletion, and retrieval of the attributes of the data class used in the common data model.

16. A data management system as defined in claim 6, wherein said data source adapter manager is operable to provide a source data management function that enables creation, update, deletion, and retrieval of data in the data sources.

17. A data management system as defined in claim 1, wherein the data service function comprises one or more of the following services:

data versioning,

data transport,

data update notification,

data security,

data presentation, and

data translation.

18. A data management system as defined in claim 1, wherein the ancillary service manager comprises an audit manager that handles data versioning and/or data update notifications concerning data available from at least some of the data sources.

19. A data management system as defined in claim 1, wherein the ancillary service manager comprises a transport manager that enables data transfer between computers on the computer network using a communications protocol.

20. A data management system as defined in claim 1, wherein the ancillary service manager comprises a data security manager that handles authentication and authorization of the requests to access data.

21. A data management system as defined in claim 1, wherein the ancillary service manager comprises a GUI manager that controls the presentation of the accessed data via a web interface.

22. A data management system as defined in claim 1, wherein the ancillary service manager comprises a portal manager that controls the presentation of the accessed data via a web interface using user-customized information.

23. A data management system as defined in claim 1, wherein the ancillary service manager comprises a translation manager that enables the accessed data stored in the common data object to be converted to one or more standardized or proprietary formats.