US5535325A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for automatically generating database definitions of indirect facts from entity-relationship diagrams
Assignee: International Business Machines Corp
•
Filing: 1994-12-19
•
Granted: 1996-07-09
•
Expires: 2014-12-19
Abstract
Abstract A computer-implemented process accepts information input from an existing ER model of data representing a given environment and, in response to the input, automatically creates a new database structural definition that represents indirect facts about a base entity that are indicated by the input.
Inventors
- 👤 Kevin T. Cattell
- 👤 William R. Cromer
- 👤 Shihta Lin
- 👤 Bruce E. Neuchterlein
- 👤 Thomas E. Potok
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-01 01:06
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/284; G06F16/288; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99943; Y10S715/00; Y10S715/961; Y10S715/965; Y10S715/966; Y10S715/967
Claims Analysis
Total Claims: 14
Claim 1
Independent Claim
319 words
In a computer system comprising a computer processor, a database storage, a display and input means, a program memory and a program loaded therein wherein said loaded program automatically generates and displays on said display a database definitional plan for indirect facts associated with the database entity data, a computer process comprising steps performed in said computer of: generating in said processor of said computer and displaying on said display means a first graphical placeholder block in a database definitional diagram for a user identified target indirect fact regarding a user identified target entity in an entity-relationship (ER) model of the user's business environment; generating in said processor and displaying on said display means a second graphical placeholder block in a database definitional diagram for an indirect fact derivation argument; generating in said processor and displaying on said display means a third graphical placeholder block in a database definitional diagram for an indirect fact derivation argument for an associative entity type relationship link; generating in said processor and displaying on said display means a graphical path connecting said first graphical placeholder block to the said base entity of said database definitional diagram; generating in said processor and displaying on said display means a graphical path connecting said second graphical placeholder block to said first graphical placeholder block; generating in said processor and displaying on said display means a graphical path connecting said third graphical placeholder block to said first graphical placeholder block; generating in said processor and displaying on said display means a graphical path connecting said third graphical placeholder block to the first relationship link representational block in said database definitional diagram encountered in a traverse of said diagram from said base entity of said diagram to said first graphical placeholder block; and generating in said CPU and displaying on said display means a graphical path connecting said second graphical placeholder block to said user identified target entity.
Claim 2
Dependent Claim
319 words
In a computer system comprising a computer processor, a database storage, a display and input means, a program memory and a program loaded therein wherein said loaded program automatically generates and displays on said display a database definitional plan for indirect facts associated with the database entity data, a computer process comprising steps performed in said computer of: generating in said processor of said computer and displaying on said display means a first graphical placeholder block in a database definitional diagram for a user identified target indirect fact regarding a user identified target entity in an entity-relationship (ER) model of the user's business environment; generating in said processor and displaying on said display means a second graphical placeholder block in a database definitional diagram for an indirect fact derivation argument; generating in said processor and displaying on said display means a third graphical placeholder block in a database definitional diagram for an indirect fact derivation argument for an associative entity type relationship link; generating in said processor and displaying on said display means a graphical path connecting said first graphical placeholder block to the said base entity of said database definitional diagram; generating in said processor and displaying on said display means a graphical path connecting said second graphical placeholder block to said first graphical placeholder block; generating in said processor and displaying on said display means a graphical path connecting said third graphical placeholder block to said first graphical placeholder block; generating in said processor and displaying on said display means a graphical path connecting said third graphical placeholder block to the first relationship link representational block in said database definitional diagram encountered in a traverse of said diagram from said base entity of said diagram to said first graphical placeholder block; and generating in said CPU and displaying on said display means a graphical path connecting said second graphical placeholder block to said user identified target entity.
Claim 3
Dependent Claim
132 words
A process as described in claim 1, further comprising when said indirect fact type sought by said user is an indirect relationship of an entity, comprising further steps of: generating in said processor and displaying on said display means a fourth graphical placeholder block in a database definitional diagram for an associative entity type; generating in said processor and displaying on said display means a fifth graphical placeholder block for a relationship link; and generating in said processor and displaying on said display means a graphical connection from said first graphical placeholder block to said fourth placeholder block and from said fourth placeholder block to said fifth placeholder block, said connections being a part of said graphical path connecting said first placeholder block to said base entity of said database definitional diagram.
Claim 4
Dependent Claim
55 words
A process as described in claim 1, wherein: said process further includes steps of receiving user inputs identifying a name for the user's requested indirect fact type, an identification of the base entity with which said indirect fact type is connected, and an identification of the target indirect fact type for which retrieval is sought.
Claim 5
Dependent Claim
61 words
A process is described in claim 2, wherein said process further includes steps of: said process further includes steps of receiving user inputs identifying a name for the user's requested indirect fact type, an identification of the base entity with which said indirect fact type is connected, and an identification of the target indirect fact type for which retrieval is sought.
Claim 6
Dependent Claim
291 words
A CASE tool comprising instructions encoded on a computer-readable medium for automatically generating database definitional diagrams from ER diagrams on the display of a computer system, said tool comprising means for performing steps of: generating in said computer and displaying on said display means a first graphical placeholder block in a database definitional diagram for a user requested indirect fact regarding a user identified target entity in an entity-relationship (ER) model of the user's business environment; generating in said processor and displaying on said display means a second graphical placeholder block in a database definitional diagram for an indirect fact derivation argument; generating in said processor and displaying on said display means a third graphical placeholder block in a database definitional diagram for an indirect fact derivation argument for an associative entity type relationship link; generating in said processor and displaying on said display means a graphical path connecting said first graphical placeholder block to the said base entity of said database definitional diagram; generating in said processor and displaying on said display means a graphical path connecting said second graphical placeholder block to said first graphical placeholder block; generating in said processor and displaying on said display means a graphical path connecting said third graphical placeholder block to said first graphical placeholder block; generating in said processor and displaying on said display means a graphical path connecting said third graphical placeholder block to the first relationship link representational block in said database definitional diagram encountered in a traversed of said diagram from said base entity of said diagram to said first graphical placeholder block; and generating in said processor and displaying on said display means a graphical path connecting said second graphical placeholder block to said user identified target entity.
Claim 7
Dependent Claim
291 words
A CASE tool comprising instructions encoded on a computer-readable medium for automatically generating database definitional diagrams from ER diagrams on the display of a computer system, said tool comprising means for performing steps of: generating in said computer and displaying on said display means a first graphical placeholder block in a database definitional diagram for a user requested indirect fact regarding a user identified target entity in an entity-relationship (ER) model of the user's business environment; generating in said processor and displaying on said display means a second graphical placeholder block in a database definitional diagram for an indirect fact derivation argument; generating in said processor and displaying on said display means a third graphical placeholder block in a database definitional diagram for an indirect fact derivation argument for an associative entity type relationship link; generating in said processor and displaying on said display means a graphical path connecting said first graphical placeholder block to the said base entity of said database definitional diagram; generating in said processor and displaying on said display means a graphical path connecting said second graphical placeholder block to said first graphical placeholder block; generating in said processor and displaying on said display means a graphical path connecting said third graphical placeholder block to said first graphical placeholder block; generating in said processor and displaying on said display means a graphical path connecting said third graphical placeholder block to the first relationship link representational block in said database definitional diagram encountered in a traversed of said diagram from said base entity of said diagram to said first graphical placeholder block; and generating in said processor and displaying on said display means a graphical path connecting said second graphical placeholder block to said user identified target entity.
Claim 8
Dependent Claim
114 words
A CASE tool as described in claim 5, and further comprising: generating in said computer and displaying on said display means a fourth graphical placeholder block in a database definitional diagram for an associative entity type; generating in said computer and displaying on said display means a fifth graphical placeholder block for a relationship link; and generating in said computer and displaying on said display means a graphical connection from said first graphical placeholder block to said fourth placeholder block and from said fourth placeholder block to said fifth placeholder block, said connections being a part of said graphical path connecting said first placeholder block to said base entity of said database definitional diagram.
Claim 9
Dependent Claim
58 words
A CASE tool as described in claim 5, wherein: said process further includes steps of receiving user inputs identifying a name for the user's requested indirect fact type, an identification of the base entity or relationship with which said indirect fact type is connected, and an identification of the target indirect fact type for which retrieval is sought.
Claim 10
Dependent Claim
59 words
A CASE tool as described in claim 6, further including: said process further includes steps of receiving user inputs identifying a name for the user's requested indirect fact type, an identification of the base entity or relationship with which said indirect fact type is connected, and an identification of the target indirect fact type for which retrieval is sought.
Claim 11
Dependent Claim
255 words
In a computer system comprising a computer processor, a database storage, a display and input means, a program memory and a program loaded therein wherein said loaded program automatically generates a database definitional plan for indirect facts associated with the database entity data, a computer process comprising steps performed in said computer of: generating in said processor of said computer a first graphical placeholder in a database definitional diagram for a user requested indirect fact regarding a user identified target entity in an entity-relationship (ER) model of the user's business environment; generating in said processor a second graphical placeholder in a database definitional diagram for an indirect fact derivation argument; generating in said processor a third graphical placeholder in a database definitional diagram for an indirect fact derivation argument for an associative entity type relationship link; generating in said processor a graphical path connecting said first graphical placeholder to the said base entity of said database definitional diagram; generating in said processor a graphical path connecting said second graphical placeholder to said first graphical placeholder; generating in said processor a graphical path connecting said third graphical placeholder to said first graphical placeholder; generating in said processor a graphical path connecting said third graphical placeholder to the first associative entity type representational block in said database definitional diagram encountered in a traversed of said diagram from said base entity of said diagram to said first graphical placeholder; and generating in said processor a graphical path connecting said second graphical placeholder to said user identified target entity.
Claim 12
Dependent Claim
255 words
In a computer system comprising a computer processor, a database storage, a display and input means, a program memory and a program loaded therein wherein said loaded program automatically generates a database definitional plan for indirect facts associated with the database entity data, a computer process comprising steps performed in said computer of: generating in said processor of said computer a first graphical placeholder in a database definitional diagram for a user requested indirect fact regarding a user identified target entity in an entity-relationship (ER) model of the user's business environment; generating in said processor a second graphical placeholder in a database definitional diagram for an indirect fact derivation argument; generating in said processor a third graphical placeholder in a database definitional diagram for an indirect fact derivation argument for an associative entity type relationship link; generating in said processor a graphical path connecting said first graphical placeholder to the said base entity of said database definitional diagram; generating in said processor a graphical path connecting said second graphical placeholder to said first graphical placeholder; generating in said processor a graphical path connecting said third graphical placeholder to said first graphical placeholder; generating in said processor a graphical path connecting said third graphical placeholder to the first associative entity type representational block in said database definitional diagram encountered in a traversed of said diagram from said base entity of said diagram to said first graphical placeholder; and generating in said processor a graphical path connecting said second graphical placeholder to said user identified target entity.
Claim 13
Dependent Claim
233 words
A CASE tool comprising instructions encoded on a computer-readable medium for automatically generating database definitional diagrams from ER diagrams on the display of a computer system, said tool comprising means for performing steps of: generating in said computer a first graphical placeholder in a database definitional diagram for a user requested indirect fact regarding a user identified target entity in an entity-relationship (ER) model of the user's business environment; generating in said computer a second graphical placeholder in a database definitional diagram for an indirect fact derivation argument; generating in said computer a third graphical placeholder in a database definitional diagram for an indirect fact derivation argument for an associative entity type relationship link; generating in said computer a graphical path connecting said first graphical placeholder to the said base entity of said database definitional diagram; generating in said computer a graphical path connecting said second graphical placeholder to said first graphical placeholder; generating in said computer a graphical path connecting said third graphical placeholder to said first graphical placeholder; generating in said computer a graphical path connecting said third graphical placeholder to the first associative entity type representational block in said database definitional diagram encountered in a traversed of said diagram from said base entity of said diagram to said first graphical placeholder; and generating in said computer a graphical path connecting said second graphical placeholder to said user identified target entity.
Claim 14
Dependent Claim
233 words
A CASE tool comprising instructions encoded on a computer-readable medium for automatically generating database definitional diagrams from ER diagrams on the display of a computer system, said tool comprising means for performing steps of: generating in said computer a first graphical placeholder in a database definitional diagram for a user requested indirect fact regarding a user identified target entity in an entity-relationship (ER) model of the user's business environment; generating in said computer a second graphical placeholder in a database definitional diagram for an indirect fact derivation argument; generating in said computer a third graphical placeholder in a database definitional diagram for an indirect fact derivation argument for an associative entity type relationship link; generating in said computer a graphical path connecting said first graphical placeholder to the said base entity of said database definitional diagram; generating in said computer a graphical path connecting said second graphical placeholder to said first graphical placeholder; generating in said computer a graphical path connecting said third graphical placeholder to said first graphical placeholder; generating in said computer a graphical path connecting said third graphical placeholder to the first associative entity type representational block in said database definitional diagram encountered in a traversed of said diagram from said base entity of said diagram to said first graphical placeholder; and generating in said computer a graphical path connecting said second graphical placeholder to said user identified target entity.
References Cited (Backward Citations)
US5179698A
Cited
US5193183A
Cited
US5193182A
Cited
US5195178A
Cited
US5212771A
Cited
US5241645A
Cited
US5249300A
Cited
US5388196A
Cited
US5297249A
Cited
US5315709A
Cited
US5428776A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1999-07-09 | 2000-01-08 | 2000-07-09 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2003-07-09 | 2004-01-08 | 2004-07-09 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2007-07-09 | 2008-01-08 | 2008-07-09 | $7700.00 | Window Closed / Lapsed |