Systems and methods for using graphical representations to manage query results

• US 9,881,063 B2
• Filed: 06/14/2011
• Issued: 01/30/2018
• Est. Priority Date: 06/14/2011
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Marum, Matthew Gordon, Padgett, Samuel George, Speicher, Steven Keith, Tabb, Michael John
• Primary Examiner(s): Casanova, Jorge A
• Application Number:
  US13/159,682
• Publication Number:
  US 20120323887A1
• Time in Patent Office: 2,422 Days
• Field of Search: 707722
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

Described are systems and methods for changing query result data graphically displayed on an electronic device. A query of a data repository is performed. A graphical representation of a set of query results identified from the query is displayed. The set of query results includes a plurality of query result records. The graphical representation includes a first node corresponding to a first record field value and a second node corresponding to a second record field value. A region proximal to the first node displays at least one query result record having the first record field value. A query result record of the at least one query result record having the first record field value is selected. A field value of a selected query result record is changed from the first record field value to the second record field value by transitioning the selected query result record to a region proximal to the second node of the graphical representation.

Claims

1. A computer program product for changing query result data graphically displayed on an electronic device, the computer program product comprising:

a non-transitory computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising;

computer readable program code configured to perform a query of a data repository;

computer readable program code configured to display a graphical representation of a set of query results identified from the query, the set of query results including a plurality of query result records, the graphical representation including a first location corresponding to a first record field value and a second location corresponding to a second record field value;

computer readable program code configured to display at the first location at least one query result record having the first record field value;

computer readable program code configured to select a query result record of the at least one query result record having the first record field value;

computer readable program code configured to change a field value of the selected query result record from the first record field value to the second record field value by transitioning the selected query result record to the second location of the graphical representation;

computer readable program code configured to display a plurality of field types;

computer readable program code configured to process at least two field types of the plurality of field types; and

computer readable program code configured to display a graphical representation of the query results, the graphical representation including a plurality of vertices, each vertex corresponding to a product of a field value of each of the at least two field types.

2. The computer program product of claim 1, wherein the graphical representation includes a field graph.

3. The computer program product of claim 1, further comprising computer readable program code configured to display a window at the second location, and wherein the second record field value is added to the selected query result record by positioning the selected query result record in the window.

4. The computer program product of claim 1, wherein a listing of records having the first record field value is displayed at the first location, and a listing of records having the second having the second record field value is displayed at the second location.

5. The computer program product of claim 1, wherein the first location includes a first node and the second location includes a second node, and wherein the computer readable program code configured to display the graphical representation of the set of query results identified from the query comprises program code configured to display an arc between the first node and the second node.

6. The computer program product of claim 5, wherein the field value of the selected query result record is changed from the first record field value to the second record field value by selecting the arc to transition the selected query result record from the first node to the second node.

7. The computer program product of claim 1, wherein the computer readable program code configured to change the field value of the selected query result record from the first record field value to the second record field value comprises:

computer readable program code configured to remove the selected query result record from the first location; and

computer readable program code configured to perform a drag-and-drop operation to transition the selected query result record to the second location.

8. The computer program product of claim 1, comprising:

computer readable program code configured to display a graphical user interface;

computer readable program code configured to select a first field type of the plurality of field types to display the graphical representation of the query results; and

computer readable program code configured to select a second field type of the plurality of field types to display a different graphical representation of the query results.

9. The computer program product of claim 8, wherein computer readable program code configured to select a second field type comprises:

computer readable program code configured to process a selected query result record of the plurality of query result records having a third record field value, the selected query result record displayed at a third location of the different graphical representation corresponding to the third record field value; and

computer readable program code configured to change a field value of a selected query result record from the third record field value to a fourth record field value by transitioning the selected query result record to a fourth location of the different graphical representation corresponding to the fourth record field value.

10. The computer program product of claim 1, wherein the second location includes a modifiable field, and wherein the computer readable program code configured to change the field value of the selected query result record comprises computer readable program code configured to provide the second record field value at the modifiable field.

11. The computer program product of claim 10, further comprising:

computer readable program code configured to present a dialog box at the second location;

computer readable program code configured to enter the second record field value in the dialog box.

12. The computer program product of claim 1, wherein the at least two field types are selected from columns of a database file, each column corresponding to a field type.

13. The computer program product of claim 1, wherein the at least two field types are selected at a graphical user interface displaying the field types.