Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Query Simplification by Defining Labels for Expressions

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

Publishing Venue

IBM

Related People

Banning, KR: AUTHOR [+5]

Abstract

Disclosed is a method to define and use labels for expressions in SQL queries. The label is used in place of the actual expression and may be used in other expressions. The defined expressions are available to the user from a library of expressions.

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

Query Simplification by Defining Labels for Expressions

       Disclosed is a method to define and use labels for
expressions in SQL queries.  The label is used in place of the actual
expression and may be used in other expressions. The defined
expressions are available to the user from a library of expressions.

      A user involved in defining a database query may be required to
use an expression.  This expression could be used multiple times
depending on the nature of the user interface.  Expressions can be
long and complex.  The exact nature of the expression and its
potential use may not be clear from just looking at the expression.
The user needs a simple way to look at the expression, understand the
expression's use and reuse the expression.

      Expressions are mathematical formulas used in query
definitions.  They may be long and complex, using column names that
are not always descriptive.  This inhibits the user in that they must
evaluate the meaning of any expression each time they encounter it to
insure that it is the same or a different expression.  In addition,
this makes multiple uses of the same expression time consuming
because it must be reproduced in its entirety.

      If the user was allowed to define a label for the expression as
part of the definition dialog, that label could be used in place of
the expression.  In addition, the user should be able to view the
definition of the expression in a simple manner.  This can be
accomplished with a simple mechanism.  When an expression is defined,
a field is defined for the expression label.  This label defaults to
the expression text.  The user must only operate on the expression
label to view the d...