Browse Prior Art Database

Generating New Visual Query by an Append Function

IP.com Disclosure Number: IPCOM000102249D
Original Publication Date: 1990-Nov-01
Included in the Prior Art Database: 2005-Mar-17
Document File: 2 page(s) / 64K

Publishing Venue

IBM

Related People

Banning, KR: AUTHOR [+2]

Abstract

Disclosed is a function which allows the user to append the definition of a predefined query to the current query definition in order to form a new query. Even if a "cut-and-paste" technique is available, it is difficult to take advantage of using the definitions of predefined queries to build the new query. The SQL statements are text strings with a structure (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, etc.). The requirement to maintain this structure within the text string creates the problem. In a Visual Query model, each part of the query definition is visually presented in a separate graphical form according to the part of the structure involved.

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

Generating New Visual Query by an Append Function

       Disclosed is a function which allows the user to append
the definition of a predefined query to the current query definition
in order to form a new query.  Even if a "cut-and-paste" technique is
available, it is difficult to take advantage of using the definitions
of predefined queries to build the new query.  The SQL statements are
text strings with a structure (SELECT, FROM, WHERE, GROUP BY, HAVING,
ORDER BY, etc.).  The requirement to maintain this structure within
the text string creates the problem.  In a Visual Query model, each
part of the query definition is visually presented in a separate
graphical form according to the part of the structure involved.

      In Visual Query, each table in the FROM statement is presented
as an individual window, and the columns selected in those tables are
in highlight.  The WHERE clause is shown graphically in a separate
window. The summary functions (SUM, MIN, MAX, AVG, COUNT) and
expressions are put in a New Column table window, separated from the
other regular columns in real tables.  If Group By is defined, a
separate window with all column names and the chosen grouping columns
highlighted are displayed.  The Having clause, if any, is graphically
presented in a separate window.  When there is a need to merge two
query definitions to build a new query, it can be done by an APPEND
function. This function adds the visual representation of each
structure in one query definition to the same structure of the
current query. The u...