US5572650A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for displaying structures and relationships of a relational database
Assignee: Nokia of America Corp
•
Filing: 1994-06-30
•
Granted: 1996-11-05
•
Expires: 2014-06-30
Abstract
Abstract A method and apparatus for visually displaying structural characteristics of a large database for visualizing areas where new developments may be added, or finding places where old developments may need to be re-structured or replaced. This method and apparatus shows the entire structure without showing the entire semantics, which would be too much information. Semantic information is available in other windows that can be opened after the focus of the analysis is selected. After selection, the semantic information is displayed in a focused manner also. This is accomplished by referencing the selected relation to the location of that relation in the database specification or in the relational data base management system (RDBM) application code.
Inventors
- 👤 Jacqueline M. Antis
- 👤 Stephen G. Eick
- 👤 John D. Pyrce
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 08:04
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/21; G06F16/217
Claims Analysis
Total Claims: 18
Claim 1
Independent Claim
190 words
A method for displaying information about a relational database comprising the steps of: identifying each relation of a plurality of relations in the relational database; determining for each relation a respective number of occurrences of a specific data item contained therein; determining for each relation a key structural characteristic which can be used to access that relation; categorizing each relation of the plurality of relations according to key structural characteristics of the respective relation; visually displaying the plurality of relations in categories according to the key structural characteristics thereof; visually displaying for each relation of the plurality of relations a respective bar that is representative of the number of occurrences of the specific data item contained therein; coloring each display of each relation that has the same key structural characteristic with a common color that is different from the coloring of the relations of the other key structural characteristics; visually displaying a cursor that is operator controllable over the display area; and changing the coloring of a visual display of a relation with which the cursor is actively contacting to indicate a selection thereof for a display of further information.
Claim 2
Independent Claim
190 words
A method for displaying information about a relational database comprising the steps of: identifying each relation of a plurality of relations in the relational database; determining for each relation a respective number of occurrences of a specific data item contained therein; determining for each relation a key structural characteristic which can be used to access that relation; categorizing each relation of the plurality of relations according to key structural characteristics of the respective relation; visually displaying the plurality of relations in categories according to the key structural characteristics thereof; visually displaying for each relation of the plurality of relations a respective bar that is representative of the number of occurrences of the specific data item contained therein; coloring each display of each relation that has the same key structural characteristic with a common color that is different from the coloring of the relations of the other key structural characteristics; visually displaying a cursor that is operator controllable over the display area; and changing the coloring of a visual display of a relation with which the cursor is actively contacting to indicate a selection thereof for a display of further information.
Claim 3
Dependent Claim
28 words
The method as set forth in claim 1, further comprising the step of: displaying an additional view in an active window displaying further information about the cursor-selected relation.
Claim 4
Independent Claim
205 words
A method for displaying information about a relational database comprising the steps of: identifying each relation of a plurality of relations in the relational database; determining for each relation a respective number of a user selected data terms contained therein; determining for each relation a key structural characteristic which can be used to access that relation; sorting each relation of the plurality of relations according to key structural characteristics of the respective relation; visually displaying in an over view the plurality of relations categorized according to the key structural characteristic thereof; visually displaying in the over view for each relation of the plurality of relations a respective bar that is representative of the number of the user selected data item therein; coloring in the over view each display of each relation that has the same key structural characteristic with a common color that is different from the coloring of the relations of the other key structural characteristics; visually displaying in the over view a cursor that is operator controllable over the display area; and changing the coloring of a visual display of a relation with which the cursor is actively contacting to indicate a selection thereof for a display of further information in another view.
Claim 5
Independent Claim
205 words
A method for displaying information about a relational database comprising the steps of: identifying each relation of a plurality of relations in the relational database; determining for each relation a respective number of a user selected data terms contained therein; determining for each relation a key structural characteristic which can be used to access that relation; sorting each relation of the plurality of relations according to key structural characteristics of the respective relation; visually displaying in an over view the plurality of relations categorized according to the key structural characteristic thereof; visually displaying in the over view for each relation of the plurality of relations a respective bar that is representative of the number of the user selected data item therein; coloring in the over view each display of each relation that has the same key structural characteristic with a common color that is different from the coloring of the relations of the other key structural characteristics; visually displaying in the over view a cursor that is operator controllable over the display area; and changing the coloring of a visual display of a relation with which the cursor is actively contacting to indicate a selection thereof for a display of further information in another view.
Claim 6
Dependent Claim
29 words
The method as set forth in claim 3, further comprising the step of: displaying an additional view in an active window that displays further information about the cursor-selected relation.
Claim 7
Dependent Claim
39 words
The method as set forth in claim 4, further comprising the step of: as the cursor selects a different relation in the over view, displaying in the additional view further information of the different relation in the active window.
Claim 8
Dependent Claim
33 words
The method as set forth in claim 3, further comprising the steps of: displaying specification view having specifications of the selected relation from the specification of the large database in an active window.
Claim 9
Dependent Claim
83 words
The method as set forth in claim 3, further comprising the steps of: displaying an associations view showing the selected relation and attributes of the selected relation in a center portion of an active window; locating along a first side of the selected relation are one or more relations from which access to the selected relation can be provided; locating along a second side opposite the first side are one or more relations to which access from the selected relation can be provided.
Claim 10
Dependent Claim
106 words
The method as set forth in claim 3, further comprising the steps of: displaying an associations view showing the selected relation and attributes of the selected relation in a center portion of an active window; locating along a first side of the selected relation are one or more relations from which access to the selected relation can be provided; locating along a second side opposite the first side are one or more relations to which access from the selected relation can be provided; and locating along a top edge are one or more relations that can provide both access to and access from the selected relation.
Claim 11
Dependent Claim
35 words
The method as set forth in claim 3, further comprising the step of: displaying a code tree view showing a subtree of a source code tree that accesses the selected relation in an active window.
Claim 12
Dependent Claim
36 words
The method as set forth in claim 3, further comprising the step of: displaying a memory layout view showing a memory layout of the selected relation and attributes of the selected relation in an active window.
Claim 13
Dependent Claim
52 words
The method as set forth in claim 3, further comprising the steps of: displaying a domain view showing all defined domains of all of the attributes of the database in an active window; and highlighting each domain of the attributes of the selected relation in a different color than the other domains.
Claim 14
Dependent Claim
57 words
The method as set forth in claim 3, further comprising the steps of: displaying a path view showing the selected relation in an active window; selecting a second selected relation; showing the second relation in the path view active window; locating the selected relations opposite one another; and displaying a shortest access paths between the selected relations.
Claim 15
Dependent Claim
40 words
The method as set forth in claim 12, further comprising the step of: matching the colors of a frame of the active path view active window with the colors of the first and second selected relations in the over view.
Claim 16
Dependent Claim
42 words
The method as set forth in claim 13, further comprising the step of: matching the colors of a frame of the active path view active window with the colors outlining boxes representing the first and second selected relations in the path view.
Claim 17
Dependent Claim
154 words
Apparatus comprising: a large database having at least one thousand relations, each relation having a set of structural characteristics; each set of structural characteristics having a key structural characteristic that is used to access a respective relation of said each set of structural characteristics; means for visually displaying a plurality of views, each view appearing in an active window that can be sized from covering a fraction of the display area to covering the entire display area or turned off; means for counting a number of occurrences of a user selected data item for each relation; and means for visually displaying the plurality of relations, each relation of the plurality of relations is categorized according to at least one respective key structural characteristic of the respective relation in a first view and represented by a bar having a length that represents the number of occurrences of the user selected data item in the relation.
Claim 18
Dependent Claim
154 words
Apparatus comprising: a large database having at least one thousand relations, each relation having a set of structural characteristics; each set of structural characteristics having a key structural characteristic that is used to access a respective relation of said each set of structural characteristics; means for visually displaying a plurality of views, each view appearing in an active window that can be sized from covering a fraction of the display area to covering the entire display area or turned off; means for counting a number of occurrences of a user selected data item for each relation; and means for visually displaying the plurality of relations, each relation of the plurality of relations is categorized according to at least one respective key structural characteristic of the respective relation in a first view and represented by a bar having a length that represents the number of occurrences of the user selected data item in the relation.
References Cited (Backward Citations)
US5442690A
Cited
US5430870A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1999-11-05 | 2000-05-06 | 2000-11-05 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2003-11-05 | 2004-05-06 | 2004-11-05 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2007-11-05 | 2008-05-06 | 2008-11-05 | $7700.00 | Window Closed / Lapsed |