Tree structure representation of an SQL clause

A system, program and method for graphically representing a WHERE or HAVING clause of an SQL query directed to a relational database. Logical operators are defined and linked to predicates using a tree structure format. The tree is not binary in character and consequently exhibits a 1:1 relation bet...

Full description

Saved in:
Bibliographic Details
Main Authors LI; SHIH-GONG, VERSTEEG; ANTON, BANNING; KENNETH R, JAMES; WENDY S
Format Patent
LanguageEnglish
Published 28.11.1995
Edition6
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:A system, program and method for graphically representing a WHERE or HAVING clause of an SQL query directed to a relational database. Logical operators are defined and linked to predicates using a tree structure format. The tree is not binary in character and consequently exhibits a 1:1 relation between the predicates and tree leaves. The tree structure representation provides intuitive feedback to the user defining the query. Preferably the SQL format and tree structure graphic format queries appear simultaneously on the video display of the computer system used to define the query.
Bibliography:Application Number: US19940289142