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

Object-Oriented Approach in Managing SQL Logic Expressions

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

Publishing Venue

IBM

Related People

Banning, KR: AUTHOR [+2]

Abstract

Disclosed is a method of using an object-oriented user interface model to overcome the difficult task for users of specifying SQL WHERE and/or HAVING clauses. The model treats each of the predicates defined, as well as any logical operator joining them, as objects. These parts are then visually displayed and traditional graphical interface manipulation techniques used. This results in improved performance by the user in correctly defining and editing these complex SQL text strings.

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

Object-Oriented Approach in Managing SQL Logic Expressions

       Disclosed is a method of using an object-oriented user
interface model to overcome the difficult task for users of
specifying SQL WHERE and/or HAVING clauses.  The model treats each of
the predicates defined, as well as any logical operator joining them,
as objects.  These parts are then visually displayed and traditional
graphical interface manipulation techniques used.  This results in
improved performance by the user in correctly defining and editing
these complex SQL text strings.

      Structured Query Language (SQL) is a language for extracting
information from a database.  The language has been developed to
perform efficient retrieval of the information into forms that are
meaningful to the applications that requested the information.  SQL
was not developed to be easy to use.  Managing the logical expression
in SQL, the WHERE and/or HAVING clause, is one of the difficulties
users encounter.  The WHERE and/or HAVING clause is a "flat" text
string.  It is not viewed as a group of objects, but rather a list of
characters.  To make any change on the logical expression, the user
has to identify the right location of characters to be changed and
then change them by using text editing functions.  When the condition
gets more complicated, the character string gets longer, and it is
less convenient to make a change successfully.

      In this model, each predicate and logical operator in a SQL
logical expression is considered as an independent and individual
object.  A text string, which was the major entity considered before,
is now assigned as a parameter value of the object.  Since the
predicates and operators are objects, currently available direct
manipulation techniques can be applied to manage them.  When an
object is selected to be manipu...