Methods and apparatus for adding parenthetical expression capability to a tabular query user interface

• US 20060095407A1
• Filed: 11/01/2004
• Published: 05/04/2006
• Est. Priority Date: 11/01/2004
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ortega, Kerry A., Steinbugler, Gayle Colby
• Application Number:
  US10/979,356
• Publication Number:
  US 20060095407A1
• Time in Patent Office: Days
• 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

Abstract

The present invention concerns methods and apparatus for incorporating parenthetical expression capability in an interactive tabular query interface, wherein the interactive tabular query interface can be used to search computer resources like computer databases. The methods and apparatus of the present invention permit a user through the medium of a parenthetical-expression-capable tabular query interface both to group at least two logical expressions with a single level of parentheses and to embed parenthetical expressions within multi-level parenthetical expressions. The methods and apparatus of the present invention also permit a user to quickly and easily logically un-combine expressions that have been grouped using a parenthetical expression feature of a tabular query user interface made in accordance with the present invention. Further, the interactive tabular query interface also has a preview window for depicting dynamically a query as it is formulated.

Claims

1. A signal-bearing medium tangibly embodying a program of machine-readable instructions executable by a digital processing apparatus of a computer system to perform operations controlling a graphical user interface system, the operations comprising:

displaying an interactive tabular query interface on a display of the computer system, wherein the interactive tabular query interface comprises;

a table field for displaying logical expressions comprised of logical operators, operands and grouping elements, wherein the logical expressions, when taken together, comprise a search query;

a logical operator entry facility to enter logical operators in the table field;

an operand entry facility to enter operands in the table field, wherein the operands will be operated on by the operators; and

an expression grouping facility to group at least two logical expressions entered in the table field together into a grouped expression using grouping elements;

receiving commands corresponding to selections of logical operators, operands and grouping elements for display in selected locations in the table field; and

displaying selected logical operators, operands and grouping elements in the selected locations in the table field.

2. The signal-bearing medium of claim 1, wherein the grouping elements comprise parentheses.

3. The signal-bearing medium of claim 1, wherein the expression grouping facility further comprises:

an embedded expression grouping facility to formulate embedded grouped expressions set off by at least two levels of grouping elements.

4. The signal-bearing medium of claim 1, wherein the interactive tabular query interface further comprises:

a grouping element removal facility to logically un-combine at least two logical expressions that have been joined into a grouped expression.

5. The signal-bearing medium of claim 1, wherein the interactive tabular query interface further comprises:

a preview window to display at least a portion of the search query in a logical expression format comprised of operators, operands and grouping elements.

6. A computer system for displaying an interactive tabular query interface having expression grouping capability, the computer system comprising:

at least one memory to store at least one program of machine-readable instructions, where the at least one program performs operations to display the interactive tabular query interface when executed;

a computer display device for displaying the interactive tabular query interface;

an input device for interacting with the interactive tabular user interface; and

at least one processor coupled to the at least one memory, computer display and input device, where the at least one processor performs at least the following operation when the at least one program is executed;

displaying the interactive tabular query interface, where the interactive tabular query interface comprises;

a table field for displaying logical expressions comprised of logical operators, operands and grouping elements, wherein the logical expressions, when taken together, comprise a search query;

a logical operator entry facility to enter logical operators in the table field;

an operand entry facility to enter operands in the table field, wherein the operands will be operated on by the operators; and

an expression grouping facility to combine at least two logical expressions entered in the table field into a grouped expression using grouping elements.

7. The computer system for displaying an interactive tabular query interface of claim 6, wherein the expression grouping facility further comprises:

an embedded expression grouping facility to formulate embedded grouped expressions set off by at least two levels of grouping elements.

8. The computer system for displaying an interactive tabular query interface of claim 6, wherein the interactive tabular query interface further comprises:

a preview window to display at least a portion of the search query in a logical expression format comprised of operators, operands and grouping elements.

9. The computer system for displaying an interactive tabular query interface of claim 8, wherein the interactive tabular query interface further comprises:

a grouped expression location facility to highlight a particular grouped expression comprising, in part, the search query, wherein to highlight the particular grouped expression graphically emphasizes the position of the particular grouped expression within the search query when the search query is displayed in the preview window.

