US5850631A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method for providing a graphical interface for the specification of relationships between two schemas
Assignee: Bull HN Information Systems Inc
•
Filing: 1996-03-26
•
Granted: 1998-12-15
•
Expires: 2016-03-26
Abstract
Abstract A method executed by a computer system for providing a visual interface Nor specifying relationships and correspondences between two graphically displayed database schemas in object oriented form. After displaying two schemas, selecting an object one from each and displaying their attributes. After selecting a pair of attributes if they are key attributes, comparing their domains and recording same and checking to determine if there is a mis-match as to data types. If either attribute is not a key attribute, checking to see if there is a mis- match of data types. If in either case there is no mismatch, then select a name for the combined attribute and deleting the attributes so combined from the list of attributes for each object. Repeating until all attributes of all objects of the two schemas have been combined, then generating a file containing all correspondences and a list of all assertions of correspondences.
Inventors
- 👤 Forouzan Golshani
- 👤 Oris D. Friesen
- 👤 Thomas H. Howell
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-01 15:32
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 4
Claim 1
Independent Claim
292 words
A method by which a computer system having a monitor provides a visual interface for specifying relationships and correspondences between two graphically displayed database schemas in object oriented (OO) form; comprising the steps of: 1, receiving as inputs two OO database schemas in graphical form, and displaying both schemas on the monitor of said computer system; 2, displaying on the monitor a correspondence specification menu; 3, selecting a pair of objects, one from each of the two schemas displayed in step 1, each of objects having attributes; 4, displaying on the monitor a list of all of the attributes of each of the objects selected in step 3; 5, selecting an attribute from each list of attributes displayed in step 4 as candidates for correspondence; 6, if either or both of the attributes selected in step 5 is a key attribute, comparing domains of the two selected attributes and recording the domain relationship; 7, if neither of the attributes selected in step 5 is a key attribute, and if there is a match between the data types of the two selected attributes at the completion of step 6, combining the two attributes to form a combined attribute and selecting a name for the combined attribute; 8, deleting the attributes selected in step 5 from the lists of attributes listed in step 4; 9, if there are more attributes in the lists of attributes listed in step 4, repeating steps 5 through 8 until all attributes listed in step 4 have been deleted; 10, if there are more objects with attributes, repeating steps 1 through 9 until there are no objects whose attributes have not been deleted; 11, generating a file containing all correspondences; and 12, identifying all assertions for correspondences between attributes.
Claim 2
Independent Claim
292 words
A method by which a computer system having a monitor provides a visual interface for specifying relationships and correspondences between two graphically displayed database schemas in object oriented (OO) form; comprising the steps of: 1, receiving as inputs two OO database schemas in graphical form, and displaying both schemas on the monitor of said computer system; 2, displaying on the monitor a correspondence specification menu; 3, selecting a pair of objects, one from each of the two schemas displayed in step 1, each of objects having attributes; 4, displaying on the monitor a list of all of the attributes of each of the objects selected in step 3; 5, selecting an attribute from each list of attributes displayed in step 4 as candidates for correspondence; 6, if either or both of the attributes selected in step 5 is a key attribute, comparing domains of the two selected attributes and recording the domain relationship; 7, if neither of the attributes selected in step 5 is a key attribute, and if there is a match between the data types of the two selected attributes at the completion of step 6, combining the two attributes to form a combined attribute and selecting a name for the combined attribute; 8, deleting the attributes selected in step 5 from the lists of attributes listed in step 4; 9, if there are more attributes in the lists of attributes listed in step 4, repeating steps 5 through 8 until all attributes listed in step 4 have been deleted; 10, if there are more objects with attributes, repeating steps 1 through 9 until there are no objects whose attributes have not been deleted; 11, generating a file containing all correspondences; and 12, identifying all assertions for correspondences between attributes.
Claim 3
Dependent Claim
23 words
The method of claim 1 in which if after completion of step 1 two schemas are not displayed, an error message is displayed.
Claim 4
Dependent Claim
30 words
The method of claim 2 in which, if in step 7 there is a mis-match between the types of data of the two selected attributes, an error report is displayed.
References Cited (Backward Citations)
US4714995A
Cited
US5295222A
Cited
US5295256A
Cited
US5212787A
Cited
US5551030A
Cited
US5499371A
Cited
US5627979A
Cited
US5542078A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-12-14 | 2002-06-15 | 2002-12-15 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-12-14 | 2006-06-15 | 2006-12-15 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-12-14 | 2010-06-15 | 2010-12-15 | $7700.00 | Window Closed / Lapsed |