User interface for graphically refactoring data flows

• US 10,528,587 B2
• Filed: 09/14/2017
• Issued: 01/07/2020
• Est. Priority Date: 11/07/2016
• Status: Active Grant

• Current Assignee: Tableau Software Incorporated (Salesforce.com, Inc.)
• Original Assignee: Tableau Software Incorporated (Salesforce.com, Inc.)
• Inventors: Kim, Jun, Pugh, Will, Kunen, Isaac
• Primary Examiner(s): Chowdhury, Rayeez R
• Application Number:
  US15/705,174
• Publication Number:
  US 20180129720A1
• Time in Patent Office: 845 Days
• CPC Class Codes: G06F 16/2453 Query optimisation
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

An exemplary method includes displaying a user interface that includes multiple panes, and receiving a first user input to select an existing node from a flow diagram or a flow element template. The system displays a moveable icon representing a new node for placement in the flow diagram. The new node specifies an operation corresponding to the selected existing node or the selected flow element template. Drop targets are displayed in the flow diagram according to dependencies between the data flow operation of the new node and operations of existing nodes. A second user input places the moveable icon over a first drop target. In response to ceasing to detect the second user input, the system inserts the new node into the flow diagram at the first drop target. The new node performs the specified data flow operation.

Claims

1. A computer system for refactoring a flow diagram, comprising:

one or more processors;

memory; and

one or more programs stored in the memory and configured for execution by the one or more processors, the one or more programs comprising instructions for;

displaying a user interface that includes a plurality of panes, including a data flow pane and a palette pane, wherein the data flow pane includes a flow diagram having a plurality of existing nodes, each node specifying a respective operation to retrieve data from a respective data source, specifying a respective operation to transform data, or specifying a respective operation to create a respective output data set, and wherein the palette pane includes a plurality flow element templates;

receiving a first user input to select an existing node from the flow diagram or a flow element template from the palette pane;

in response to the first user input;

displaying a moveable icon representing a new node for placement in the flow diagram, wherein the new node specifies a data flow operation corresponding to the selected existing node or the selected flow element template;

displaying one or more drop targets in the flow diagram according to dependencies between the data flow operation of the new node and operations of the plurality of existing nodes;

receiving a second user input to place the moveable icon over a first drop target of the drop targets, and ceasing to detect the second user input; and

in response to ceasing to detect the second user input, inserting the new node into the flow diagram at the first drop target, wherein the new node performs the specified data flow operation.

2. The computer system of claim 1, wherein each of the existing nodes has a respective intermediate data set computed according to the specified respective operation;

and

wherein inserting the new node into the flow diagram at the first drop target comprises computing an intermediate data set for the new node according to the specified data flow operation.

3. The computer system of claim 2, wherein the new node is placed in the flow diagram after a first existing node having a first intermediate data set, and computing the intermediate data set for the new node comprises applying the data flow operation to the first intermediate data set.

4. The computer system of claim 2, wherein the new node has no predecessor in the flow diagram, and computing the intermediate data set for the new node comprises retrieving data from a data source to form the intermediate data set.

5. The computer system of claim 2, wherein the one or more programs further include instructions for, in response to ceasing to detect the second user input, displaying a sampling of data from the intermediate data set in a data pane of the user interface.

6. The computer system of claim 2, wherein the data flow operation filters rows of data based on values of a first data field, and wherein displaying the one or more drop targets comprises displaying one or more drop targets immediately following existing nodes whose intermediate data sets include the first data field.

7. The computer system of claim 1, wherein the first user input selects an existing node from the flow diagram, and inserting the new node into the flow diagram at the first drop target creates a copy of the existing node.

8. The computer system of claim 7, wherein inserting the new node into the flow diagram at the first drop target further comprises removing the existing node from the flow diagram.

9. The computer system of claim 1, wherein the data flow operation comprises a plurality of operations that are executed in a specified sequence.

