Interactive multi-dimensional nested table supporting scalable real-time querying of large data volumes

• US 10,417,258 B2
• Filed: 12/19/2014
• Issued: 09/17/2019
• Est. Priority Date: 12/19/2013
• Status: Active Grant

• Current Assignee: Rill Data, Inc.
• Original Assignee: Exposit Labs, Inc.
• Inventors: Ogievetsky, Vadim, Driscoll, Michael, Kin, Young Min, Allen, Elizabeth, Chu, Katherine, Oss, Ofir, Smith, Adam, Candela, Luca
• Primary Examiner(s): Ly, Cheyne D
• Application Number:
  US14/577,466
• Publication Number:
  US 20150178339A1
• Time in Patent Office: 1,733 Days
• Field of Search: 707778
• 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
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Displaying a visual representation of table, including generating a visual representation of a table including a plurality of dimensions, displaying the visual representation of the table, where a first dimension value corresponding to one of the plurality of dimensions is collapsed when the table is initially generated, and a second dimension value corresponding to one of the plurality of dimensions is expanded such that sub-dimension values for the first dimension value are not visible, and sub-dimension values for the second dimension value are visible, detecting that a user has placed a first dimension value manipulator corresponding to said first dimension value into an expand mode, and in response to detecting the first dimension value manipulator is in an expand mode, expanding the first dimension value in the displayed visual representation of the table such that the sub-dimension values for the first dimension value are visible.

Claims

1. A non-transitory computer readable storage medium or media having computer-executable instructions stored therein that when executed cause a machine to perform operations comprising:

generating a visual representation of a table based on stored data, the table including a plurality of dimensions;

causing display of the visual representation of the table, wherein a first dimension value corresponding to a first dimension of the plurality of dimensions is collapsed when the table is initially generated, and a second dimension value corresponding to the first dimension of the plurality of dimensions is expanded when the table is initially generated, such that sub-dimension values for the first dimension value are not visible, and sub-dimension values for the second dimension value are visible, the sub-dimension values for the first dimension value and the sub-dimension values for the second dimension value corresponding to a second dimension of the plurality of dimensions, wherein the second dimension is a sub-dimension of the first dimension;

detecting a user input modifying a hierarchical relationship between the first and the second dimensions;

in response to detecting the user input, generating a rearranged hierarchy of the plurality of dimensions, the first dimension being a sub-dimension of the second dimension in the rearranged hierarchy; and

changing which sub-dimension values are visible based on the rearranged hierarchy of the plurality of dimensions;

generating a metric value calculated based on the sub-dimension values of the first dimension value;

displaying the metric value corresponding to the first dimension value in the visual representation of the table;

detecting that a user has placed a first dimension value manipulator corresponding to the first dimension value into an expand mode; and

in response to detecting the first dimension value manipulator is in the expand mode, expanding the first dimension value in the displayed visual representation of the table such that the sub-dimension values for the first dimension value are visible.

2. The computer readable storage medium or media of claim 1, wherein when the table is initially generated, the sub-dimension values for the second dimension value that are visible are a first subset of all sub-dimension values for the second dimension value, the first subset including the sub-dimension values for the second dimension value that are determined to satisfy a predetermined relevancy threshold.

3. The computer readable storage medium or media of claim 2, the operations further comprising:

detecting that a sub-manipulator, corresponding to the sub-dimension values for the second dimension value, is in an expand mode; and

in response to detecting that the sub-manipulator is in the expand mode, displaying all the sub-dimension values for the second dimension value in the visual representation of the table.

4. The computer readable storage medium or media of claim 1, the operations further comprising:

receiving a request from a user via the visual representation of the table to add a dimension to the visual representation of the table; and

in response to the request to add a dimension, adding an additional dimension and at least one additional manipulator that allows a user to manipulate the visual representation of the table based on the additional dimension.

5. The computer readable storage medium or media of claim 2, wherein changing which sub-dimension values are visible based on the rearranged hierarchy of the plurality of dimensions includes displaying a second subset of the sub-dimension values for the second dimension value.

6. The computer readable storage medium or media of claim 1, the operations further comprising:

receiving user input indicating a selection of at least two rows of the table;

dynamically performing a calculation based on data in the at least two rows; and

displaying a result of the calculation in the visual representation of the table.

7. A method for displaying a visual representation of a table, comprising:

generating a visual representation of a table based on stored data, the table including a plurality of dimensions;

causing display of the visual representation of the table, wherein a first dimension value corresponding to a first dimension of the plurality of dimensions is collapsed when the table is initially generated, and a second dimension value corresponding to the first dimension of the plurality of dimensions is expanded when the table is initially generated, such that sub-dimension values for the first dimension value are not visible, and sub-dimension values for the second dimension value are visible, the sub-dimension values for the first dimension value and the sub-dimension values for the second dimension value corresponding to a second dimension of the plurality of dimensions, wherein the second dimension is a sub-dimension of the first dimension;

detecting a user input modifying a hierarchical relationship between the first and the second dimensions;

in response to detecting the user input, generating a rearranged hierarchy of the plurality of dimensions, the first dimension being a sub-dimension of the second dimension in the rearranged hierarchy; and

changing which-sub-dimension values are visible based on the rearranged hierarchy of the plurality of dimensions;

generating a metric value calculated based on the sub-dimension values of the first dimension value;

displaying the metric value corresponding to the first dimension value in the visual representation of the table;

detecting that a user has placed a first dimension value manipulator corresponding to the first dimension value into an expand mode; and

in response to detecting the first dimension value manipulator is in the expand mode, expanding the first dimension value in the displayed visual representation of the table such that the sub-dimension values for the first dimension value are visible.

8. The method of claim 7, wherein when the table is initially generated, the sub-dimension values for the second dimension value that are visible are a first subset of all sub-dimension values for the second dimension value, the first subset including the sub-dimension values for the second dimension value that are determined to satisfy a predetermined relevancy threshold.

9. The method of claim 8, further comprising:

detecting that a sub-manipulator, corresponding to the sub-dimension values for the second dimension value, is in an expand mode; and

in response to detecting that the sub-manipulator is in the expand mode, displaying all the sub-dimension values for the second dimension value in the visual representation of the table.

10. The method of claim 7, further comprising:

receiving a request from a user, via the visual representation of the table, to add a dimension to the visual representation of the table; and

in response to the request to add a dimension, adding an additional dimension and at least one additional manipulator that allows a user to manipulate the visual representation of the table based on the additional dimension.

11. The method of claim 8, wherein changing which sub-dimension values are visible based on the rearranged hierarchy of the plurality of dimensions includes displaying a second subset of the sub-dimension values for the second dimension value.

12. The method of claim 7, further comprising:

receiving user input indicating a selection of at least two rows of the table;

dynamically performing a calculation based on data in the at least two rows; and

displaying a result of the calculation in the visual representation of the table.

13. A computer system for displaying a visual representation of a table, comprising:

one or more processors;

a memory coupled to the one or more processors and storing instructions which, when executed by the one or more processors, cause the one or more processors to perform operations comprising;

generating a visual representation of a table based on stored data, the table including a plurality of dimensions;

causing display of the visual representation of the table, wherein a first dimension value corresponding to a first dimension of the plurality of dimensions is collapsed when the table is initially generated, and a second dimension value corresponding to the first dimension of the plurality of dimensions is expanded when the table is initially generated, such that sub-dimension values for the first dimension value are not visible, and sub-dimension values for the second dimension value are visible, the sub-dimension values for the first dimension value and the sub-dimension values for the second dimension value corresponding to a second dimension of the plurality of dimensions, wherein the second dimension is a sub-dimension of the first dimension;

detecting a user input modifying a hierarchical relationship between the first and the second dimensions;

in response to detecting the user input, generating a rearranged hierarchy of the plurality of dimensions, the first dimension being a sub-dimension of the second dimension in the rearranged hierarchy; and

changing which-sub-dimension values are visible based on the rearranged hierarchy of the plurality of dimensions;

generating a metric value calculated based on the sub-dimension values of the first dimension value;

displaying the metric value corresponding to the first dimension value in the visual representation of the table;

detecting that a user has placed a first dimension value manipulator corresponding to the first dimension value into an expand mode; and

in response to detecting the first dimension value manipulator is in the expand mode, expanding the first dimension value in the displayed visual representation of the table such that the sub-dimension values for the first dimension value are visible.

14. The computer system of claim 13, wherein when the table is initially generated, the sub-dimension values for the second dimension value that are visible are a first subset of all sub-dimension values for the second dimension value, the first subset including the sub-dimension values for the second dimension value that are determined to satisfy a predetermined relevancy threshold.

15. The computer system of claim 14, the operations further comprising:

detecting that a sub-manipulator, corresponding to the sub-dimension values for the second dimension value, is in an expand mode; and

in response to detecting that the sub-manipulator is in the expand mode, displaying all the sub-dimension values for the second dimension value in the visual representation of the table.

16. The computer system of claim 13, the operations further comprising:

receiving a request from a user, via the visual representation of the table, to add a dimension to the visual representation of the table; and

in response to the request to add a dimension, adding an additional dimension and at least one additional manipulator that allows a user to manipulate the visual representation of the table based on the additional dimension.

17. The computer system of claim 14, wherein changing which sub-dimension values are visible based on the rearranged hierarchy of the plurality of dimensions includes displaying a second subset of the sub-dimension values for the second dimension value.