The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Oct. 06, 1998
Filed:
Mar. 26, 1996
Forouzan Golshani, Paradise Valley, AZ (US);
Oris D Friesen, Scottsdale, AZ (US);
Thomas H Howell, Scottsdale, AZ (US);
Other;
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.