Computer systems and methods for the query and visualization multidimensional databases

摘要

A method of generating a data visualization is performed at a computer having a display, one or more processors, and memory. The memory stores one or more programs for execution by the one or more processors. The process receives user specification of a plurality of characteristics of a data visualization. The data visualization is based on data from a multidimensional database. The characteristics specify at least x-position and y-position of data marks corresponding to tuples of data retrieved from the database. The process generates a data visualization according to the specified plurality of characteristics. The data visualization has an x-axis defined based on data for one or more first fields from the database that specify x-position of the data marks and the data visualization has a y-axis defined based on data for one or more second fields from the database that specify y-position of the data marks.

主权项

1. A method, comprising:
at a computer having a display, one or more processors, and memory storing one or more programs for execution by the one or more processors: displaying a graphical user interface on the display, wherein the graphical user interface includes:
a schema information region with a plurality of fields from a multidimensional database that includes at least one data hierarchy; anda data visualization region with a columns shelf, a rows shelf, and a color encoding shelf; receiving user actions to: (1) associate a first field with the columns shelf; (2) associate a second field with the rows shelf; and (3) associate a third field with the color encoding shelf; and generating a data visualization in the data visualization region in accordance with the received user actions, wherein:
the data visualization includes a plurality of data marks, each data mark corresponding to a respective retrieved tuple of data from the multidimensional database, each retrieved tuple including the first, second, and third fields;each of the data marks has an x-position defined according to data for the first field in the respective tuple;each of the data marks has a y-position defined according to data for the second field in the respective tuple; andeach of the data marks has a color assigned according to data for the third field in the respective tuple.