Browse Prior Art Database

Design for Directly Displaying the Definition of the Only Foreign Key

IP.com Disclosure Number: IPCOM000110080D
Original Publication Date: 1992-Oct-01
Included in the Prior Art Database: 2005-Mar-25
Document File: 2 page(s) / 63K

Publishing Venue

IBM

Related People

Li, SG: AUTHOR [+2]

Abstract

Disclosed is a user interface that directly displays a foreign key definition when the user opens a foreign key icon containing only one foreign key. qecause the index definitions can be treated similarly as the foreign key definitions, similar cases of index definitions also can use this design.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 52% of the total text.

Design for Directly Displaying the Definition of the Only Foreign Key

       Disclosed is a user interface that directly displays a
foreign key definition when the user opens a foreign key icon
containing only one foreign key.  qecause the index definitions can
be treated similarly as the foreign key definitions, similar cases of
index definitions also can use this design.

      In an iconic user interface design for database table
definition, a foreign key icon is associated with a column definition
if this column is used in any foreign key definition.  If a column is
involved in multiple foreign key definitions, its associated foreign
key icon contains a set of foreign key definitions.  Double clicking
on a foreign key icon of this type should not open the definition of
any single foreign key definition.

      Thus, most user interface designs will open a dialog box
containing a list of foreign key names for further user actions.
When a column is used in only one foreign key definition, its
associated foreign key icon contains only one foreign key name.  In
such case, double-clicking on a foreign key icon should open the
definition of the only foreign key definition directly without
forcing the user to go through the list.  Since the dialog box also
can show the foreign key's name, this direct display provides no less
information than the method that must go through a foreign key name
list.  For maintaining a consistent user interface design style, this
dialog box can explain th...