Iconic table of database information

• US 5,485,567 A
• Filed: 09/15/1994
• Issued: 01/16/1996
• Est. Priority Date: 12/09/1991
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Shrader, Theodore, Banning, Kenneth R., Li, Shih-Gong, Erwin-Grotsky, George P., Sanchez-Frank, Alejandra
• Primary Examiner(s): Beausoliel, Jr., Robert W.
• Assistant Examiner(s): Elmore, Stephen C.
• Application Number:
  US08/306,902
• Time in Patent Office: 488 Days
• Field of Search: 395/148, 395/155, 395/159, 395/160, 395/161, 395/156, 395/157, 395/158, 395/12, 395/600
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 3/0489 using dedicated keyboard keys or combinations thereof
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 715/968 interface for database querying and retrieval

Abstract

A method, system and program for displaying database information via a table containing icons and other summary information which clearly and concisely convey particular aspects of a database to a user. The table display acts as a window into a database when it is selected by a user. A user can also make changes to the database via the window of information.

Claims

1. An apparatus for graphically displaying on a display information of a plurality of vertical columns in at least one table of a database, comprising:

(a) means for accessing a data structure in memory containing the information for each of the columns and generating icons representative of the information, wherein at least one of the icons represents a primary key having values uniquely identifying a single horizontal row of the plurality of vertical columns in the table;

(b) means for displaying the icons on the display; and

(c) means for placing alphanumeric representations of the information on the display, wherein at least one alphanumeric representation represents a number of the foreign keys that one of the columns belongs to.

2. An apparatus as recited in claim 1, wherein a second icon represents a foreign key.

3. An apparatus as recited in claim 1, wherein the icons change based on changes to the information.

4. An apparatus as recited in claim 1, including means for placing a second alphanumeric representation of the information on the display, wherein the second alphanumeric representation represents a column sequence number.

5. A method for graphically displaying information of a plurality of vertical columns of a database table on a display, comprising the steps of:

(a) accessing a data structure containing the information for each of the columns in the table and generating icons representative of the information, wherein at least one of the icons represents a primary key having values uniquely identifying a single horizontal row of the plurality of vertical columns in the table;

(b) displaying the icons on the display; and

(c) placing alphanumeric representations of the information on the display, wherein at least one alphanumeric representation represents a number of the foreign keys that one of the column belongs to.

6. A method as recited in claim 5, including the step of changing the icons based on changes to the information.

7. A method as recited in claim 5, including the step of accessing information in the data structure and placing a second alphanumeric representation of the information on the display, wherein the second alphanumeric representation represents a column sequence number.