Method and apparatus for graphically displaying query relationships

• US 5,721,900 A
• Filed: 07/20/1992
• Issued: 02/24/1998
• Est. Priority Date: 07/20/1992
• Status: Expired due to Term

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: International Business Machines Corporation
• Inventors: Li, Shih-Gong, Banning, Kenneth Ray, James, Wendy Sue
• Primary Examiner(s): Bayerl, Raymond J.
• Assistant Examiner(s): Breene, John E.
• Application Number:
  US07/916,239
• Time in Patent Office: 2,045 Days
• Field of Search: 395/155-161, 395/600
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 715/968 interface for database querying and retrieval

Abstract

A method, system and program for providing a graphical interface for a database are accomplished by the operation of a process in the memory of a processor. The definition of individual predicates, the definition of the relationship of predicates, the editing of predicates, and the editing of the relationship of predicates is simplified and rendered dynamic and interactive for the user thereby facilitating the completion of the task being performed. The user need not remember the related column information for a specified predicate because the system will provide that information simultaneously with the predicate definition in a form that supports the direct manipulation of the related information. The predicates and their relationship are displayed simultaneously with the definition activities for both the initial definition and any subsequent editing activities. The user may select this information and drag it to the desired location to proceed on the desired activity.

Claims

1. An apparatus for graphically forming a query relationship between a first object and a second object by direct manipulation comprising:

(a) means for storing a plurality of objects including said first object and said second object in a database accessible by a user at a workstation;

(b) pointer means at said workstation for selecting said first object for said query and said second object for said query form said plurality of objects in the database by said user using direct manipulation;

(c) means for creating a logical relationship between the first object for said query selected by said user within the database and the second object for said query;

(d) means for graphically displaying the logical relationship between the first object for said query and the second object for said query to said user on a display on said workstation, and

(e) means for forming presentation objects representing data structures by storing user supplied information of the logical relationship of said first object and said second object in said data structures and displaying the logical relationship to said user at said workstation.

2. An apparatus as recited in claim 1, wherein the database is relational.

3. An apparatus as recited in claim 1, including means for creating predicate definitions by a user at said workstation by direct manipulation of a first object and a second object in said database.

4. An apparatus as recited in claim 1, wherein the presentation objects are formed by said first object and said second object through the logical relationship defined by said user at said workstation.

5. An apparatus as recited in claim 3, including means for graphically displaying the predicate definitions on a display to said user at said workstation.

6. An apparatus as recited in claim 3, including means for editing the predicate definitions by said user at said workstation by direct manipulation of said plurality of objects at said workstation.

7. A method for graphically forming a graphical query relationship between a first object and a second object by direct manipulation comprising:

(a) storing information in a database for a plurality of objects including said first object and said second object in a database accessible by a user at a workstation;

(b) selecting said first object for said query and said second object for said query form said plurality of objects in the database by said user using direct manipulation;

(c) creating a logical relationship between the first object for said query selected by said user within the database and the second object for said query;

(d) displaying the logical relationship between the first object for said query and the second object for said query to said user on a displays, and

(e) forming presentation objects representing data structures by storing user supplied information on the logical relationship of said first object and said second object in said data structures and displaying the logical relationship to said user at said workstation.

8. A method as retired in claim 7, wherein the database is relational.

9. A method as recited in claim 7, including the step of creating predicate definitions by a user at said workstation by direct manipulation of a first object and a second object in said database.

10. A method as recited in claim 7, wherein the presentation objects are formed by said first object and said second object through said logical relationship defined by said user at said workstation.

11. A method as recited in claim 9, including the step of graphically displaying the predicate definitions on a display to said user at said workstation.

12. A method as recited in claim 9, including the step of editing the predicate definitions by said user at said workstation by direct manipulation of said plurality of objects at said workstation.