Computerized report-based interactive database query interface

• US 5,426,781 A
• Filed: 04/30/1992
• Issued: 06/20/1995
• Est. Priority Date: 04/30/1992
• Status: Expired due to Term

• Current Assignee: SAP SE
• Original Assignee: International Business Machines Corporation
• Inventors: Wolff, Gregory J., Kaplan, Craig A., Taylor, Stanley E.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Loomis, John C.
• Application Number:
  US07/876,255
• Time in Patent Office: 1,146 Days
• Field of Search: 395/155, 395/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/954 Relational
• 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 707/99944 Object-oriented database structure

Abstract

In a computer database system, a method and system are provided for interactively and iteratively constructing a query using a table metaphor displayed on a user display. Alterations are made directly to the table metaphor by the database user. The alterations relate to adding, deleting, or combining columns of attributes and limiting ranges of attribute values. The alterations are registered and the table metaphor updated to reflect the registered alterations. The table metaphor can be repeatedly used to further register additional alterations. The query corresponding to the table metaphor in its final form is run against the full database to generate a report in the format indicated by the table metaphor.

Claims

1. In a computer system having a processor, memory, a data storage device, a display screen, interaction means for enabling a user to interact with the system, and a database of data stored in the data storage device and logically organized as tables having a plurality of rows and columns of attributes, a method for formulating a report comprising the steps of:

(a) displaying on the display screen a table metaphor having rows and columns of attribute value cells, the attribute value cells containing attribute values reflective of a subset of attribute values of the database data;

(b) registering, through interaction means, direct alterations to the table metaphor;

(c) displaying on the display screen a revised table metaphor graphically representing a revised report format reflecting the registered direct alterations;

(d) repeating steps (b) and (c) to produce a final table metaphor graphically representing a final report format;

(e) determining a final query statement corresponding to the final table metaphor; and

(f) running the query statement on the database to produce query output in the final report format.

2. The method of claim 1 wherein the steps of registering direct alterations comprises indicating a rearrangement of the columns.

3. The method of claim 1 wherein the interaction means comprises positioning means for a user to position a cursor on a plurality of locations on the display screen and execution means for the user to signal the system, and wherein the step of registering direct alterations further comprises the steps of:

registering an execution from the execution means and identifying the location of the cursor;

determining a selected attribute column corresponding to the cursor location;

highlighting the selected attribute column;

determining a placement location where the execution from the execution means ceases to be registered; and

wherein

the updated table metaphor has the selected attribute column moved to the placement location.

4. The method of claim 1 wherein the step of registering direct alterations comprises adding a new attribute column as a function of two of the table metaphor attribute columns.

5. The method of claim 4 wherein the interaction means comprises positioning means for a user to position a cursor on a plurality of locations on the display screen and execution means for the user to signal the system, and wherein the registering direct alterations comprises the steps of:

registering an execution from the execution means and identifying the location of the cursor;

determining the cursor location to be between two selected attribute columns;

providing means for entering an operator to be applied to the two selected attribute columns; and

registering an operator entered by a user; and

wherein

the updated table metaphor containing a new attribute column comprising attribute values respectively corresponding to the respective attributes of the two selected attribute columns as respectively combined by the operator.

6. The method of claim 1 wherein the step of registering direct alterations comprises removing an attribute column.

7. The method of claim 1 wherein the step of registering direct alterations comprises providing an attribute value range limitation.

8. The method of claim 7 wherein the step of registering direct alterations comprises providing an AND operation on at least two of the attribute value range limitations.

9. The method of claim 8 wherein the step of registering direct alterations comprises providing an OR operation on at least two of the attribute value range limitations.

10. The method of claim 1 wherein the interaction means comprises positioning means for a user to position a cursor on a plurality of locations on the display screen and execution means for the user to signal the system, and wherein the registering direct alterations comprises the steps of:

(a) registering an execution from the execution means and identifying the location of the cursor;

(b) determining a selected cell corresponding to the cursor location;

(c) entering a value and an operator; and

(d) registering the entered value and operator.

11. The method of claim 10 wherein the selected cell is a table metaphor attribute cell and a select row is displayed parallel to the table metaphor rows, wherein a user may enter the value and the operator in a cell in the select row parallel to the selected cell.

12. The method of claim 10 wherein the selected cell is a select row attribute cell of a select row displayed parallel to the table metaphor rows, wherein a user may enter the value and the operator in a cell in the select row attribute cell.

13. The method of claim 12 wherein the revised table metaphor comprises at least one select row having at least one of the entered values and operators and each table metaphor row is highlighted wherein each respective attribute value of the highlighted row is within the range called for by each of the respective entered values and operators.

14. A computerized interactive system for formulating a report using data contained in a database stored in a computer having a processor, memory and a display terminal, comprising:

means for interactively accessing the system;

means for providing a subset of the database data in a displayed metaphor table;

means for registering at least one direct alteration to the metaphor table to graphically represent a report format;

means for determining a query corresponding to the report format; and

means for running the query on the database data to produce the report in the report format.

15. The system of claim 14 further comprising:

means for displaying an updated table metaphor incorporating the direct alteration.