Method for generating SQL commands to create an integrated globa

Details Method for generating SQL commands to create an integrated globa Method for generating SQL commands to create an integrated globa

1996-03-26

1998-10-06

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707 4, 707100, 707103, G06F 1730

Patent

active

058192778

ABSTRACT:
A method practiced by a computer system for generating SQL commands to create an integrated global schema. The input is two relational schemas in object-oriented form and a list of correspondences between components, object classes, objects and attributes. Based on correspondences object classes within one schema are folded into one object class, or relation, and likewise, based on correspondences one relation from each input schema is merged into a single relation of the integrated schema. This process is continued until no more object classes can be folded together and no more can be merged. SQL commands are generated based on specified correspondences between attributes depending upon whether a relation of the integrated relational schema was derived from only one relation of one of the input schemas, or is the result of the merger of two relations each from a different input schema. In the latter case, correspondences are based on the attributes of merged relations.

REFERENCES:
patent: 5421012 (1995-05-01), Khoyi et al.
patent: 5550971 (1996-08-01), Brunner et al.
patent: 5560005 (1996-09-01), Hoover et al.
patent: 5596744 (1997-01-01), Dao et al.

Affiliated with

Also associated with

Rating

Method for generating SQL commands to create an integrated globa does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method for generating SQL commands to create an integrated globa, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for generating SQL commands to create an integrated globa will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-93753