Abstract: 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.

Abstract: A method, system and program providing graphical queries and direct manipulation of a database is disclosed. In a preferred form, tables and lists are configured from a database to define a common data structure. Additional, dynamic data structures are employed based on information entered by a user to define various relationships between the dynamic data and the database information. The system employs a graphical query interface and a relational database to provide an ergonomic, natural interface for a database user.