Browse Prior Art Database

Improved Query Understanding Through the Use of a New Column Window

IP.com Disclosure Number: IPCOM000101754D
Original Publication Date: 1990-Aug-01
Included in the Prior Art Database: 2005-Mar-16
Document File: 2 page(s) / 68K

Publishing Venue

IBM

Related People

Banning, KR: AUTHOR [+3]

Abstract

Disclosed is the method to directly specify expressions as if they were columns in the SQL tables. This allows the expressions to be manipulated in an identical manner as existing columns. The user interface design will enforce those special considerations that exist for expressions.

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

Improved Query Understanding Through the Use of a New Column Window

       Disclosed is the method to directly specify expressions
as if they were columns in the SQL tables.  This allows the
expressions to be manipulated in an identical manner as existing
columns.  The user interface design will enforce those special
considerations that exist for expressions.

      A user involved in defining a database query may be required to
use an expression.  This expression may be a mathematical change to a
single existing column, or a combination of columns.  Existing user
interfaces to this task treat the expression as a unique interface
that is different than other columns.  This reduces the useability of
the product by requiring that the user conceptualize the expression
as different.  This results in unique dialogs for use of expressions
and cost to developer and user of those differences.

      A query may use expressions for two general purposes. First,
the expression may be a set of values the user wishes to include in
the resulting records that represent a change from the actual values
existing in the database.  An expression may also be defined to be
used as part of the Row Condition definition.  Examples of some
common expressions are:
      Salary+Commission  (Total compensation)
                    --or--
      Price*1.06  (Price plus tax)

      The user could include the first example in a report on the
total compensation to employees.  In this case the expression is used
in the first manner.  The same expression could be used in a row
condition if the user was interested only in employees with a total
compensation gre...