Find assistant for creating database queries

• US 5,787,418 A
• Filed: 09/03/1996
• Issued: 07/28/1998
• Est. Priority Date: 09/03/1996
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Hibbetts, Michael Robert, Levine, Jonathan Michael, Li, Kester
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): HO, RUAY L
• Application Number:
  US08/708,117
• Time in Patent Office: 693 Days
• Field of Search: 395/601, 395/602, 395/603, 395/604, 395/605, 395/606, 395/607, 395/608, 395/609, 395/610, 395/611, 395/612, 395/613, 395/614, 395/326, 395/701, 707/1, 707/2, 707/3, 707/4, 707/5, 707/6, 707/7, 707/8, 707/9, 707/10, 707/100, 707/101, 707/102, 707/103, 345/326
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

A method, apparatus, and article of manufacture which provides for finding database management information on a computer in a simple, user-friendly way to minimize errors and maximize database usership. The invention displays a window containing a card metaphor in a graphical user interface on a computer display. The window allows the user to enter a find type and a find condition selected from a displayed menu. The window also displays a natural language description of the current status of the find request, allowing the user to see, in real time, the scope of the request and the databases affected.

Claims

1. A computerized method of finding information in a memory of a computer having a processor, data storage device, display device, and data input device, the computer processor running a database management system having a plurality of database tables each including a plurality of associated database fields having database data, the method comprising the steps of:

(a) displaying a window containing a card metaphor on the display device;

(b) accepting, through the card metaphor, a find request comprising a find type and a find condition entered from the data input device;

(c) interpreting the find type and find condition to generate a natural language description of the find request; and

(d) presenting the natural language description of the find request in the window on the display device.

2. The method of claim 1, wherein the card metaphor comprises a first card panel having a first radio button for creating a new find, a second radio button for editing an existing named find, and a list of find types.

3. The method of claim 2, wherein the card metaphor comprises a second card panel having a list of the database tables, an associated database field box having a list of the associated database fields, a list of relational conditions, and a find criteria edit box.

4. The method of claim 3, wherein the second card panel further comprises a condition box for displaying the natural language description of the find request.

5. The method of claim 3, wherein the second card panel further comprises a first radio button for specifying an OR logical operator and a second radio button for specifying an AND logical operator.

6. The method of claim 3, wherein the card metaphor comprises a third card panel having a list of the database tables, an associated database field box having a list of the associated database fields, and a sort fields box showing a list of the associated database fields used as sort fields.

7. The method of claim 3, wherein the card metaphor comprises a fourth card panel having a SQL entry field for accepting an SQL database query instruction.

8. An apparatus for finding information with a database management system having a plurality of database tables each including a plurality of associated database fields having database data, the apparatus comprising:

(a) a computer, comprising a processor and a memory storing the database tables;

(b) means, performed by the computer, for displaying a window containing a card metaphor on a display coupled to the computer;

(c) means, performed by the computer for accepting, through the card metaphor, a find request comprising a find type and a find condition from a user input device into the computer;

(d) means, performed by the computer, for interpreting the find type and find condition to generate a natural language description of the find request;

(e) means, performed by the computer, for presenting a natural language description of the find request to the user in the window on the display.

9. The apparatus of claim 8, wherein the card metaphor comprises a first card panel having a first radio button for creating a new find, a second radio button for editing an existing named find, and a list of find types.

10. The apparatus of claim 9, wherein the card metaphor comprises a second card panel having a list of the database tables, an associated database field box having a list of the associated database fields, a list of relational conditions, and a find criteria edit box.

11. The apparatus of claim 10, wherein the second card panel further comprises a condition box for displaying the natural language description of the find request.

12. The apparatus of claim 10, wherein the second card panel further comprises a first radio button for specifying an OR logical operator and a second radio button for specifying an AND logical operator.

13. The apparatus of claim 10, wherein the card metaphor comprises a third card panel having a list of the database tables, an associated database field box having a list of the associated database fields, and a sort fields box showing a list of the associated database fields used as sort fields.

14. The apparatus of claim 10, wherein the card metaphor comprises a fourth card panel having a SQL entry field for accepting an SQL database query instruction.

15. A program storage device, readable by a computer having a processor, data storage device, display device, data input device, and a memory storing a plurality of database tables each including a plurality of associated database fields having database data, tangibly embodying one or more programs of instructions executable by the computer to perform method steps of finding information in the memory of the computer, the method comprising the steps of:

(a) displaying a window containing a card metaphor on the display device;

(b) accepting, through the card metaphor, a find request comprising a find type and a find condition entered from the data input device;

(c) interpreting the find type and find condition to generate a natural language description of the find request; and

(d) presenting the natural language description of the find request in the window on the display device.

16. The program storage device of claim 15, wherein the card metaphor comprises a first card panel having a first radio button for creating a new find, a second radio button for editing an existing named find, and a list of find types.

17. The program storage device of claim 16, wherein the card metaphor comprises a second card panel having a list of the database tables, an associated database field box having a list of the associated database fields, a list of relational conditions, and a find criteria edit box.

18. The program storage device of claim 17, wherein the second card panel further comprises a condition box for displaying the natural language description of the find request.

19. The program storage device of claim 17, wherein the second card panel further comprises a first radio button for specifying an OR logical operator and a second radio button for specifying an AND logical operator.

20. The program storage device of claim 17, wherein the card metaphor comprises a third card panel having a list of the database tables, an associated database field box having a list of the associated database fields, and a sort fields box showing a list of the associated database fields used as sort fields.

21. The program storage device of claim 17, wherein the card metaphor comprises a fourth card panel having a SQL entry field for accepting an SQL database query instruction.