10. A method of refactoring a flow diagram, comprising:

at a computer system having one or more processors, memory storing one or more programs configured for execution by the one or more processors;

displaying a user interface that includes a plurality of panes, including a data flow pane and a palette pane, wherein the data flow pane includes a flow diagram having a plurality of existing nodes, each node specifying a respective operation to retrieve data from a respective data source, specifying a respective operation to transform data, or specifying a respective operation to create a respective output data set, and wherein the palette pane includes a plurality flow element templates;

receiving a first user input to select an existing node from the flow diagram or a flow element template from the palette pane;

in response to the first user input;

displaying a moveable icon representing a new node for placement in the flow diagram, wherein the new node specifies a data flow operation corresponding to the selected existing node or the selected flow element template;

displaying one or more drop targets in the flow diagram according to dependencies between the data flow operation of the new node and operations of the plurality of existing nodes;

receiving a second user input to place the moveable icon over a first drop target of the drop targets, and ceasing to detect the second user input; and

in response to ceasing to detect the second user input, inserting the new node into the flow diagram at the first drop target, wherein the new node performs the specified data flow operation.

11. The method of claim 10, wherein each of the existing nodes has a respective intermediate data set computed according to the specified respective operation;

and

wherein inserting the new node into the flow diagram at the first drop target comprises computing an intermediate data set for the new node according to the specified data flow operation.

12. The method of claim 11, wherein the new node is placed in the flow diagram after a first existing node having a first intermediate data set, and computing the intermediate data set for the new node comprises applying the data flow operation to the first intermediate data set.

13. The method of claim 11, wherein the new node has no predecessor in the flow diagram, and computing the intermediate data set for the new node comprises retrieving data from a data source to form the intermediate data set.

14. The method of claim 11, further comprising, in response to ceasing to detect the second user input, displaying a sampling of data from the intermediate data set in a data pane of the user interface.

15. The method of claim 11, wherein the data flow operation filters rows of data based on values of a first data field, and wherein displaying the one or more drop targets comprises displaying one or more drop targets immediately following existing nodes whose intermediate data sets include the first data field.

16. The method of claim 10, wherein the first user input selects an existing node from the flow diagram, and inserting the new node into the flow diagram at the first drop target creates a copy of the existing node.

17. The method of claim 16, wherein inserting the new node into the flow diagram at the first drop target further comprises removing the existing node from the flow diagram.

18. The method of claim 10, wherein the data flow operation comprises a plurality of operations that are executed in a specified sequence.

19. A non-transitory computer readable storage medium storing one or more programs configured for execution by a computer system having one or more processors, memory, and a display, the one or more programs comprising instructions for:

displaying a user interface that includes a plurality of panes, including a data flow pane and a palette pane, wherein the data flow pane includes a flow diagram having a plurality of existing nodes, each node specifying a respective operation to retrieve data from a respective data source, specifying a respective operation to transform data, or specifying a respective operation to create a respective output data set, and wherein the palette pane includes a plurality flow element templates;

receiving a first user input to select an existing node from the flow diagram or a flow element template from the palette pane;

in response to the first user input;

displaying a moveable icon representing a new node for placement in the flow diagram, wherein the new node specifies a data flow operation corresponding to the selected existing node or the selected flow element template;

displaying one or more drop targets in the flow diagram according to dependencies between the data flow operation of the new node and operations of the plurality of existing nodes;

receiving a second user input to place the moveable icon over a first drop target of the drop targets, and ceasing to detect the second user input; and

in response to ceasing to detect the second user input, inserting the new node into the flow diagram at the first drop target, wherein the new node performs the specified data flow operation.

20. The computer readable storage medium of claim 19, wherein each of the existing nodes has a respective intermediate data set computed according to the specified respective operation;

and

wherein inserting the new node into the flow diagram at the first drop target comprises computing an intermediate data set for the new node according to the specified data flow operation.