10. The computer system for displaying an interactive tabular query interface of claim 9, wherein the grouped expression location facility successively highlights each level of a multi-level grouped expression in which the particular grouped expression is incorporated in response to successive requests by the user.

11. The computer system for displaying an interactive tabular query interface of claim 6, wherein the expression grouping facility comprises a parentheses entry facility, the grouping elements comprise parentheses, and the grouped expressions comprise parenthetical expressions.

12. The computer system for displaying an interactive tabular query interface of claim 11, wherein:

the table field further comprises a plurality of cells organized in rows and columns, wherein individual logical expressions comprising the search query are entered in the rows of the table field by using the logical operator, operand and parentheses entry facilities to enter operators, operands and parentheses in the cells of the rows, and wherein the columns of the table field correspond to particular logical operators, operands or parentheses, and wherein an open parentheses column for indicating presence of open parentheses is positioned toward the left portion of the table field and a close parentheses column for indicating the presence of close parentheses is positioned toward the right portion of the table field; and

wherein

the parentheses entry facility further comprises a toolbar comprising an open parenthesis icon and a close parenthesis icon; and

whereby parentheses are entered in cells in one of the open parentheses column or close parentheses column by selecting a cell in one of these two columns and by selecting the parenthesis icon in the toolbar corresponding to that parentheses column, wherein the appropriate parenthesis symbol is then graphically depicted in the selected cell position.

13. The computer system for displaying an interactive tabular query interface of claim 11, wherein the parentheses entry facility further comprises:

an embedded parentheses entry facility to formulate embedded parenthetical expressions.

14. The computer system for displaying an interactive tabular query interface of claim 12 further comprising:

a parenthetical expression removal facility to logically un-combine at least two logical expressions that have been joined in a parenthetical expression, wherein the parenthetical expression removal facility comprises a remove parenthesis icon in the toolbar,

whereby a parenthetical expression is removed by successively selecting cell positions containing the open and close parenthesis to be removed in the open parentheses and close parentheses columns and by selecting the remove parenthesis icon after the appropriate cell position has been selected.

15. The computer system for displaying an interactive tabular query interface having parenthetical expression capability of claim 11, wherein:

the table field further comprises a plurality of cells organized in rows and columns, wherein individual logical expressions comprising the search query are entered in the rows of the table field by using the logical operator entry, operand entry and parentheses entry facilities to enter operators, operands and parenthetical expressions in the cells of the rows, and wherein the columns of the table field correspond to particular logical operators, operands and a parenthetical expression checkbox column for indicating which logical expressions entered in the rows of the table field have been joined in a parenthetical expression; and

wherein

the parentheses entry facility further comprises a toolbar comprising an parenthetical expression icon; and

whereby parenthetical expressions are formulated by first entering a check in the parenthetical expression checkbox column in each of the rows containing logical expressions to be joined into a parenthetical expression and then by clicking the parenthetical expression icon in the toolbar.

16. The computer system of claim 6 further comprising:

at least one database to be searched using a query formulated with the interactive tabular query interface.

17. The computer system of claim 16 wherein the at least one database is accessed over the internet.

18. The computer system of claim 6 further comprising:

a search engine coupled to the at least one processor, wherein the search engine searches databases over the internet with queries formulated using the interactive tabular query interface.

19. The computer system of claim 6 further comprising:

means for saving the search query formulated with the interactive tabular query interface to the at least one memory for later recall.

20. A user interface control system method comprising:

displaying an interactive tabular query interface having expression grouping capability, the interactive tabular query interface comprising;

a table field for displaying logical expressions comprised of logical operators, operands and grouping elements, wherein the logical expressions, when taken together, comprise a search query;

a logical operator entry facility to enter logical operators in the table field;

an operand entry facility to enter operands in the table field, wherein the operands will be operated on by the operators; and

a grouping element entry facility to combine at least two logical expressions entered in the table field into a grouped expression using grouping elements;

receiving commands corresponding to selections of logical operators, operands and grouping elements for display in selected locations in the table field; and

displaying selected logical operators, operands and grouping elements in the selected locations in the table field.

21. The user interface control system method of claim 20, where the grouping elements comprise parentheses.

22. The user interface control system method of claim 20, wherein the method further comprises:

formulating a database query with the interactive tabular query interface.

23. The user interface control system method of claim 20, wherein the method further comprises:

performing a database search with a query formulated using the interactive tabular query interface.