Method and apparatus for searching a database by interactively modifying a database query

• US 5,608,899 A
• Filed: 06/04/1993
• Issued: 03/04/1997
• Est. Priority Date: 06/04/1993
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Tate, Bruce A., Li, Shih-Gong
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Alam, Hosain T.
• Application Number:
  US08/072,618
• Time in Patent Office: 1,369 Days
• Field of Search: 395/600, 395/155, 395/159, 395/160, 395/161, 395/140, 364/401, 364/402, 364/403, 364/408
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2425 Iterative querying; Query formulation based on the results of a preceding query
• 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 16/248 Presentation of query results
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 715/968 interface for database querying and retrieval

Abstract

An apparatus for modifying a database query including apparatus for graphically displaying in at least two dimensions data obtained from a database by the database query, apparatus for selecting at least one portion of the graphically displayed data, and apparatus for modifying the database query according to the selected portion of the graphically displayed data. In addition, a method for modifying a database query including the steps of graphically displaying in at least two dimensions data obtained from a database by the database query, selecting at least one portion of the graphically displayed data, and modifying the database query according to the selected portion of the graphically displayed data.

Claims

1. An apparatus for modifying a database query comprising:

means for graphically displaying, in at least two dimensions, data obtained from a database by the database query in a graph window and for separately displaying said database query in a query window;

means for selecting at least one portion of the graphically displayed data in said graph window; and

means for modifying the database query with a WHERE clause according to the selected portion of the graphically displayed data, said database query modifying means including means for reflecting the modification to the database query in the query window and means for modifying the graphically displayed data using the modified database query.

2. The apparatus of claim 1 further comprising means for iteratively actuating said means for graphically displaying, means for selecting and means for modifying.

3. The apparatus of claim 1 wherein the means for graphically displaying includes means for graphically displaying a line chart of the data obtained by the database query.

4. The apparatus of claim 3 wherein the means for selecting includes means for utilizing a variable sized box to select at least one portion of the line chart.

5. The apparatus of claim 1 wherein the means for selecting includes means for selecting multiple portions of the graphically displayed data.

6. A method for modifying a database query comprising the steps of:

graphically displaying, in at least two dimensions, data obtained from a database by the database query in a graph window and separately displaying said database query in a query window;

selecting at least one portion of the graphically displayed data in said graph window; and

modifying the database query with a WHERE clause according to the selected portion of the graphically displayed data, reflecting the modification to the database query in the query window and modifying the graphically displayed data using the modified database query.

7. The method of claim 6 further comprising the step of repeating the steps of graphically displaying, selecting and modifying.

8. The method of claim 6 wherein the step of graphically displaying includes graphically displaying a line chart of the data obtained by the database query.

9. The method of claim 8 wherein the step of selecting includes utilizing a variable sized box to select at least one portion of the line chart.

10. The method of claim 6 wherein the step of selecting includes selecting multiple portions of the graphically displayed data.

11. A data processing system for modifying a database query comprising:

memory means for storing database data;

means for graphically displaying, in at least two dimensions, data obtained from a database by the database query in a graph window and for separately displaying said database query in a query window;

processing means for processing said stored database data;

means for selecting at least one portion of the graphically displayed data in said graph window; and

means for modifying the database query with a WHERE clause according to the selected portion of the graphically displayed data, said database query modifying means including means for reflecting the modification to the database query in said query window and means for modifying the graphically displayed data using the modified database query.

12. The data processing system of claim 11 further comprising means for iteratively actuating said means for graphically displaying, means for selecting and means for modifying.

13. The data processing system of claim 11 wherein the means for graphically displaying includes means for graphically displaying a line chart of the data obtained by the database query.

14. The data processing system of claim 13 wherein the means for selecting includes means for utilizing a variable sized box to select at least one portion of the line chart.

15. The data processing system of claim 11 wherein the means for selecting includes means for selecting multiple portions of the graphically displayed data.

16. A computer program product stored in memory executable by a processor for modifying a database query comprising:

means for graphically displaying, in at least two dimensions, data obtained from a database by the database query in a graph window and for separately displaying said database query in a query window;

means for selecting at least one portion of the graphically displayed data in said graph window; and

means for modifying the database query with a WHERE clause according to the selected portion of the graphically displayed data, said database query modifying means including means for reflecting the modification to the database query in said query window and means for modifying the graphically displayed data using the modified database query.

17. The computer program product of claim 16 further comprising means for iteratively actuating said means for graphically displaying, means for selecting and means for modifying.

18. The computer program product of claim 16 wherein the means for graphically displaying includes means for graphically displaying a line chart of the data obtained by the database query.

19. The computer program product of claim 18 wherein the means for selecting includes means for utilizing a variable sized box to select at least one portion of the line chart.

20. The computer program product of claim 16 wherein the means for selecting includes means for selecting multiple portions of the graphically displayed data.