Data processing: database and file management or data structures – Database design – Data structure types
Patent
1998-01-09
1999-08-03
Black, Thomas G.
Data processing: database and file management or data structures
Database design
Data structure types
101102, G06F 1730
Patent
active
059338318
ABSTRACT:
An entity relationship diagram for a relational database is generated from introspection of the relational database to determine which entities should be included within a specific table to be displayed. Tables within the entity relationship diagram are displayed with icons hyperlinked to other portions or displays of the entity relationship diagram. A trigger icon links the displayed table to a display of the trigger information for the displayed table. A primary key icon indicates which column of the displayed table is utilized as the primary key for the displayed table, while a foreign key icon links the displayed table to a display of another table in the entity relationship diagram containing the foreign key. Dashed or dotted lines and dot or diamond terminators associated with the foreign key icon described the relationship between the displayed table and the linked table. A constraint icon links the displayed table to a display of the constraint information for an entity. A menu icon links the displayed table to a pop-up menu of child tables for the display table. Entity relationship diagrams for relational databases may thus be viewed in manageable, easily comprehensible portions, with links between tables directly associating the displayed table with the proper portions of the linked tables. The entity relationship diagram automatically reflects changes to the corresponding relational database.
REFERENCES:
patent: 4479196 (1984-10-01), Ferrer et al.
patent: 5019961 (1991-05-01), Addesso et al.
patent: 5146591 (1992-09-01), Bachman et al.
patent: 5204947 (1993-04-01), Bernstein et al.
patent: 5241645 (1993-08-01), Cimral et al.
patent: 5249300 (1993-09-01), Bachman et al.
patent: 5386571 (1995-01-01), Kurz
patent: 5392220 (1995-02-01), Van Den Hamer et al.
patent: 5428776 (1995-06-01), Rothfield
patent: 5487135 (1996-01-01), Freeman
patent: 5495567 (1996-02-01), Iizawa et al.
patent: 5506984 (1996-04-01), Miller
patent: 5535325 (1996-07-01), Catell et al.
patent: 5564119 (1996-10-01), Krawchuk et al.
Barker, A Logical Model and Schema Integration Architecture for Determining Equivalence in ER-Diagrams, Computing and Information, 1992. Proceedings. ICCI 1992., Fourth International, pp. 320-324, May 1992.
Song et al, Entity Relatioship Modeling, IEEE Potentials, vol. 13, Issue 5, pp. 29-34, Jan. 1995.
What's KnULink?; World Wide Web; Updated on Mar. 24, 1996.
The Simple Story of Aqui; World Wide Web; Updated on Mar. 3, 1996.
Black Thomas G.
Coby Frantz
LSI Logic Corporation
Lucente David K.
LandOfFree
Viewing entity relationship diagrams using hyperlinks does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Viewing entity relationship diagrams using hyperlinks, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Viewing entity relationship diagrams using hyperlinks will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-860437