Browse Prior Art Database

Implicit Joins Within a Category

IP.com Disclosure Number: IPCOM000103327D
Original Publication Date: 1990-Oct-01
Included in the Prior Art Database: 2005-Mar-17
Document File: 1 page(s) / 51K

Publishing Venue

IBM

Related People

Banning, KR: AUTHOR [+3]

Abstract

Disclosed is a method for displaying the appropriate tables in iconic form which will bridge between the tables selected by the user to form appropriate join conditions. Most valid queries between multiple tables require a join condition where a key column between the two tables is necessary to retrieve the appropriate data. Categories are defined by database administrators so that the user may simply select the appropriate tables for their queries and the join condition is automatically known by the system. However, novice users may not always know the tables required which contain the appropriate columns for a valid join condition.

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

Implicit Joins Within a Category

      Disclosed is a method for displaying the appropriate tables in
iconic form which will bridge between the tables selected by the user
to form appropriate join conditions.  Most valid queries between
multiple tables require a join condition where a key column between
the two tables is necessary to retrieve the appropriate data.
Categories are defined by database administrators so that the user
may simply select the appropriate tables for their queries and the
join condition is automatically known by the system.  However, novice
users may not always know the tables required which contain the
appropriate columns for a valid join condition.

      When the user has chosen more than a single table from the
category window and exits the category window, the system will
determine if the two tables have a valid join condition.  If so, the
line indicating the two join columns will appear between the two
tables.  However, if the user chose tables which are not directly
joined, the system will determine the appropriate table or tables
that will allow a valid join.  This table(s) will be displayed by the
system along with the tables selected by the user when the visual
query window is updated.  The system supplied table(s) will be shown
as an icon(s) as opposed to the actual tables selected by the user so
that the user has immediate feedback that the system supplied a
table.  The algorithm will always supply the user with the simples...