DYNAMIC GRAPHICAL DATABASE QUERY INTERFACE

• US 20090094217A1
• Filed: 12/15/2008
• Published: 04/09/2009
• Est. Priority Date: 06/10/2004
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Dettinger, Richard Dean, Tran, Hoa Thu, Tenner, Jeffrey Wayne, Djugash, Judy Immaculate Tina
• Application Number:
  US12/334,680
• Publication Number:
  US 20090094217A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• 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

Abstract

A graphical query interface provides visual feedback to a user during the construction of a query. In a first embodiment, the visual feedback helps the user determine the quality of the query as the query is being built. The relationship of columns in the database is graphically displayed to a user. When the user selects a column in the database, a filtered display mechanism displays only those columns or records that satisfy the portion of the query already constructed. In a second embodiment, the visual feedback eliminates some possible selections in the query tree due to previously-made selections that eliminate the eliminated selections as possibilities. In the second embodiment, the visual feedback mechanism may function according to data values in columns, and may also function according to known relationships between columns themselves.

Claims

1. A computer-implemented method for a user to build a query to a database, the method comprising the steps of:

displaying to the user in a first window a graphical representation of a plurality of user-selectable icons corresponding to a plurality of columns defined in the database, the graphical representation including at least one line connecting the plurality of user-selectable icons to represent at least one relationship in the database;

in response to the user selection of an icon in the graphical representation corresponding to a first column in a first step in building the query, altering the graphical representation to make at least one icon corresponding to at least one different column in the graphical representation unavailable for selection by the user in a subsequent step in building the query according to at least one predefined rule for the first column that specifies at least one restriction between the first column and the at least one different column; and

during display of the graphical representation in the first window, displaying in a second window at least one selectable value corresponding to values in the database corresponding to the first column.

2. The method of claim 1 wherein the at least one restriction comprises mutual exclusion for the first column and the at least one different column.

3. The method of claim 1 wherein the graphical representation includes a plurality of domains that each define a logical grouping of columns in the database, wherein the at least one predefined rule includes at least one condition for displaying each of the plurality of domains.

4. The method of claim 1 wherein the step of altering the graphical representation to make the at least one icon corresponding to at least one column in the graphical representation unavailable for selection by the user comprises at least one of the following steps:

eliminating the at least one icon corresponding to the at least one different column from the graphical representation;

hiding the at least one icon corresponding to the at least one different column in the graphical representation from view of the user; and

greying out the at least one icon corresponding to the at least one different column in the graphical representation.

5. The method of claim 1 wherein the at least one restriction specifies a reciprocal keyword that causes automatic generation of reciprocal restrictions between the first column and the at least one different column.

6. The method of claim 1 further comprising the step of resetting the at least one restriction to make the at least one different column in the graphical representation available for selection by the user when the user specifies an OR operator when building the query.