TIME-SENSITIVE CUBE

• US 20140279824A1
• Filed: 12/10/2013
• Published: 09/18/2014
• Est. Priority Date: 03/15/2013
• Status: Active Grant

• Current Assignee: Palantir Technologies Incorporated
• Original Assignee: Palantir Technologies Incorporated
• Inventors: Tamayo, Juan
• Granted Patent: US 8,868,486 B2
• Time in Patent Office: Days
• US Class Current: 707/600
• 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-implemented method of providing multi-dimensional time series objects to a user, the method comprising:

providing an electronic database configured to store a plurality of time-series objects including one or more time-series metric objects and a plurality of dimension objects;

generating, by a computing system including one or more hardware computer processors, based at least in part on the plurality of time-series objects, a time-sensitive OLAP cube;

receiving, via an input device of the computing system, an operation from a user comprising a selection of at least two of the plurality of dimension objects;

determining, by the computing system, based on the received operation, one or more relevant time-series metric objects; and

providing, on an electronic display of the computing system, the relevant time-series metric objects to the user.

2. The computer-implemented method of claim 1, wherein providing the relevant time-series metric objects to the user comprises:

outputting, on the electronic display of the computing system, a user interface including the relevant time-series metric objects in at least one of a two-dimensional way and a three-dimensional way.

3. The computer-implemented method of claim 1, wherein each of the plurality of dimension objects includes one or more characteristics.

4. The computer-implemented method of claim 3, wherein the one or more characteristics are structured hierarchically.

5. The computer-implemented method of claim 3, wherein the received operation further comprises a selection of at least one of the one or more characteristics.

6. The computer-implemented method of claim 1 further comprising:

providing, on the electronic display of the computing system, an interface configured to allow the user to manipulate the time-sensitive OLAP cube and provide operations.

7. The computer-implemented method of claim 1 further comprising:

receiving an expression from the user; and

applying the received expression to the relevant time-series metric objects.

8. A computer system comprising:

one or more hardware processors in communication with a computer readable medium storing software modules including instructions that are executable by the one or more hardware processors in order to cause the computer system to;

access, from an electronic data store, a plurality of time-sensitive objects including measures and dimensions;

generate, based at least in part on the accessed plurality of time-sensitive objects, a time-sensitive OLAP cube;

receive one or more OLAP operations; and

apply the received one or more OLAP operations to the time-sensitive OLAP cube and output calculated time-sensitive objects based at least in part on the OLAP operations.

9. The computer system of claim 8, wherein the software modules are further executable by the one or more hardware processors in order to cause the computer system to:

output, on an electronic display, a user interface including the calculated time-sensitive objects in at least one of a two-dimensional way and a three-dimensional way.

10. The computer system of claim 8, wherein at least one of the measures is time-sensitive.

11. The computer system of claim 8, wherein the one or more OLAP operations includes a selection of at least one dimension.

12. The computer system of claim 8, wherein each dimension includes one or more characteristics.

13. The computer system of claim 12, wherein the one or more characteristics are structured hierarchically.

14. The computer system of claim 12, wherein the one or more OLAP operations includes a selection of at least one of the one or more characteristics.

15. The computer system of claim 8, wherein the software modules are further executable by the one or more hardware processors in order to cause the computer system to:

provide a computer interface configured to allow a user to manipulate the time-sensitive OLAP cube and provide OLAP operations.

16. The computer system of claim 8, wherein the software modules are further executable by the one or more hardware processors in order to cause the computer system to:

apply one or more mathematical expressions to the calculated time-sensitive objects.

17. The computer system of claim 8, wherein the one or more OLAP operations include at least one of drill up, drill down, roll up, pivot, slice, or dice.

18. A computer system comprising:

an electronic database configured to store a plurality of time-series objects and a time-series OLAP cube based at least in part on one or more of the plurality of time-series objects; and

one or more hardware processors in communication with the electronic database and a computer readable medium storing software modules including instructions that are executable by the one or more hardware processors in order to cause the computer system to;

access the stored time-series OLAP cube;

present, on an electronic display, the time-series OLAP cube;

receive user-provided indications of operations to be applied to the presented time-series OLAP cube;

apply operations corresponding to the user-provided indications to the time-series OLAP cube; and

present, on the electronic display, determined time-series objects based at least in part on the applied operations.

19. The computer system of claim 18, wherein the time-series objects include one or more time-series metric objects and a plurality of dimension objects.

20. The computer system of claim 18, wherein the operations include at least one of drill up, drill down, roll up, pivot, slice, or dice.