Browse Prior Art Database

System Supplied Tables Based On Key Word Search

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

Publishing Venue

IBM

Related People

Banning, KR: AUTHOR [+3]

Abstract

Disclosed is an easy way for the user to query information known by the system to display potential candidate tables and columns based on information provided by the user. Often while building a query, the user may have an idea of which tables might contain specific columns they wish to retrieve or know something about the data within that column. For instance, they may know that the information that they require is in one of two or three related tables and they may know that the field contains employee ids. However, they may not be sure of exactly which table or column name is required for a query. The current way of finding out this information is usually by maintaining written documentation or the user may run queries against the individual tables and note the exact tables and column names needed to define the query.

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

System Supplied Tables Based On Key Word Search

      Disclosed is an easy way for the user to query information
known by the system to display potential candidate tables and columns
based on information provided by the user. Often while building a
query, the user may have an idea of which tables might contain
specific columns they wish to retrieve or know something about the
data within that column.  For instance, they may know that the
information that they require is in one of two or three related
tables and they may know that the field contains employee ids.
However, they may not be sure of exactly which table or column name
is required for a query.  The current way of finding out this
information is usually by maintaining written documentation or the
user may run queries against the individual tables and note the exact
tables and column names needed to define the query.

      The user first selects a category of tables where it is likely
that the information resides.  The user then selects a "search"
option from a pull-down.  A dialog box is presented for the entry of
key words that might appear in either a column name or column
comment.  Once this dialog box is committed, the system searches the
system information (SYSCOLS) table for the key words.  When the
search is complete, the system will display the table(s) that match
the condition.

      This gives the user an easy method for obtaining the
appropriate table and column names based on informa...