Time-sensitive cube

• US 9,852,205 B2
• Filed: 10/16/2014
• Issued: 12/26/2017
• Est. Priority Date: 03/15/2013
• Status: Active Grant

• Current Assignee: Palantir Technologies Incorporated
• Original Assignee: Palantir Technologies Incorporated
• Inventors: Tamayo, Juan
• Primary Examiner(s): Chbouki, Tarek
• Application Number:
  US14/516,386
• Publication Number:
  US 20150039554A1
• Time in Patent Office: 1,167 Days
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• 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
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes

Abstract

A time-sensitive cube data system is disclosed in which time-sensitive and/or time-series data objects are output in response to a user'"'"'s operations on a time-sensitive OLAP cube. The time-sensitive and/or time-series data objects output by the time-sensitive cube data system may be displayed to the user in any way that may be advantageous to the user'"'"'s understanding. The time-series objects output by the time-sensitive cube data system are more helpful than a single snapshot, as a user is able to see data trends over time.

Claims

1. A computer system comprising:

a computer processor; and

a computer readable storage medium storing program instructions configured for execution by the computer processor in order to configure the computer processor to;

generate a graphical user interface including at least a representation of a plurality of dimensions of a multidimensional data set;

receive, via the graphical user interface, a selection of at least two dimensions of the multidimensional data set;

determine a plurality of data objects each corresponding to different combinations of values of the selected dimensions;

generate a plurality of two-dimensional graphs that are spatially positioned in a single graphical user interface view, wherein;

each of the two-dimensional graphs is generated based on data associated with a respective one of the plurality of data objects,

each of the two-dimensional graphs comprises a respective x-axis and a respective y-axis,

the x-axes of the two-dimensional graphs each have a first common scale and a first common interval,

the y-axes of the two-dimensional graphs each have a second common scale and a second common interval, and

data represented in each respective two-dimensional graph is shown according to the first common scale and the first common interval of the x-axes and the second common scale and the second common interval of the y-axes; and

update the graphical user interface to display the single graphical user interface view including the plurality of two-dimensional graphs,

wherein;

the plurality of two-dimensional graphs are displayed in a plurality of rows and columns,

each combination of row and column corresponds to a different respective combination of values of the selected dimensions, and

the plurality of two-dimensional graphs are spatially positioned in the single graphical user interface view in corresponding rows and columns to enable a user to directly compare data represented in the plurality of two-dimensional graphs to view differences in data across the selected dimensions.

2. The computer system of claim 1, wherein the computer processor is further configured to:

receive, via the graphical user interface, an indication of a new interval;

re-generate the plurality of two-dimensional graphs such that at least one of the first common interval or the second common interval corresponds to the new interval; and

update the graphical user interface to display the single graphical user interface view including the re-generated two-dimensional graphs.

3. The computer system of claim 1, wherein the computer processor is further configured to:

receive, via the graphical user interface, a mathematical operation;

apply the mathematical operation to the determined data objects;

re-generate the plurality of two-dimensional graphs such that at least one of the x-axis or the y-axis of each of the two-dimensional graphs represents an output of the applied mathematical operation; and

update the graphical user interface to display the single graphical user interface view including the re-generated two-dimensional graphs.

4. The computer system of claim 3, wherein the received mathematical operation includes an indication of a property associated with the determined data objects.

5. The computer system of claim 3, wherein the received mathematical operation comprises a summation.

6. The computer system of claim 1, wherein the computer processor is further configured to:

receive, via the graphical user interface, an indication of a new interval and a mathematical operation;

apply the mathematical operation to the determined data objects;

re-generate the plurality of two-dimensional graphs such that;

at least one of the first common interval or the second common interval corresponds to the new interval; and

at least one of the x-axis or the y-axis of each of the two-dimensional graphs represents an output of the applied mathematical operation; and

update the graphical user interface to display the single graphical user interface view including the re-generated two-dimensional graphs.

7. The computer system of claim 1, wherein the computer processor is further configured to:

update the graphical user interface to display a plurality of selectable layers, each of the selectable layers corresponding to different values of one of the selected dimensions, each of the selectable layers including the plurality of two-dimensional graphs generated based on the corresponding value of the one of the selected dimensions.

8. The computer system of claim 7, wherein the computer processor is further configured to:

receive, via the graphical user interface, a selection of one of the plurality of layers; and

update the graphical user interface to display the selected layer including the corresponding two-dimensional graphs.

9. The computer system of claim 1, wherein the selection of at least two dimensions of the multidimensional data set comprises at least one of a drill up operation, a drill down operation, a roll up operation, a pivot operation, a slice operation, or a dice operation.

10. A method comprising:

generating, by a computing system including a computer processor, a graphical user interface including at least a representation of a plurality of dimensions of a multidimensional data set;

receiving, via the graphical user interface, a selection of at least two dimensions of the multidimensional data set;

determining, by the computing system, a plurality of data objects each corresponding to different combinations of values of the selected dimensions;

