Computer systems and methods for automatically viewing multidimensional databases

摘要

A method for automatically forming the clearest and most useful visual plot for a given dataset of tuples. A best view type is selected for a view that includes a subsequently added new field. The visual plot is populated with the data in the view and then automatically rendered for the user. A dataset that is retrieved from a storage is analyzed to identify all the data types found in the dataset, and to determine the best view type to assign to the dataset's views. The visual plot is then populated with the data according to this best view type, and is automatically rendered for the user.

主权项

1. A computer implemented method for generating a graphical representation of a dataset, comprising:
at a computer having one or more processors and memory storing one or more programs for execution by the one or more processors:
displaying a graphical user interface window including a schema display region and a data visualization region that is distinct from the schema display region, wherein the schema display region includes a plurality of displayed data fields from the dataset;receiving, via the graphical user interface window, a temporal sequence of user selections from the displayed data fields in the schema display region, the temporal sequence of user selections having a particular temporal order of data types; andin response to receiving the sequence of user selections from the displayed data fields:
determining a view type for visualizing a portion of the dataset based on the particular temporal order of data types; andgenerating a graphical representation of the portion of the dataset in the data visualization region in accordance with the determined view type.