US5721901A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for displaying a dialog box enabling user selections from a database
Assignee: International Business Machines Corp
•
Filing: 1995-06-07
•
Granted: 1998-02-24
•
Expires: 2015-06-07
Abstract
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.
Inventors
- 👤 Kenneth Ray Banning
- 👤 Wendy Sue James
- 👤 Shih-Gong Li
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-01 10:05
CPC Classifications
G; G06; G06F; G06F3/00; G06F3/01; G06F3/048; G06F3/0481; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2428; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99943; Y10S715/00; Y10S715/961; Y10S715/965; Y10S715/966; Y10S715/968
Claims Analysis
Total Claims: 12
Claim 1
Independent Claim
126 words
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.
Claim 2
Independent Claim
126 words
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.
Claim 3
Dependent Claim
16 words
The method of claim 1 wherein the comparison operator values are listed in a scrollable list.
Claim 4
Dependent Claim
34 words
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.
Claim 5
Dependent Claim
35 words
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.
Claim 6
Dependent Claim
24 words
The method of claim 1 wherein said query is dynamically applied to said database such that underlying data structures of said database are modified.
Claim 7
Dependent Claim
161 words
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.
Claim 8
Dependent Claim
161 words
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.
Claim 9
Dependent Claim
18 words
A computer program product of claim 6 wherein the comparison operator values are listed in a scrollable list.
Claim 10
Dependent Claim
38 words
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.
Claim 11
Dependent Claim
40 words
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.
Claim 12
Dependent Claim
27 words
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.
References Cited (Backward Citations)
US4087794A
Cited
US4068304A
Cited
US4527250A
Cited
US4477880A
Cited
US4556954A
Cited
US4449186A
Cited
US4464652A
Cited
US4712191A
Cited
US4601003A
Cited
US4829423A
Cited
US4531918A
Cited
US4642790A
Cited
US4656603A
Cited
US4689737A
Cited
US4635208A
Cited
US4648062A
Cited
US4686522A
Cited
US4843538A
Cited
US4951190A
Cited
US4873623A
Cited
US4815029A
Cited
US4868766A
Cited
US4899136A
Cited
US4939507A
Cited
US4885717A
Cited
US4945475A
Cited
US4763356A
Cited
US4984152A
Cited
US5041967A
Cited
US4821211A
Cited
US4853843A
Cited
US5040131A
Cited
US5001697A
Cited
US4953080A
Cited
US5088052A
Cited
US4989132A
Cited
US5041982A
Cited
US4996654A
Cited
US4933514A
Cited
US4933514B1
Cited
US5175814A
Cited
US5265246A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-02-23 | 2001-08-25 | 2002-02-24 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-02-23 | 2005-08-25 | 2006-02-24 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-02-23 | 2009-08-25 | 2010-02-24 | $7700.00 | Window Closed / Lapsed |