generating, by the computing system, a plurality of two-dimensional graphs that are spatially positioned in a single graphical user interface view, wherein;

each of the two-dimensional graphs is generated based on data associated with a respective one of the plurality of data objects,

the x-axes of the two-dimensional graphs each have a first common scale and a first common interval,

the y-axes of the two-dimensional graphs each have a second common scale and a second common interval, and

data represented in each respective two-dimensional graph is shown according to the first common scale and the first common interval of the x-axes and the second common scale and the second common interval of the y-axes; and

updating the graphical user interface to display the single graphical user interface view including the plurality of two-dimensional graphs,

wherein;

the plurality of two-dimensional graphs are displayed in a plurality of rows and columns,

each combination of row and column corresponds to a different respective combination of values of the selected dimensions, and

the plurality of two-dimensional graphs are spatially positioned in the single graphical user interface view in corresponding rows and columns to enable a user to directly compare data represented in the plurality of two-dimensional graphs to view differences in data across the selected dimensions.

11. The method of claim 10 further comprising:

receiving, via the graphical user interface, an indication of a new interval;

re-generating, by the computing system, the plurality of two-dimensional graphs such that at least one of the first common interval or the second common interval corresponds to the new interval; and

updating the graphical user interface to display the single graphical user interface view including the re-generated two-dimensional graphs.

12. The method of claim 11 further comprising:

receiving, via the graphical user interface, a mathematical operation;

applying, by the computing system, the mathematical operation to the determined data objects;

again re-generating, by the computing system, the plurality of two-dimensional graphs such that at least one of the x-axis or the y-axis of each of the two-dimensional graphs represents an output of the applied mathematical operation; and

updating the graphical user interface to display the single graphical user interface view including the again re-generated two-dimensional graphs.

13. The method of claim 12, wherein the received mathematical operation includes an indication of a property associated with the determined data objects.

14. The method of claim 10 further comprising:

updating the graphical user interface to display a plurality of selectable layers, each of the selectable layers corresponding to different values of one of the selected dimensions, each of the selectable layers including the plurality of two-dimensional graphs generated based on the corresponding value of the one of the selected dimensions.

15. The method of claim 14 further comprising:

receiving, via the graphical user interface, a selection of one of the plurality of layers; and

updating the graphical user interface to display the selected layer including the corresponding two-dimensional graphs.

16. A computer readable storage medium storing computer executable instructions configured for execution by one or more processors of a computer system to configure the one or more processors to:

generate a graphical user interface including at least a representation of a plurality of dimensions of a multidimensional data set;

receive, via the graphical user interface, a selection of at least two dimensions of the multidimensional data set;

determine a plurality of data objects each corresponding to different combinations of values of the selected dimensions;

generate a plurality of two-dimensional graphs that are spatially positioned in a single graphical user interface view, wherein;

each of the two-dimensional graphs is generated based on data associated with a respective one of the plurality of data objects,

each of the two-dimensional graphs comprises a respective x-axis and a respective y-axis,

the x-axes of the two-dimensional graphs each have a first common scale and a first common interval, and

the y-axes of the two-dimensional graphs each have a second common scale and a second common interval, and

data represented in each respective two-dimensional graph is shown according to the first common scale and the first common interval of the x-axes and the second common scale and the second common interval of the y-axes; and

update the graphical user interface to display the single graphical user interface view including the plurality of two-dimensional graphs,

wherein;

the plurality of two-dimensional graphs are displayed in a plurality of rows and columns,

each combination of row and column corresponds to a different respective combination of values of the selected dimensions, and

the plurality of two-dimensional graphs are spatially positioned in the single graphical user interface view in corresponding rows and columns to enable a user to directly compare data represented in the plurality of two-dimensional graphs to view differences in data across the selected dimensions.

17. The computer readable storage medium of claim 16, wherein the one or more processors are further configured to:

receive, via the graphical user interface, an indication of a new interval and a mathematical operation;

apply the mathematical operation to the determined data objects;

re-generate the plurality of two-dimensional graphs such that;

at least one of the first common interval or the second common interview corresponds to the new interval; and

at least one of the x-axis or the y-axis of each of the two-dimensional graphs represents an output of the applied mathematical operation; and

update the graphical user interface to display the single graphical user interface view including the re-generated two-dimensional graphs.

18. The computer readable storage medium of claim 17, wherein the received mathematical operation includes an indication of a property associated with the determined data objects.

19. The computer readable storage medium of claim 16, wherein the one or more processors are further configured to:

update the graphical user interface to display a plurality of selectable layers, each of the selectable layers corresponding to different values of one of the selected dimensions, each of the selectable layers including the plurality of two-dimensional graphs generated based on the corresponding value of the one of the selected dimensions.

20. The computer readable storage medium of claim 19, wherein the one or more processors are further configured to:

receive, via the graphical user interface, a selection of one of the plurality of layers; and

update the graphical user interface to display the selected layer including the corresponding two-dimensional graphs.