Method and apparatus for displaying a dialog box enabling user selections from a database

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

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: James, Wendy Sue, Li, Shih-Gong, Banning, Kenneth Ray
• Primary Examiner(s): Bayerl, Raymond J.
• Assistant Examiner(s): Breene, John E.
• Application Number:
  US08/479,234
• Time in Patent Office: 993 Days
• Field of Search: 395/326-358, 395/603-605, 395/968, 395/613
• 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: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
• 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. A selected entry in the database is dynamically used as input to a conditional definition dialog box. The definition of individual conditions, the definition of the relationship of conditions to the selected entries, the editing of conditions, and the editing of the relationship of conditions 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 conditional definition in a form that supports the direct manipulation of the related information. The selected entries 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. A method of creating a query for accessing a database by a user using a graphical user interface at a workstation in a data processing system, comprising:

selecting a column entry in said database by said user using a pointer device;

automatically transferring said column entry from said database into a dialog box representing a first field in a predicate in said graphical interface;

providing a comparison operator having a plurality of values in said graphical user interface and selecting one of said values by said user using said pointer device; and

inputting a second column entry from said database into a second field in said dialog box in said graphical user interface by dragging said second column entry from said database to complete said predicate.

2. The method of claim 1 wherein the comparison operator values are listed in a scrollable list.

3. The method of claim 1 wherein the step of inputting includes the step of dragging a subquery into said second field in said dialog box in said graphical user interface to complete said predicate.

4. The method of claim 1 wherein the step of inputting includes the step of typing a value by said user using said keyboard by said user in said dialog box in said graphical user interface.

5. The method of claim 1 wherein said query is dynamically applied to said database such that underlying data structures of said database are modified.

6. A computer program product for creating a query for accessing a database by a user using a graphical user interface at a workstation in a data processing system, comprising:

a computer usable medium having computer readable program code means embodied in said medium for selecting a column entry in said database by said user using a pointer device;

computer readable program code means for automatically transferring said column entry from said database into a dialog box representing a first field in a predicate in said graphical interface;

computer readable program code means for providing a comparison operator having a plurality of values in said graphical user interface and selecting one of said values by said user using said pointer device; and

computer readable program code means for inputting a second column entry from said database into a second field in said dialog box in said graphical user interface by dragging said second column entry from said database to complete said predicate.

7. A computer program product of claim 6 wherein the comparison operator values are listed in a scrollable list.

8. A computer program product of claim 6 wherein the computer readable program means of inputting includes means of dragging a subquery into said second field in said dialog box in said graphical user interface to complete said predicate.

9. The computer program product of claim 6 wherein the computer readable program code means of inputting includes means of typing a value by said user using said keyboard by said user in said dialog box in said graphical user interface.

10. The computer program product method of claim 6 wherein said query is dynamically applied to said database such that underlying data structures of said database are modified.