Patent ID: 11966406
Assignee: TABLEAU SOFTWARE, LLC
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A method of generating data visualizations, comprising:
at a computer having a display, one or more processors and memory storing one or more programs configured for execution by the one or more processors:
receiving a visual specification, which specifies a data source, a plurality of visual variables, and a plurality of data fields from the data source, wherein each of the visual variables is associated with either (i) a respective one or more of the data fields or (ii) one or more filters, and each of the data fields is identified as either a dimension or a measure;
obtaining a data model encoding the data source as a tree of logical tables, each logical table having its own physical representation and including a respective one or more logical fields, each logical field corresponding to either a data field or a calculation that spans one or more logical tables, wherein each edge of the tree connects two logical tables that are related;
generating a dimension subquery based on logical tables that supply the data fields for the dimensions and the filters;
generating, for each measure, based on the logical tables that supply the data fields for the respective measure and the filters, an aggregated measure subquery grouped by the dimensions;
forming a final query by joining, using the dimensions, the dimension subquery to each of the aggregated measure subqueries;
executing the final query against the data source to retrieve tuples that comprise distinct ordered combinations of data values for the data fields; and
building and displaying a data visualization according to the data fields in the tuples and according to the visual variables to which each of the data fields is associated.