System for interactive clause window construction of SQL queries

• US 5,418,950 A
• Filed: 09/21/1994
• Issued: 05/23/1995
• Est. Priority Date: 05/04/1992
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Li, Shih-Gong, Shrader, Theodore J. L.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US08/310,007
• Time in Patent Office: 244 Days
• Field of Search: 395/155, 395/156, 395/157, 395/600
• US Class Current: 715/781
• 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/99934 Query formulation, input preparation, or translation

Abstract

A method and system for viewing information stored in one or more rows and columns in a database. The system having a logical progression of choosing a column, determining conditions for a row to be included in a panel, specifying a column to be used as a base to group rows in a panel and a display for viewing the information.

Claims

1. An apparatus, having at least a display, for viewing database information stored in one or more rows and columns, comprising:

(a) a first portion of said display for displaying a plurality of panes, wherein said panes comprise at least a SELECT clause pane, FROM clause pane, and WHERE clause pane to form a structured query language SELECT statement;

(b) a second portion of said display for concurrently displaying a plurality of descriptors of said database information, said descriptors comprising at least one list of tables and at least one list of columns that reside within said tables;

(c) a third portion of said display for concurrently displaying a plurality of relational operators;

(d) means for selecting one of said panes;

(e) means for selecting at least one of said relational operators;

(f) means for selecting at least one of said tables and said columns; and

(g) in response to selecting said pane, means for arranging said selected table, column and relational operator within said selected pane.

2. The apparatus according to claim 1 wherein said means for selecting said pane comprises positioning and actuating a pointing device over said SELECT clause pane, FROM clause pane, or WHERE clause pane to activate said pane.

3. The apparatus according to claim 2 further comprising a means for specifying conditions for said SELECT statement.

4. The apparatus according to claim 3 wherein said specifying means comprises:

means for selecting said WHERE clause pane;

means for selecting at least one table from said list of displayed tables;

means for selecting at least one column from said list of columns; and

means for selecting at least one operator, thereby forming a WHERE clause in said SELECT statement.

5. The apparatus according to claim 3 wherein said specifying means comprises:

means for selecting a GROUP-BY clause pane from said panes;

means for selecting at least one table from said list of displayed tables;

means for selecting at least one column from said list of columns; and

means for selecting at least one relational operator, thereby forming a GROUP-BY clause in said SELECT statement.

6. The method according to claim 3 wherein said specifying means comprises:

means for selecting a HAVING clause pane from said panes;

means for selecting at least one table from said list of displayed tables;

means for selecting at least one column from said list of columns; and

means for selecting at least one relational operator, thereby forming a HAVING clause in said SELECT statement.

7. A method for directing a computer to access a plurality of database information, comprising the steps of:

displaying a plurality of panes on a first portion of a display, wherein said panes comprise at least a SELECT clause pane, from clause pane, and WHERE clause pane to form a structured query language SELECT statement;

concurrently displaying a plurality of descriptors of said plurality of database information on a second portion of said display, said descriptors comprising at least one list of tables and at least one list of columns that reside within said tables;

concurrently displaying at least one relational operator on a third portion of said display;

selecting one of said panes;

selecting at least one of said tables and columns;

selecting at least one of said relational operators to modify said selected table and column; and

in response to selecting said pane, arranging said selected table, column, and relational operator within said selected pane.

8. The method according to claim 7 wherein said step of selecting said pane comprises the steps of positioning and actuating a pointing device over said SELECT clause pane, FROM clause pane, or WHERE clause pane to activate said pane.

9. The method according to claim 8 further comprising the step of specifying conditions for said SELECT statement.

10. The method according to claim 9 wherein said specifying step comprises the steps of:

selecting said WHERE clause pane;

selecting at least one table from said list of displayed tables;

selecting at least one column from said list of columns; and

selecting at least one operator to modify said selected at least one column, thereby forming a WHERE clause in said SELECT statement.

