US5386571A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Computer system and method for storing and displaying of a semantically structured entity relationship diagram
Assignee: International Business Machines Corp
•
Filing: 1993-09-17
•
Granted: 1995-01-31
•
Expires: 2013-09-17
Abstract
Abstract The invention concerns a method and system for storing and displaying an entity relationship diagram. The entity relationship diagram of the invention is composed of only four different classes of allowed entity types. Thereby redundancy is eliminated and less storage locations are needed to store the diagram. The diagram comprises kernel entity sets K, attributive entity sets A, role entity sets P and relation entity sets R which are displayed on a display 9.
Inventors
- 👤 Wolfgang Kurz
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 23:39
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/284; G06F16/288
Claims Analysis
Total Claims: 22
Claim 1
Independent Claim
207 words
A method for storing and displaying of an entity relationship diagram in a computer system comprising storage means, said method comprising the steps of a) storing of first data representative of a sequence of kernel entity sets K i , where a kernel entity set K i is a class of kernel entities e i ; b) storing of second data representative of relation entity sets R i , where a relation entity set R i is a class of relations among a number n of kernel entities e i , each taken from a kernel entity set K i according to the definition D ##EQU2## and where the kernel entity sets K i in the definition D may not be distinct, whereby said second data comprise information as to the assignment of each of said relation entity sets R i to at least one of said kernel entity sets; c) logically partitioning a display into at least a first and a second section; d) displaying of the kernel entity sets K i represented by a first class of symbols in said first section of said display; and displaying of the relation entity sets R i represented by a second class of symbols in said second section.
Claim 2
Independent Claim
207 words
A method for storing and displaying of an entity relationship diagram in a computer system comprising storage means, said method comprising the steps of a) storing of first data representative of a sequence of kernel entity sets K i , where a kernel entity set K i is a class of kernel entities e i ; b) storing of second data representative of relation entity sets R i , where a relation entity set R i is a class of relations among a number n of kernel entities e i , each taken from a kernel entity set K i according to the definition D ##EQU2## and where the kernel entity sets K i in the definition D may not be distinct, whereby said second data comprise information as to the assignment of each of said relation entity sets R i to at least one of said kernel entity sets; c) logically partitioning a display into at least a first and a second section; d) displaying of the kernel entity sets K i represented by a first class of symbols in said first section of said display; and displaying of the relation entity sets R i represented by a second class of symbols in said second section.
Claim 3
Dependent Claim
100 words
A method for storing of an entity relationship diagram according to claim 1, said method further comprising the steps of storing of third data representative of role entity sets P i , where a role entity set P i is a class of roles of entities e i comprised in a kernel entity set K i , whereby said third data comprise information to which one of said kernel entity sets K i a role entity set P i belongs; and displaying at least one of said role entity sets by a third class of symbols in said first section.
Claim 4
Dependent Claim
142 words
A method for storing of an entity relationship diagram according to claim 2, said method further comprising the steps of storing of fourth data representative of attributive entity sets A i , where each attributive entity set A i has an attribute associated thereto and an attribute is defined as a function f which maps from a kernel entity set K i or a role entity set P i into an attributive entity set A i or a cartesian product of attributive entity sets A i f: K.sub.i or P.sub.i →A.sub.i or A.sub.i1 ×A.sub.i2 ×A.sub.in, whereby said fourth data comprise information to which one of said kernel entity sets K i or said role entity sets P i an attributive entity set A i belongs; and displaying said attributive entry sets represented by a fourth class of symbols in said first section.
Claim 5
Dependent Claim
48 words
A method according to claim 3, wherein the order of kernel entity sets K i in said sequence is defined by an index x i which is assigned to each of said kernel entity sets K i , said index x i being comprised in said first data.
Claim 6
Dependent Claim
81 words
A method according to claim 4, wherein said step of logically dividing said display into two sections is along a horizontal or vertical line and said method further comprising the steps of storing of further first data representative of a further kernel entity set K i , whereby the position of said further kernel entity set K i in said sequence is defined by assigning an index x i ; and displaying said kernel entry sets K i along said line.
Claim 7
Independent Claim
154 words
A method for displaying of an entity relationship diagram on the display of a computer system, said entity relationship diagram being stored in said computer system, characterized by the steps of a) logically partitioning said display into at least a first and a second section; b) displaying of kernel entity sets K i represented by a first class of symbols in said first section of said display, where a kernel entity set K i is a class of kernel entities e i ; c) displaying of relation entity sets R i represented by a second class of symbols in said second section, where a relations entity set R i is a class of relations among a number n of kernel entities e i , each taken from a kernel entity set K i according to the definition D ##EQU3## whereby the kernel entity sets K i in the definition D may not be distinct.
Claim 8
Independent Claim
154 words
A method for displaying of an entity relationship diagram on the display of a computer system, said entity relationship diagram being stored in said computer system, characterized by the steps of a) logically partitioning said display into at least a first and a second section; b) displaying of kernel entity sets K i represented by a first class of symbols in said first section of said display, where a kernel entity set K i is a class of kernel entities e i ; c) displaying of relation entity sets R i represented by a second class of symbols in said second section, where a relations entity set R i is a class of relations among a number n of kernel entities e i , each taken from a kernel entity set K i according to the definition D ##EQU3## whereby the kernel entity sets K i in the definition D may not be distinct.
Claim 9
Dependent Claim
71 words
A method according to claim 6, said kernel entity sets K i comprising role entity sets P i , where a role entity set P i is a class of roles of entities e i comprised in a kernel entity set K i , said method further comprising a step of displaying at least one of said role entity sets represented by a third class of symbols in said first section.
Claim 10
Dependent Claim
106 words
A method according to claim 7, said kernel entity sets K i comprising attributive entity sets A i , where each attributive entity set has an attribute associated thereto and an attribute is defined as a function f which maps from a kernel entity set K i or a role entity set P i into an attributive entity set A i or a cartesian product of attributive entity sets A i f: K.sub.i or P.sub.i →A.sub.i or A.sub.i1 ×A.sub.12 ×. . . ×A.sub.in, said method further comprising a step of displaying said attributive entity sets represented by a fourth class of symbols in said first section.
Claim 11
Dependent Claim
29 words
A method according to claim 8, said method further comprising the steps of defining an array of allowable positions on said display; and arranging said symbols in said positions.
Claim 12
Dependent Claim
38 words
A method according to claim 9, said partitioning step comprising a step of logically dividing said display into two sections along a horizontal or vertical line, whereby said kernel entity sets K i are displayed along that line.
Claim 13
Dependent Claim
16 words
A method according to claim 10, wherein said entity relationship diagram is stored as a vectorgraph.
Claim 14
Dependent Claim
153 words
A method according to claim 10, wherein said entity relationship diagram is stored in a computer system comprising storage means, said method further comprising the steps of a) storing of first data representative of a sequence of kernel entity sets K i , where a kernel entity set K i is a class of kernel entities e i ; b) storing of second data representative of relation entity sets R i , where a relation entity set R i is a class of relations among a number n of kernel entities e i , each taken from a kernel entity set K i according to the definition D ##EQU4## and where the kernel entity sets K i in the definition D may not be distinct, whereby said second data comprise information as to the assignment of each of said relation entity sets R i to at least one of said kernel entity sets.
Claim 15
Dependent Claim
39 words
A method according to claim 10, wherein the absolute and/or relative position of each kernel entity set K i which is displayed along that line is determined by the order of kernel entity sets K i in said sequence.
Claim 16
Dependent Claim
37 words
A method according to claim 6, wherein symbols belonging to different ones of said classes of symbols have a different shape and symbols belonging to the same class of symbols may only differ as to their size.
Claim 17
Dependent Claim
16 words
A method according to claim 14, wherein relations within said class of relations are mathematical relations.
Claim 18
Dependent Claim
215 words
A computer system for displaying of an entity relationship diagram, said system comprising a) means for storing of first data representative of a sequence of kernel entity sets K i , where a kernel entity set is a class of kernel entities e i and for storing of second data representative of relation entity sets R i , where a relation entity set R i is a class of relations among a number n of kernel entities e i , each taken from a kernel entity set K i according to the definition D ##EQU5## and where the kernel entity sets K i in the definition D may not be distinct, whereby said second data comprise information as to the assignment of each of said relation entity sets R i to at least one of said kernel entity sets, b) display means logically partitioned into at least a first and a second section, c) means for generating a first class of symbols to display a representation of said kernel entity sets in said first section and for generating a second class of symbols to display a representation of said relation entity sets R i in said second section, whereby said means for generating are interconnected to said means for storing and to said display means.
Claim 19
Dependent Claim
215 words
A computer system for displaying of an entity relationship diagram, said system comprising a) means for storing of first data representative of a sequence of kernel entity sets K i , where a kernel entity set is a class of kernel entities e i and for storing of second data representative of relation entity sets R i , where a relation entity set R i is a class of relations among a number n of kernel entities e i , each taken from a kernel entity set K i according to the definition D ##EQU5## and where the kernel entity sets K i in the definition D may not be distinct, whereby said second data comprise information as to the assignment of each of said relation entity sets R i to at least one of said kernel entity sets, b) display means logically partitioned into at least a first and a second section, c) means for generating a first class of symbols to display a representation of said kernel entity sets in said first section and for generating a second class of symbols to display a representation of said relation entity sets R i in said second section, whereby said means for generating are interconnected to said means for storing and to said display means.
Claim 20
Dependent Claim
98 words
A computer system according to claim 16, wherein said means for storing stores third data representative of role entity sets P i , where a role entity set P i is a class of roles of entities e i comprised in a kernel entity set K i , whereby said third data comprise information to which one of said kernel entity sets K i a role entity set P i belongs, and said means for generating is adapted to generate a third class of symbols to display a representation of said kernel entity sets in said first section.
Claim 21
Dependent Claim
142 words
A computer system according to claim 17, wherein said means for storing stores fourth data representative of attributive entity sets A i , where each attributive entity set has an attribute associated thereto and an attribute is defined as a function f which maps from a kernel entity set K i or a role entity set P i into an attributive entity set A i or a cartesian product of attributive entity sets A i f: K.sub.i or P.sub.i →A.sub.i or A.sub.i1 ×A.sub.i2 ×. . . ×A.sub.in, whereby said fourth data comprise information to which one of said kernel entity sets K i or said role entity sets P i an attributive entity set belongs, and said means for generating is adapted to generate a fourth class of symbols to display a representation of said attributive entity sets in said first section.
Claim 22
Dependent Claim
25 words
A computer system according to claim 16, said system comprising input means, such as a mouse, especially to define the partitioning of said display means.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1998-01-30 | 1998-08-01 | 1999-01-31 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2002-01-30 | 2002-08-01 | 2003-01-31 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2006-01-30 | 2006-08-01 | 2007-01-31 | $7700.00 | Window Closed / Lapsed |