← Back to Patent Explorer
US5345586A Expired / Lapsed US ⏱️ 0.0 years remaining

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

Assignee: International Business Machines Corp
•
Filing: 1992-08-25
•
Granted: 1994-09-06
•
Expires: 2012-08-25
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

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.

Inventors

  • 👤 Annette M. Hamala
  • 👤 William A. Maron
  • 👤 Rhoda A. Reyburn

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-11-04 18:55
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/258

Claims Analysis

Total Claims: 12
Claim 1
Independent Claim 165 words
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.
Claim 2
Independent Claim 165 words
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.
Claim 3
Dependent Claim 56 words
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.
Claim 4
Dependent Claim 55 words
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.
Claim 5
Dependent Claim 57 words
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.
Claim 6
Dependent Claim 65 words
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.
Claim 7
Dependent Claim 202 words
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.
Claim 8
Dependent Claim 202 words
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.
Claim 9
Dependent Claim 42 words
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.
Claim 10
Dependent Claim 43 words
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.
Claim 11
Dependent Claim 39 words
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.
Claim 12
Dependent Claim 46 words
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.

References Cited (Backward Citations)

US4714995A Cited
US5119465A Cited
US5280610A Cited

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 1997-09-05 1998-03-07 1998-09-06 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2001-09-05 2002-03-07 2002-09-06 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2005-09-05 2006-03-07 2006-09-06 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag