Computer systems and methods for the query and visualization of multidimensional databases

• US 9,183,235 B2
• Filed: 03/03/2015
• Issued: 11/10/2015
• Est. Priority Date: 06/02/2003
• Status: Active Grant

• Current Assignee: Board of Trustees of the Leland Stanford Junior University (Stanford Management Co.)
• Original Assignee: Board of Trustees of the Leland Stanford Junior University (Stanford Management Co.)
• Inventors: Stolte, Chris, Tang, Diane L., Hanrahan, Patrick
• Primary Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US14/637,333
• Publication Number:
  US 20150242446A1
• Time in Patent Office: 252 Days
• Field of Search: 707/802, 707/805, 707/786
• US Class Current: 1/1
• CPC Class Codes: G06F 16/212 with details for data modelling support
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 16/282 Hierarchical databases, e.g. IMS, LDAP data stores or Lotus Notes
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 2216/03 Data mining
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 3/04847 Interaction techniques to control parameter settings, e.g. interaction with sliders or dials
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/956 Hierarchical
• CPC Class Codes: Y10S 707/959 Network
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 : Object-oriented database structure processing

Abstract

A computer displays a graphical user interface on its display. The graphical user interface includes a schema information region and a data visualization region. The schema information region includes a plurality of fields of a multi-dimensional database that includes at least one data hierarchy. The data visualization region includes a columns shelf and a rows shelf. The computer detects user actions to associate one or more first fields with the columns shelf and to associate one or more second fields with the rows shelf. The computer generates a visual table in the data visualization region in accordance with the user actions. The visual table includes one or more panes. Each pane has an x-axis defined based on data for the one or more first fields, and each pane has a y-axis defined based on data for the one or more second fields.

Claims

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 and a data visualization region, wherein the schema information region includes a plurality of fields from a multi-dimensional database that includes at least one data hierarchy, and wherein the data visualization region includes a columns shelf and a rows shelf;

detecting user actions to associate one or more first fields with the columns shelf and to associate one or more second fields with the rows shelf; and

generating a visual table in the data visualization region in accordance with the user actions, wherein the visual table includes one or more panes, each pane has an x-axis defined based on data for the one or more first fields associated with the columns shelf, and each pane has a y-axis defined based on data for the one or more second fields associated with the rows shelf.

2. The method of claim 1, wherein generating the visual table comprises generating within each pane a plurality of visual marks, each corresponding to a respective tuple retrieved from the database.

3. The method of claim 1, wherein the data hierarchy is associated with time and comprises a plurality of fields corresponding to different time dimensions.

4. The method of claim 1, wherein the schema information region and the data visualization region are displayed as separate windows in the graphical user interface on the display.

5. The method of claim 1, wherein each of a plurality fields corresponds to a measure or a dimension of the database.

6. The method of claim 1, further comprising:

retrieving a plurality of tuples from the database according to the fields associated with the rows and columns shelves; and

displaying the retrieved tuples as visual marks in the visual table.

7. A computer system for ranking data visualizations, comprising:

a display;

one or more processors;

memory; and

one or more programs stored in the memory for execution by the one or more processors, the one or more programs comprising instructions for;

displaying a graphical user interface on the display, wherein the graphical user interface includes a schema information region and a data visualization region, wherein the schema information region includes a plurality of fields from a multi-dimensional database that includes at least one data hierarchy, and wherein the data visualization region includes a columns shelf and a rows shelf;

detecting user actions to associate one or more first fields with the columns shelf and to associate one or more second fields with the rows shelf; and

generating a visual table in the data visualization region in accordance with the user actions, wherein the visual table includes one or more panes, each pane has an x-axis defined based on data for the one or more first fields associated with the columns shelf, and each pane has a y-axis defined based on data for the one or more second fields associated with the rows shelf.

8. The computer system of claim 7, wherein the instructions for generating the visual table further comprise instructions for generating within each pane a plurality of visual marks, each corresponding to a respective tuple retrieved from the database.

9. The computer system of claim 7, wherein the data hierarchy is associated with time and comprises a plurality of fields corresponding to different time dimensions.

10. The computer system of claim 7, wherein the instructions for displaying the graphical user interface further comprise instructions for displaying the schema information region and the data visualization region as separate windows on the display.

11. The computer system of claim 7, wherein each of a plurality of fields corresponds to a measure or a dimension of the database.

12. The computer system of claim 7, the one or more programs further comprising instructions for:

retrieving a plurality of tuples from the database according to the fields associated with the rows and columns shelves; and

displaying the retrieved tuples as visual marks in the visual table.

13. 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 storing one or more programs for execution by the one or more processors, the one or more programs comprising instructions for:

displaying a graphical user interface on the display, wherein the graphical user interface includes a schema information region and a data visualization region, wherein the schema information region includes a plurality of fields from a multi-dimensional database that includes at least one data hierarchy, and wherein the data visualization region includes a columns shelf and a rows shelf;

detecting user actions to associate one or more first fields with the columns shelf and to associate one or more second fields with the rows shelf; and

generating a visual table in the data visualization region in accordance with the user actions, wherein the visual table includes one or more panes, each pane has an x-axis defined based on data for the one or more first fields associated with the columns shelf, and each pane has a y-axis defined based on data for the one or more second fields associated with the rows shelf.

14. The computer readable storage medium of claim 13, wherein the instructions for generating the visual table further comprise instructions for generating within each pane a plurality of visual marks, each corresponding to a respective tuple retrieved from the database.

15. The computer readable storage medium of claim 13, wherein the data hierarchy is associated with time and comprises a plurality of fields corresponding to different time dimensions.

16. The computer readable storage medium of claim 13, wherein the instructions for displaying the graphical user interface further comprise instructions for displaying the schema information region and the data visualization region as separate windows on the display.

17. The computer readable storage medium of claim 13, wherein each of a plurality of fields corresponds to a measure or a dimension of the database.

18. The computer readable storage medium of claim 13, the one or more programs further comprising instructions for:

retrieving a plurality of tuples from the database according to the fields associated with the rows and columns shelves; and

displaying the retrieved tuples as visual marks in the visual table.