Systems and methods for using graphical representations to manage query results

• US 9,881,064 B2
• Filed: 03/15/2012
• Issued: 01/30/2018
• Est. Priority Date: 06/14/2011
• Status: Active Grant

• 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/420,919
• Publication Number:
  US 20120323889A1
• Time in Patent Office: 2,147 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 query results include 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 a query result record having the first record field value. A 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.

Claims

1. A method for changing query result data graphically displayed on an electronic device, comprising:

performing a query of a data repository;

displaying 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;

displaying at a first location at least one query result record having the first record field value;

selecting a query result record of the at least one query result record having the first record field value;

changing 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 a second location of the graphical representation;

displaying a plurality of field types;

selecting at least two field types of the plurality of field types; and

displaying 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 method of claim 1, wherein the graphical representation includes a field graph.

3. The method of claim 1, wherein a window is displayed 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 method 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 method of claim 1, wherein the first location includes a first node and the second location includes a second node, and wherein displaying the graphical representation comprises displaying an arc between the first node and the second node.

6. The method of claim 5, wherein changing the field value of the selected query result record from the first record field value to the second record field value comprises selecting the arc to transition the selected query result record from the first node to the second node.

7. The method of claim 1, wherein changing the field value of the selected query result record from the first record field value to the second record field value comprises:

removing the selected query result record from the first location;

performing a drag-and-drop operation to transition the selected query result record to the second location.

8. The method of claim 1 further comprising:

displaying a graphical user interface;

selecting a first field type of the plurality of field types to display the graphical representation of the query results; and

selecting a second field type of the plurality of field types to display a different graphical representation of the query results.

9. The method of claim 8, wherein selecting the second field type of the plurality of field types comprises:

selecting a 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

changing 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 method of claim 1, wherein the second location includes a modifiable field, and wherein changing the field value of the selected query result record comprises entering the second record field value into the modifiable field.

11. The method of claim 10, further comprising:

presenting a dialog box at the second location;

entering the second record field value in the dialog box.

12. The method 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 method of claim 1, wherein the at least two field types are selected at a graphical user interface displaying the field types.

14. A method for changing query result data graphically displayed on an electronic device, comprising:

performing a query of a data repository;

displaying 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 node corresponding to a first record field value;

displaying at a region proximal to the first node at least one query result record having the first record field value;

displaying at a region proximal to the second node a modifiable field;

entering a second record field value into the modifiable field, the second node corresponding to the second record field value;

selecting a query result record of the at least one query result record having the first record field value;

changing a field value of a 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 region proximal to the second node displaying the modifiable field;

displaying a plurality of field types;

selecting at least two field types of the plurality of field types; and

displaying a graphical representation of the query results, the graphical representation including a plurality of nodes, each node corresponding to a product of a field value of each of the at least two field types.

15. The method of claim 14, wherein the graphical representation includes a field graph.

16. The method of claim 14, wherein a dialog box is displayed at the region proximal to the second node, and wherein the second record field value is inserted into the selected query result record by positioning the selected query result record in the dialog box.

17. The method of claim 14, wherein changing the field value of the selected query result record from the first record field value to the second record field value comprises:

displaying an arc between the first node and the second node; and

selecting the arc to transition the selected query result record from the first node to the second node.

18. The method of claim 14, wherein changing the field value of the selected query result record from the first record field value to the second record field value comprises:

removing the selected query result record from the region proximal to the first node;

performing a drag-and-drop operation to move the selected query result record to the second node.

19. The method of claim 14 further comprising:

displaying the graphical representation of the set of query results at a graphical user interface;

selecting a first field type of the plurality of field types to display the graphical representation of the set of query records; and

selecting a second field type of the plurality of field types to display a different graphical representation of the set of query records.

20. The method of claim 19, wherein selecting a second field type of the plurality of field types to display a different graphical representation of the set of query records comprises:

selecting a query result record of the plurality of query result records having a third record field value, the selected query result record displayed at a region proximal to a third node of the different graphical representation corresponding to the third record field value; and

changing a field value of the 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 region proximal a fourth node of the different graphical representation corresponding to the fourth record field value.

21. The method of claim 14, wherein a dialog box is displayed at the region proximal to the second node permitting a user to enter the second record field value.