Graphical user interface for generating and displaying data visualizations that use relationships

Patent metadata

Field	Value
Publication number	US-9613086-B1
Application number	US-201414461345-A
Country	US
Kind code	B1
Filing date	Aug 15, 2014
Priority date	Aug 15, 2014
Publication date	Apr 4, 2017
Grant date	Apr 4, 2017

Abstract

A method generates a graphical user interface, which includes a schema information region and a data visualization region. The schema information region includes field names, each associated with a data field from a data source, and relationship names, each associated with a relation between rows of the data source. The data visualization region includes a row shelf, a column shelf, and a connector shelf. The method detects user selection of field names and a request to associate those field names with respective shelves in the data visualization region. The method also detects user selection of relationship names and a request to associate those relationship names with respective shelves in the data visualization region. The method generates a visual graphic in the data visualization region according to the associations between the user-selected field names and corresponding shelves and the associations between the user-selected relationship names and corresponding shelves.

First claim

What is claimed is:

1. A method of generating a graphical representation of a data source, comprising:
at a computer having one or more processors and memory:
generating and displaying a graphical user interface on a computer display, wherein the graphical user interface includes a schema information region and a data visualization region, wherein the schema information region includes multiple field names, each field name associated with a data field from the data source and includes one or more relationship names, each relationship name associated with a relation between rows of the data source, and wherein the data visualization region includes a plurality of shelves including a row shelf, a column shelf, and a connector shelf;
for each of the row shelf, column shelf, and the connector shelf, detecting a user selection of a respective field name or relationship name and a request to associate the respective field name or relationship name with the respective shelf; and
generating a visual graphic in accordance with the respective associations between the user-selected field names and corresponding shelves and in accordance with the respective associations between the user-selected relationship names and corresponding shelves, and displaying the visual graphic in the data visualization region.

2. The method of claim 1 , wherein the visual graphic includes visual marks corresponding to retrieved tuples from the data source, wherein vertical and horizontal placement of the visual marks are respectively based on items associated with the row shelf and column shelf respectively by the user, and wherein each item of the items comprises a field name or a relationship name.

3. The method of claim 2 , wherein the visual graphic further includes edges that visually connect the visual marks, wherein the edges correspond to a relationship name associated with the connector shelf by the user.

4. The method of claim 2 , wherein the visual graphic further includes edges that visually connect the visual marks, wherein the edges correspond to a first field name associated with the connector shelf by the user, and wherein each edge connects two visual marks whose corresponding tuples share a same field value for the first field name.

5. The method of claim 2 , wherein a first relationship name is associated with the column shelf or row shelf by the user, and wherein the corresponding horizontal or vertical placement of visual marks is determined by a user-selected function of the tuples based on a traversal of a graph corresponding to the tuples and the first relationship.

6. The method of claim 1 , wherein a first field name of the multiple field names identifies a computed field whose value for each tuple is computed based on an associated data field from the data source and a first relationship, and wherein the first field name is associated with the row shelf or the column shelf.

7. The method of claim 6 , wherein the computed value of the computed field for each tuple is based on a traversal of a graph corresponding to the tuples and the first relationship.

8. The method of claim 1 , wherein the data visualization region further includes one or more connector property shelves, the method further comprising:
detecting a user selection of a relationship name or a field name and a user request to associate the user-selected relationship name or field name with a first connector property shelf, wherein generating the visual graphic includes visually formatting the connectors in accordance with the user selected relationship name or field name for the first connector property shelf.

9. The method of claim 8 , wherein the first connector property shelf specifies the color or width of connectors.

10. A computer, comprising:
one or more processors;
memory; and
one or more programs stored in the memory configured for execution by the one or more processors, the one or more programs comprising instructions for:
generating and displaying a graphical user interface on a computer display, wherein the graphical user interface includes a schema information region and a data visualization region, wherein the schema information region includes multiple field names, each field name associated with a data field from the data source and includes one or more relationship names, each relationship name associated with a relation between rows of the data source, and wherein the data visualization region includes a plurality of shelves including a row shelf, a column shelf, and a connector shelf;
for each of the row shelf, column shelf, and the connector shelf, detecting a user selection of a respective field name or relationship name and a request to associate the respective field name or relationship name with the respective shelf; and
generating a visual graphic in accordance with the respective associations between the user-selected field names and corresponding shelves and in accordance with the respective associations between the user-selected relationship names and corresponding shelves, and displaying the visual graphic in the data visualization region.

11. The computer of claim 10 , wherein the visual graphic includes visual marks corresponding to retrieved tuples from the data source, wherein vertical and horizontal placement of the visual marks are respectively based on items associated with the row shelf and column shelf respectively by the user, and wherein each item of the items comprises a field name or a relationship name.

12. The computer of claim 11 , wherein the visual graphic further includes edges that visually connect the visual marks, wherein the edges correspond to a relationship name associated with the connector shelf by the user.

13. The computer of claim 11 , wherein the visual graphic further includes edges that visually connect the visual marks, wherein the edges correspond to a first field name associated with the connector shelf by the user, and wherein each edge connects two visual marks whose corresponding tuples share a same field value for the first field name.

14. The computer of claim 11 , wherein a first relationship name is associated with the column shelf or row shelf by the user, and wherein the corresponding horizontal or vertical placement of visual marks is determined by a user-selected function of the tuples based on a traversal of a graph corresponding to the tuples and the first relationship.

15. The computer of claim 10 , wherein a first field name identifies a computed field whose value for each tuple is computed based on the associated data field from the data source and a first relationship, and wherein the first field name is associated with the row shelf or the column shelf.

16. The computer of claim 15 , wherein the computed value of the computed field for each tuple is based on a traversal of a graph corresponding to the tuples and the first relationship.

17. The computer of claim 10 , wherein the data visualization region further includes one or more connector property shelves, the one or more programs further comprising instructions for:
detecting a user selection of a relationship name or a field name and a user request to associate the user-selected relationship name or field name with a first connector property shelf, wherein generating the visual graphic includes visually formatting the connectors in accordance with the user selected relationship name or field name for the first connector property shelf.

18. A non-transitory computer readable storage medium storing one or more programs configured for execution by a computer having

Assignees

• Tableau Software Inc

Inventors

• Sherman Scott

Classifications

• G06F16/242 Primary

  Query formulation · CPC title

• G06F16/248

  Presentation of query results · CPC title

• G06F17/30554

  Physics · mapped topic

• G06F17/30389 Primary

  Physics · mapped topic