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

Claim 19:
20. A non-transitory computer-readable storage medium storing one or more programs configured for execution by a computer system having a display, one or more processors, and memory, the one or more programs comprising instructions for:
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 a respective one or more of the data fields and each of the data fields is identified as either a dimension data field or a measure data field;
identifying an object model of the data source, each object in the object model having a respective primary key;
from the object model, identifying a minimal subtree that includes all of the dimension data fields;
constructing a query from the minimal subtree that accesses the dimension data fields, the minimal subtree including a root node and all other objects in the minimal subtree are reachable from the root node by a sequence of relationships between primary keys and foreign keys of objects in the object model;
executing the query against the data source to retrieve a set of tuples, each tuple in the set of tuples comprising a unique ordered combination of data values for the dimension data fields and forming a distinct data row in a data table for generating a data visualization;
for each measure data field, extending the set of tuples by inserting an additional column in the data table whose values are aggregated data values corresponding to the respective measure data field; and
building and displaying the data visualization according to the data fields in the extended set of tuples and according to the visual variables to which each of the data fields is associated.