Method and system for manipulation of distributed heterogeneous data in a data processing system

• US 5,345,586 A
• Filed: 08/25/1992
• Issued: 09/06/1994
• Est. Priority Date: 08/25/1992
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Maron, William A., Hamala, Annette M., Reyburn, Rhoda A.
• Primary Examiner(s): Heckler, Thomas M.
• Application Number:
  US07/934,975
• Time in Patent Office: 742 Days
• Field of Search: 395/650, 395/600, 395/200, 364/DIG. 1 MS File
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

Manipulation of distributed heterogeneous data in a data processing system having multiple diverse data sources is permitted by providing a global data directory which maps the location of data, specific data entity attributes and data source parameters. An attribute table is provided within the global data directory which sets forth desired attributes in a logical data model for each data entity within the data processing system. A domain table related to the attribute table is utilized to specify domain information for each data entity attribute. Route and cross-reference tables are provided and utilized to specify data source or database parameters and a cross-reference between logical names within the logical data model and the diverse data sources. Desired heterogeneous data is then accessed utilizing the route and cross-reference tables and converted utilizing any known technique into an output having the desired attributes set forth within the attribute table. In this manner, a consistent interface between multiple distributed heterogeneous data sources and a system user is provided.

Claims

1. A method for enhanced manipulation of distributed heterogeneous data in a data processing system having a plurality of diverse data sources therein, said method comprising the steps of:

establishing a global data directory which includes;

an attribute table listing desired attributes for a plurality of data entities within said data processing system;

a domain table listing domain information for each of said desired attributes for said plurality of data entities within said data processing system;

a route table listing each of said plurality of diverse data sources within said data processing system; and

a cross-reference table listing a cross-reference between logical names within a logical data model and said plurality of diverse data sources;

accessing said distributed heterogeneous data within said data processing system utilizing said cross-reference table and said route table; and

converting said accessed distributed heterogeneous data into a consistent format having desired attributes utilizing said attribute table and said domain table, wherein a consistent interface into said distributed heterogeneous data is provided.

2. The method for enhanced manipulation of distributed heterogeneous data in a data processing system according to claim 1, further including the step of establishing an index table within said global data directory listing those attributes which make each data entity unique within said data processing system wherein tables within said logical data model may be created.

3. The method for enhanced manipulation of distributed heterogeneous data in a data processing system according to claim 1, further including the step of establishing a reason table within said global data directory listing a reason for each update of a table containing logical data model wherein updates to said logical data model may be analyzed.

4. The method for enhanced manipulation of distributed heterogeneous data in a data processing system according to claim 1, further including the step of establishing a detail table within said global data directory listing all updates to tables containing said logical data model wherein changes to said logical data model at any point in time may be determined.

5. The method for enhanced manipulation of distributed heterogeneous data in a data processing system according to claim 1, further including the step of establishing a narrative description table within said global data directory including a narrative description of each of said plurality of data entities within said data processing system wherein a user may efficiently determine a selected one of said plurality of data entities.

6. A data processing system for efficiently manipulating distributed heterogenous data within said data processing system, said data processing system comprising:

a plurality of diverse data sources within said data processing system, said plurality of diverse data sources including multiple heterogeneous data entities stored therein;

a global data directory within said data processing system, said global data directory including;

an attribute table listing desired attributes for each of said multiple heterogeneous data entities;

a domain table listing domain information for each of said desired attributes for each of said multiple heterogeneous data entities;

a route table listing each of said plurality of diverse data sources within said data processing system; and

a cross-reference table listing a cross-reference between logical names within a logical data model and said plurality of diverse data sources;

access means for accessing selected ones of said multiple heterogeneous data entities within said data processing system utilizing said cross-reference table and said route table within said logical data model; and

conversion means for converting said accessed selected ones of said multiple heterogeneous data entities into a consistent format having desired attributes utilizing said attribute table and said domain table wherein a consistent interface into said distributed heterogeneous data is provided.

7. A data processing system for efficiently manipulating distributed heterogeneous data within said data processing system according to claim 6, further including an index table within said global data directory listing those attributes which make each of said multiple heterogeneous data entities unique.

8. A data processing system for efficiently manipulating distributed heterogeneous data within said data processing system according to claim 6, further including a reason table within said global data directory listing a reason for each update of a table containing said logical data mode.

9. A data processing system for efficiently manipulating distributed heterogeneous data within said data processing system according to claim 6, further including a detail table within said global data directory listing all updates to tables containing said logical data model.

10. A data processing system for efficiently manipulating distributed heterogeneous data within said data processing system according to claim 6, further including a narrative table within said global data directory listing a narrative description of each of said multiple heterogeneous data entities within said data processing system.