User-defined relationships for diagramming user-defined database relations

• US 6,915,298 B1
• Filed: 02/09/2000
• Issued: 07/05/2005
• Est. Priority Date: 02/09/2000
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Pfeifer, Michael Donald, Cain, Michael W., Milligan, Kenton R., Johnson, Peter John
• Primary Examiner(s): Robinson, Greta
• Assistant Examiner(s): PANNALA, SATHYANARAYA R
• Application Number:
  US09/500,648
• Time in Patent Office: 1,973 Days
• Field of Search: 707/3, 707100-1041, 707/103.R, 345/968
• US Class Current: 1/1
• CPC Class Codes: G06F 16/288 Entity relationship models
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 715/968 interface for database querying and retrieval

Abstract

A schema diagrammer aids a database administrator or other user in maintaining and managing a database in a computer system. The schema diagrammer allows the user to define “user-defined relationships” between objects in the database. The schema diagrammer generates a graphical schema diagram or map that indicates the objects and their relationships to one another. The relationships that are displayed include both the formal relationships defined programmatically by the database itself and the user-defined relationships.

Claims

1. A method for adding user-defined database relationships to a schema diagram, comprising the steps of:

defining formal database relationships between objects in a database schema, said formal database relationships having an operational effect upon a database engine;

storing said formal database relationships in database files accessible by said database engine for said database engine to operate upon;

forming a graphical schema diagram map having graphical indicia representing said objects and graphical indicia representing said formal database relationships;

graphically displaying said retrieved schema diagram map for a user;

said user defining user-defined database relationships between said objects, said user-defined database relationships having no operational effect upon said database engine;

storing said user-defined database relationships separately from said database files, said user-defined database relationships inaccessible to said database engine;

modifying said retrieved schema diagram map to further include graphical indicia representing said user-defined database relationships; and

graphically displaying said modified schema diagram map for a user.

2. The method claimed in claim 1, wherein said step of defining user-defined database relationships comprises the steps of:

querying said database files to determine said objects

graphically displaying a list of said objects; and

said user selecting a set of said objects related by one of said user-defined relationships; and

said user selecting graphical indicia to represent a user-defined database relationship between objects of said set.

3. The method claimed in claim 2, wherein:

said step of said user selecting graphical indicia comprises said user selecting an icon shape and an icon color; and

said step of graphically displaying said modified schema diagram map for a user said comprises displaying an icon having said shape and said color and graphically oriented on said schema diagram map to relate said objects of said set to one another.

4. The method claimed in claim 2, wherein:

said step of said user selecting graphical indicia comprises said user selecting a name; and

said step of graphically displaying said modified schema diagram map for a user said comprises displaying an icon labeled with said name and graphically oriented on said schema diagram map to relate said objects of said set to one another.

15. The method claimed in claim 1, wherein the operational effect comprises changing how the database engine stores, retrieves and queries the objects in the data set.

16. The method claimed in claim 1, further comprising retrieving a previously-created schema diagram map.

5. A computer system having a database schema diagrammer, comprising:

a non-volatile storage medium having database files representing a database;

a main memory;

a programmed processor;

a database engine executable in said main memory under control of said programmed processor;

a schema diagrammer for forming a graphical schema diagram map having graphical indicia representing objects in said database and formal database relationships between said objects and for displaying said schema diagram map for a user, said formal database relationships having an operational effect upon said database engine, said schema diagrammer further for modifying said graphical schema diagram map to further include user-defined database relationships between said objects, said user-defined database relationships having no operational effect upon said database engine and stored in said database files separately from said formal database relationships and not accessible to said database engine.

6. The computer system claimed in claim 5, wherein said schema diagrammer includes a user interface that queries said database files to determine said objects and graphically displays a list of said objects from which said user can select a set of said objects related by one of said user-defined relationships.

7. The computer system claimed in claim 6, wherein said user interface provides graphical indicia from which a user can select to represent a user-defined database relationship between objects of said set.

8. The computer system claimed in claim 7, wherein said user can select an icon shape and an icon color.

9. The computer system claimed in claim 7, wherein said user can select an icon name.

10. A computer program product for a computer system having a database, comprising at least one signal-bearing medium usable by said computer system, the signal-bearing medium carrying thereon:

a schema diagrammer for forming a graphical schema diagram map having graphical indicia representing objects in said database and formal database relationships between said objects and for displaying said schema diagram map for a user, said formal database relationships having an operational effect upon a database engine, said schema diagrammer further for modifying said graphical schema diagram map to further include user-defined database relationships between said objects, said user-defined database relationships having no operational effect upon said database engine and stored in said database separately from said formal database relationships and not accessible to said database engine.

11. The computer program product claimed in claim 10 wherein said schema diagrammer includes a user interface that queries said database files to determine said objects and graphically displays a list of said objects from which said user can select a set of said objects related by one of said user-defined relationships.

12. The computer program product claimed in claim 11, wherein said user interface provides graphical indicia from which a user can select to represent a user-defined database relationship between objects of said set.

13. The computer program product claimed in claim 12, wherein said user can select an icon shape and an icon color.

14. The computer program product claimed in claim 12, wherein said user can select an icon name.