Systems and methods for displaying data in split dimension levels

• US 9,092,467 B2
• Filed: 01/29/2013
• Issued: 07/28/2015
• Est. Priority Date: 09/16/2003
• Status: Expired due to Term

• Current Assignee: Board of Trustees of the Leland Stanford Junior University (Stanford University)
• Original Assignee: Board of Trustees of the Leland Stanford Junior University (Stanford University)
• Inventors: Stolte, Chris, Hanrahan, Patrick
• Primary Examiner(s): FILIPCZYK, MARCIN R
• Application Number:
  US13/753,452
• Publication Number:
  US 20130246484A1
• Time in Patent Office: 910 Days
• Field of Search: 707/805, 707/808, 707/999.006, 707/999.101, 707/797, 707/798, 707/999.007, 715/700, 345/440
• US Class Current: 1/1
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

Systems and methods for displaying data in split dimension levels are disclosed. In some implementations, a method includes: at a computer, obtaining a dimensional hierarchy associated with a dataset, wherein the dimensional hierarchy includes at least one dimension and a sub-dimension of the at least one dimension; and populating information representing data included in the dataset into a visual table having a first axis and a second axis, wherein the first axis corresponds to the at least one dimension and the second axis corresponds to the sub-dimension of the at least one dimension.

Claims

1. A method for visualizing a multidimensional dataset, comprising:

at a computing device having one or more processors and memory storing one or more programs configured for execution by the one or more processors;

identifying a dimensional hierarchy associated with the multidimensional dataset, wherein the dimensional hierarchy includes at least a first dimension and a sub-dimension of the first dimension;

displaying a graphical user interface window that includes a schema display region and a data visualization region that is distinct from the schema display region, wherein the schema display region includes a display of metadata for the plurality of dimensions and measures, including the first dimension and the sub-dimension;

detecting user requests to associate the metadata identifying the first dimension with a first axis shelf in the data visualization region and to associate the metadata identifying the sub-dimension with a second axis shelf in the data visualization region;

in response to the user requests,

generating a plurality of panes for a visual table in the data visualization region, wherein each pane has a first axis corresponding to the first dimension associated with the first axis shelf and a second axis corresponding to the sub-dimension associated with the second axis shelf, and wherein the second axis is in a different direction from the first axis; and

populating each pane in the visual table with a plurality of displayed marks, wherein each displayed mark corresponds to a respective tuple in the multidimensional dataset.

2. The method of claim 1, wherein the first axis is in horizontal direction and the second axis is in vertical direction.

3. The method of claim 1, wherein the first dimension and the sub-dimension are time dimensions, and wherein the first dimension is higher than the sub-dimension in a natural hierarchy of time.

4. The method of claim 1, wherein the first dimension and the sub-dimension are location dimensions, and wherein the first dimension is higher than the sub-dimension in a natural hierarchy of location.

5. The method of claim 1, wherein the first dimension and the sub-dimension are product dimensions, and wherein the first dimension is higher than the sub-dimension in a natural product hierarchy.

6. The method of claim 1, wherein the multidimensional dataset includes a plurality of data tuples, wherein each respective tuple in the plurality of tuples includes:

(i) a first field corresponding to the first dimension; and

(ii) a second field corresponding to the sub-dimension.

7. A computing system, comprising:

one or more processors;

memory; and

one or more programs, wherein the one or more programs are stored in the memory and are configured to be executed by the one or more processors, the one or more programs including instructions which when executed cause the computing system to;

identify a dimensional hierarchy associated with the multidimensional dataset, wherein the dimensional hierarchy includes at least a first dimension and a sub-dimension of the first dimension;

display a graphical user interface window that includes a schema display region and a data visualization region that is distinct from the schema display region, wherein the schema display region includes a display of metadata for the plurality of dimensions and measures, including the first dimension and the sub-dimension;

detect user requests to associate the metadata identifying the first dimension with a first axis shelf in the data visualization region and to associate the metadata identifying the sub-dimension with a second axis shelf in the data visualization region;

in response to the user requests,

generate a plurality of panes for a visual table in the data visualization region wherein each pane has a first axis corresponding to the first dimension associated with the first axis shelf and a second axis corresponding to the sub-dimension associated with the second axis shelf, and wherein the second axis is in a different direction from the first axis; and

populate each pane in the visual table with a plurality of displayed marks, wherein each displayed mark corresponds to a respective tuple in the multidimensional dataset.

8. The system of claim 7, wherein the first axis is in horizontal direction and the second axis is in vertical direction.

9. The system of claim 7, wherein the first dimension and the sub-dimension are time dimensions, and wherein the first dimension is higher than the sub-dimension in a natural hierarchy of time.

10. The system of claim 7, wherein the first dimension and the sub-dimension are location dimensions, and wherein the first dimension is higher than the sub-dimension in a natural hierarchy of location.

11. The system of claim 8, wherein the first dimension and the sub-dimension are product dimensions, and wherein the first dimension is higher than the sub-dimension in a natural product hierarchy.

12. The system of claim 7, wherein the multidimensional dataset includes a plurality of data tuples, wherein each respective tuple in the plurality of tuples includes:

(i) a first field corresponding to the first dimension; and

(ii) a second field corresponding to the sub-dimension.

13. A non-transitory computer readable storage medium having one or more computer programs embedded therein, the one or more computer programs comprising instructions, which when executed by a computing system, cause the computing system to:

identify a dimensional hierarchy associated with the multidimensional dataset, wherein the dimensional hierarchy includes at least a first dimension and a sub-dimension of the first dimension;

display a graphical user interface window that includes a schema display region and a data visualization region that is distinct from the schema display region, wherein the schema display region includes a display of metadata for the plurality of dimensions and measures, including the first dimension and the sub-dimension;

detect user requests to associate the metadata identifying the first dimension with a first axis shelf in the data visualization region and to associate the metadata identifying the sub-dimension with a second axis shelf in the data visualization region;

in response to the user requests,

generate a plurality of panes for a visual table in the data visualization region, wherein each pane has a first axis corresponding to the first dimension associated with the first axis shelf and a second axis corresponding to the sub-dimension associated with the second axis shelf, and wherein the second axis is in a different direction from the first axis; and

populate each pane in the visual table with a plurality of displayed marks, wherein each displayed mark corresponds to a respective tuple in the multidimensional dataset.

14. The non-transitory computer readable storage medium of claim 13, wherein the first axis is in horizontal direction and the second axis is in vertical direction.

15. The non-transitory computer readable storage medium of claim 13, wherein the first dimension and the sub-dimension are time dimensions, and wherein the first dimension is higher than the sub-dimension in a natural hierarchy of time.

16. The non-transitory computer readable storage medium of claim 13, the first dimension and the sub-dimension are location dimensions, and wherein the first dimension is higher than the sub-dimension in a natural hierarchy of location.

17. The non-transitory computer readable storage medium of claim 13, wherein the first dimension and the sub-dimension are product dimensions, and wherein the first dimension is higher than the sub-dimension in a natural product hierarchy.

18. The non-transitory computer readable storage medium of claim 13, wherein the multidimensional dataset includes a plurality of data tuples, wherein each respective tuple in the plurality of tuples includes:

(i) a first field corresponding to the first dimension; and

(ii) a second field corresponding to the sub-dimension.