Graphical user interface for relating key index properties to database table columns

• US 5,553,218 A
• Filed: 04/19/1995
• Issued: 09/03/1996
• Est. Priority Date: 03/09/1992
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Li, Shih-Gong, Shrader, Theodore J. L.
• Primary Examiner(s): Herndon, Heather R.
• Assistant Examiner(s): FEILD, JOSEPH H
• Application Number:
  US08/424,764
• Time in Patent Office: 503 Days
• Field of Search: 395/600, 395/148, 395/155, 395/157, 395/700, 395/161, 364/263.4
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A user interface for creating or changing the structure of a relational database having multiple tables linked by keys and arranged by indices. In one form, the invention contemplates the juxtaposed depiction on a computer video display of a matrix defining the structure of a table with one or more matrices defining the linking relationships between selected columns from that and related tables. Selection and movement through the data structure is accomplished by mouse actuated cursor. Referential integrity among the database tables is maintained through the use of primary and foreign keys. The relationships of the keys and indices to the columns of the tables are clearly represented in matrix format windows which appear concurrently with table column property information.

Claims

1. A user interface for defining the structure of a relational database in a computer system, comprising:

means for generating and displaying a first matrix which shows columns from a first table of the relational database;

means for generating and displaying a second matrix which shows columns from a second table of the relational database;

means for generating and displaying, in concurrence with the display of the first matrix, a primary key matrix showing columns from the first table in an order defining a primary key;

means for generating and display a foreign key matrix of table columns from the second matrix and table columns from the primary key matrix; and

means for a user of the interface to select and order table columns to define relationships in the foreign key matrix.

2. The user interface recited in claim 1, wherein the matrices are depicted in individual windows on a display.

3. A method of generating on a display of a computer system a user interface for a relational database, comprising the steps of:

generating and displaying a first matrix which shows columns from a first table of the relational database;

generating and displaying a second matrix which shows columns from a second table of the relational database;

generating and displaying, in concurrence with the display of the first matrix, a primary key matrix showing columns from the first table in an order defining a primary key;

generating and displaying a foreign key matrix of table columns from the second matrix and table columns from the primary key matrix; and

selecting and ordering of table columns to define relationships in the foreign key matrix.

4. The method recited in claim 3, wherein the matrices are depicted in individual windows on the display.

5. A computer useable medium having computer readable program code for generating by a computer a user interface which defines a structure for a relational database within the computer, comprising:

means for generating and displaying a first matrix which shows columns from a first table of the relational database;

means for generating and displaying a second matrix which shows columns from a second table of the relational database;

means for generating and displaying in concurrence with the display of the first matrix, a primary key matrix showing columns from the first table in an order defining a primary key;

means for generating and displaying a foreign key matrix of table columns from the second matrix and table columns from the primary key matrix; and

means for a user of the interface to select and order table columns to define relationships in the foreign key matrix.

6. The computer usable medium recited in claim 5, wherein the matrices are depicted in individual windows on a display.