11. The method according to claim 9 wherein said specifying step comprises the steps of:

selecting a GROUP-BY clause pane from said panes;

selecting at least one table from said list of displayed tables;

selecting at least one column from said list of columns; and

selecting at least one relational operator to modify said at least one column, thereby forming a GROUP-BY clause in said SELECT statement.

12. The method according to claim 9 wherein said specifying step comprises the steps of:

selecting a HAVING clause pane from said panes;

selecting at least one table from said list of displayed tables;

selecting at least one column from said list of columns; and

selecting at least one relational operator to modify said at least one column, thereby forming a HAVING clause in said SELECT statement.

13. An apparatus, having at least a display, for viewing database information stored in one or more rows and columns, comprising:

a first portion of said display for displaying at least one pane, wherein said at least one pane comprises at least a FULLSELECT text pane;

a second portion of said display for concurrently displaying a plurality of descriptors of said database information, said descriptors comprising a list of at least one SELECT statement;

a third portion of said display for concurrently displaying a plurality of relational operators;

means for selecting one of said FULLSELECT text panes;

means for selecting at least one of said SELECT statements;

means for selecting at least one of said relational operators; and

in response to selecting said FULLSELECT pane, means for arranging said at least one selected SELECT statement and relational operator within said FULLSELECT pane.

14. The apparatus according to claim 13 further comprising:

a fourth portion of said display for concurrently displaying a plurality of action operators.

15. The apparatus according to claim 14 wherein said for selecting said pane comprises means for positioning and actuating a pointing device over one of said action operators to activate said FULLSELECT text pane.

16. The apparatus according to claim 15 further comprising means for specifying conditions for said FULLSELECT statement.

17. The apparatus according to claim 16 wherein said action operators comprise OPEN, DELETE, TRANSFER, and CREATE action buttons.

18. The apparatus according to claim 17 wherein said specifying means comprises:

means for selecting said TRANSFER action button;

means for selecting a first said SELECT statement;

means for selecting at least one of said relation operators; and

means for selecting a second SELECT statement.

19. The apparatus according to claim 18 wherein said relation operators comprise NULL, BETWEEN, AND INTERSECTION, EXCEPT, ALL, EXISTS, NOT, and UNION buttons.

20. A method for directing a computer to access a plurality of database information, comprising the steps of:

displaying at least one pane on a first portion of a display, wherein said at least one pane comprises at least a FULLSELECT text pane;

concurrently displaying a plurality of descriptors of said plurality of database information on a second portion of said display, said descriptors comprising a list of SELECT statements;

concurrently displaying a plurality of relational operators on a third portion of said display;

selecting one of said FULLSELECT text pane;

selecting at least one of said SELECT statements;

selecting at least one of said relational operators; and

in response to selecting said FULLSELECT pane, arranging said selected at least one SELECT statement and said relational operator within said FULLSELECT pane.

21. The method according to claim 20 further comprising the steps of concurrently displaying a plurality of action operators on a fourth portion of said display.

22. The method according to claim 21 wherein said step of selecting said pane comprises the steps of positioning and actuating a pointing device over one of said action operators to activate said FULLSELECT text pane.

23. The method according to claim 22 further comprising the step of specifying conditions for a FULLSELECT statement.

24. The method according to claim 23 wherein said action operators comprise OPEN, DELETE, TRANSFER, and CREATE action buttons.

25. The method according to claim 24 wherein said specifying step comprises the steps of:

selecting said TRANSFER action button;

selecting a first said SELECT statement;

selecting at least one of said relation operators; and

selecting a second SELECT statement to modify said selected first SELECT statement according to said selected at least one relation operator, thereby forming said FULLSELECT statement.

26. The method according to claim 25 wherein said relation operators comprise NULL, BETWEEN, AND, INTERSECTION, EXCEPT, ALL, EXISTS, NOT, and UNION buttons.