Systems and methods of generating color saturated data marks in data visualizations

• US 10,324,945 B2
• Filed: 08/06/2018
• Issued: 06/18/2019
• Est. Priority Date: 06/02/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, Tang, Diane L., Hanrahan, Patrick
• Primary Examiner(s): Lewis, Cheryl
• Application Number:
  US16/056,396
• Publication Number:
  US 20190073402A1
• Time in Patent Office: 316 Days
• 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 method of displaying data visualizations includes retrieving a dataset from a multidimensional database, where the dataset includes a plurality of fields, including first and second fields, and the first field is a data hierarchy that includes multiple subfields. The method further includes displaying a GUI with a first region displaying the plurality of fields (with the first field in a collapsed state), a second region with a plurality of shelves, and a third region. In response to receiving a user action to display the first field in an expanded state, the method displays the first field and the multiple subfields in a hierarchical structure. The method receives additional user actions to: (i) associate a first subfield of the plurality with a first shelf, and (ii) associate the second field with a second shelf, and then displays, in accordance with the user actions, a data visualization in the third region.

Claims

1. A method, comprising:

at a computer having a display, one or more processors, and memory storing one or more programs configured for execution by the one or more processors;

retrieving a dataset from a multidimensional database, wherein;

the dataset includes a plurality of fields, including a first field and a second field; and

the first field is a data hierarchy that comprises a plurality of subfields;

displaying a graphical user interface that comprises;

a first region displaying the plurality of fields from the dataset, wherein the first field is displayed in a collapsed state;

a second region with a plurality of shelves; and

a third region for displaying one or more data visualizations;

receiving a user action to display the first field in an expanded state;

in response to receiving the user action to display the first field in an expanded state, displaying the first field and the plurality of subfields in a hierarchical structure;

receiving additional user actions to;

(i) associate a first subfield of the plurality of subfields with a first shelf of the plurality of shelves, and (ii) associate the second field with a second shelf of the plurality of shelves; and

displaying, in accordance with the received additional user actions, a data visualization in the third region, wherein each data mark included in the data visualization has (i) an x-position defined according to data for the first subfield and (ii) a y-position defined according to data for the second field.

2. The method of claim 1, wherein:

the first field corresponds to a dimension; and

each subfield corresponds to a different semantic level of detail for the dimension.

3. The method of claim 1, wherein:

the first field is a date/time dimension;

the first subfield of the plurality of subfields is a year dimension; and

a second subfield of the plurality of subfields is a month dimension.

4. The method of claim 1, wherein the user action to display the first field in the expanded state is received at a location, within the first region, where the first field is displayed.

5. The method of claim 4, wherein:

the first region includes an affordance adjacent to the displayed first field, and the affordance is configured to toggle display of the first field between the collapsed and expanded states; and

receiving the user action to display the first field in the expanded state comprises detecting interaction with the affordance.

6. The method of claim 1, further comprising, after displaying the data visualization:

receiving a first new user action to drill down within the data hierarchy from the first subfield to a second subfield of the plurality of subfields; and

in response to receiving the first new user action, updating display of the data visualization in the third region, wherein each data mark included in the updated data visualization has (i) an x-position defined according to data for the second subfield and (ii) a y-position defined according to data for the second field.

7. The method of claim 6, further comprising, after displaying the updated data visualization:

receiving a second new user action to drill up within the data hierarchy from the second subfield back to the first subfield; and

in response to receiving the second new user action, displaying the data visualization in the third region.

8. The method of claim 6, wherein the first new user action to drill down within the data hierarchy is received within the first region.

9. The method of claim 6, wherein the first new user action to drill down within the data hierarchy is received outside of the first region.

10. A computer system for generating data visualizations, comprising:

a display;

one or more processors;

memory; and

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

retrieving a dataset from a multidimensional database, wherein;

the dataset includes a plurality of fields, including a first field and a second field; and

the first field is a data hierarchy that comprises a plurality of subfields;

displaying a graphical user interface that comprises;

a first region displaying the plurality of fields from the dataset, wherein the first field is displayed in a collapsed state;

a second region with a plurality of shelves; and

a third region for displaying one or more data visualizations;

receiving a user action to display the first field in an expanded state;

in response to receiving the user action to display the first field in an expanded state, displaying the first field and the plurality of subfields in a hierarchical structure;

receiving additional user actions to;

(i) associate a first subfield of the plurality of subfields with a first shelf of the plurality of shelves, and (ii) associate the second field with a second shelf of the plurality of shelves; and

displaying, in accordance with the received additional user actions, a data visualization in the third region, wherein each data mark included in the data visualization has (i) an x-position defined according to data for the first subfield and (ii) a y-position defined according to data for the second field.

11. The computer system of claim 10, wherein:

the first field corresponds to a dimension; and

each subfield corresponds to a different semantic level of detail for the dimension.

12. The computer system of claim 10, wherein:

the first field is a date/time dimension;

the first subfield of the plurality of subfields is a year dimension; and

a second subfield of the plurality of subfields is a month dimension.

13. The computer system of claim 10, wherein the user action to display the first field in the expanded state is received at a location, within the first region, where the first field is displayed.

14. The computer system of claim 13, wherein:

the first region includes an affordance adjacent to the displayed first field, and the affordance is configured to toggle display of the first field between the collapsed and expanded states; and

receiving the user action to display the first field in the expanded state comprises detecting interaction with the affordance.

15. The computer system of claim 10, wherein the one or more programs further comprise instructions for, after displaying the data visualization:

receiving a first new user action to drill down within the data hierarchy from the first subfield to a second subfield of the plurality of subfields; and

in response to receiving the first new user action, updating display of the data visualization in the third region, wherein each data mark included in the updated data visualization has (i) an x-position defined according to data for the second subfield and (ii) a y-position defined according to data for the second field.

16. The computer system of claim 15, wherein the one or more programs further comprise instructions for, after displaying the updated data visualization:

receiving a second new user action to drill up within the data hierarchy from the second subfield back to the first subfield; and

in response to receiving the second new user action, displaying the data visualization in the third region.

17. The computer system of claim 15, wherein the first new user action to drill down within the data hierarchy is received within the first region.

18. The computer system of claim 15, wherein the first new user action to drill down within the data hierarchy is received outside of the first region.

19. 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:

retrieving a dataset from a multidimensional database, wherein;

the dataset includes a plurality of fields, including a first field and a second field; and

the first field is a data hierarchy that comprises a plurality of subfields;

displaying a graphical user interface that comprises;

a first region displaying the plurality of fields from the dataset, wherein the first field is displayed in a collapsed state;

a second region with a plurality of shelves; and

a third region for displaying one or more data visualizations;

receiving a user action to display the first field in an expanded state;

in response to receiving the user action to display the first field in an expanded state, displaying the first field and the plurality of subfields in a hierarchical structure;

receiving additional user actions to;

(i) associate a first subfield of the plurality of subfields with a first shelf of the plurality of shelves, and (ii) associate the second field with a second shelf of the plurality of shelves; and

displaying, in accordance with the received additional user actions, a data visualization in the third region, wherein each data mark included in the data visualization has (i) an x-position defined according to data for the first subfield and (ii) a y-position defined according to data for the second field.

20. The computer-readable storage medium of claim 19, wherein:

the first field is a date/time dimension;

the first subfield of the plurality of subfields is a year dimension; and

a second subfield of the plurality of subfields is a month dimension.