Time-series analysis system

• US 9,501,851 B2
• Filed: 09/30/2015
• Issued: 11/22/2016
• Est. Priority Date: 10/03/2014
• Status: Active Grant

• Current Assignee: Palantir Technologies Incorporated
• Original Assignee: Palantir Technologies Incorporated
• Inventors: Cervelli, Daniel, Skiff, David, Tobin, David, Cai, Allen
• Primary Examiner(s): Sams, Michelle L
• Application Number:
  US14/871,465
• Publication Number:
  US 20160098176A1
• Time in Patent Office: 419 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2477 Temporal data queries
• CPC Class Codes: G06F 2203/04806 Zoom, i.e. interaction techniques or interactors for controlling the zooming operation
• 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/04845 for image manipulation, e.g. dragging, rotation, expansion or change of colour
• CPC Class Codes: G06F 3/04847 Interaction techniques to control parameter settings, e.g. interaction with sliders or dials
• CPC Class Codes: G06T 11/206 Drawing of charts or graphs

Abstract

Various systems and methods are provided that display various graphs in an interactive user interface in substantially real-time in response to input from a user in order to determine information related to measured data points and provide the determined information to the user in the interactive user interface. For example, a computing device may be configured to retrieve data from one or more databases and generate one or more interactive user interfaces. The one or more interactive user interfaces may display the retrieved data in one or more graphs, such as time-series or scatterplots. The user interface may be interactive in that a user may manipulate one graph, which causes an identical or nearly identical manipulation of another displayed graph in real-time. The manipulations may occur even if the displayed graphs include data across different time ranges.

Claims

1. A computing system configured to access one or more databases in substantially real-time in response to input from a user provided in an interactive user interface in order to determine information related to measured data points and provide the determined information to the user in the interactive user interface, the computing system comprising:

a computer processor; and

a database storing at least first sensor values for a first sensor at each of a plurality of times and second sensor values for a second sensor at each of a plurality of times;

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

generate user interface data for rendering the interactive user interface on a computing device, the interactive user interface including a first container and a second container, wherein the first container includes a first graph and the second container includes a second graph, wherein the first graph includes first sensor values for the first sensor over a first time period and the second graph includes second sensor values for the second sensor over a second time period that is shorter than the first time period, and wherein portions of the first graph and the second graph are each selectable by the user;

receive an identification of a selection by the user of a first data point in the first graph, wherein the first data point corresponds to a first time range; and

in response to the selection by the user of the first data point in the first graph;

update the user interface data such that the interactive user interface includes a first marker at a location of the first data point in the first graph;

access the database to determine a second sensor value that corresponds to a beginning of the first time range and a second sensor value that corresponds to an end of the first time range; and

update the user interface data to include both a second marker at a location of a second data point in the second graph that corresponds to the beginning of the first time range and a third marker at a location of a third data point in the second graph that corresponds to the end of the first time range.

2. The computing system of claim 1, wherein the program instructions are further configured to cause the computing system to:

receive an indication from the user of a change to the first time period in the first graph;

in response to receiving the indication from the user of the change to the first time period, adjust positions of the second and third markers indicating the first time range in the second graph.

3. The computing system of claim 1, wherein the computer readable storage medium further stores program instructions that cause the computing system to update the user interface data to include a third container, wherein the third container includes a list of events that occurred within the first time range.

4. The computing system of claim 3, wherein the first graph, for each event that occurred within the first time range, includes a mark that indicates a data point on the first graph that corresponds with a time that the respective event occurred.

5. The computing system of claim 4, wherein the computer readable storage medium further stores program instructions that cause the computing system to update the user interface data to include a fourth marker at a first location in the first graph corresponding to a first event in the list of events in response to selection by the user of a second location in the third container that corresponds to the first event.

6. The computing system of claim 3, wherein the computer readable storage medium further stores program instructions that cause the computing system to:

receive an indication by the user of a selection in the first graph at a fourth data point such that a new event is added at a time that corresponds with the fourth data point; and

update the user interface data such that the third container includes an identification of the new event.

7. The computing system of claim 6, wherein the computer readable storage medium further stores program instructions that cause the computing system to:

receive an indication by the user that the new event corresponds with the first graph; and

update the user interface data such that a first mark is displayed in the first graph at the time that corresponds with the fourth data point.

8. The computing system of claim 6, wherein the computer readable storage medium further stores program instructions that cause the computing system to:

receive an indication by the user that the new event corresponds with the second graph; and

update the user interface data such that a first mark is displayed in the second graph at the time that corresponds with the fourth data point.

9. The computing system of claim 6, wherein the computer readable storage medium further stores program instructions that cause the computing system to:

receive an indication by the user that the new event corresponds with the first graph and the second graph; and

update the user interface data such that a first mark is displayed in the first graph at the time that corresponds with the fourth data point and a second mark is displayed in the second graph at the time that corresponds with the fourth data point.

10. The computing system of claim 3, wherein the computer readable storage medium further stores program instructions that cause the computing system to:

receive an indication of selection by the user of a first event in the list of events; and

update the user interface data such that the first graph includes an icon at a position of a data point in the first graph that corresponds with the first event.

11. The computing system of claim 1, wherein the computer readable storage medium further stores program instructions that cause the computing system to:

receive an indication of selection, by the user, of a first location corresponding to the first time range in the first graph; and

update the user interface data such that the first graph includes a fourth marker at the first location in the first graph corresponding to the first time range.

12. The computing system of claim 11, wherein the computer readable storage medium further stores program instructions that cause the computing system to update the user interface data such that the second graph includes a fifth marker at a second location in the second graph corresponding to the first time range.

13. The computing system of claim 12, wherein the computer readable storage medium further stores program instructions that cause the computing system to:

receive an indication of selection, by the user of a third location corresponding to a second time in the first graph; and

update the user interface data such that the first graph includes the fourth marker at the third location in the first graph corresponding to the second time.

14. The computing system of claim 13, wherein the computer readable storage medium further stores program instructions that cause the computing system to update the user interface data such that the second graph includes the fifth marker at a location in the second graph corresponding to the second time.

15. The computing system of claim 1, wherein the first data point comprises a line from a location in the first graph that corresponds with a highest value measured by the first sensor during the first time range to a location in the first graph that corresponds with a lowest value measured by the first sensor during the first time range.

16. The computing system of claim 1, wherein the computer readable storage medium further stores program instructions that cause the computing system to receive an indication that a zoom level of the first graph is adjusted from a first zoom level to a second zoom level.

17. The computing system of claim 16, wherein the computer readable storage medium further stores program instructions that cause the computing system to retrieve, from a cache, for a second time range that corresponds to a first pixel in an x-axis of the first graph, a highest value measured by the first sensor during the second time range and a lowest value measured by the first sensor during the second time range.

18. The computing system of claim 17, wherein the computer readable storage medium further stores program instructions that cause the computing system to update the user interface data such that the first graph includes a line from a location in the first graph that corresponds with the highest value to a location in the first graph that corresponds with the lowest value.

19. The computing system of claim 1, wherein the first sensor and the second sensor are oil well sensors.

20. The computing system of claim 19, wherein the first sensor values correspond to oil extracted from an oil well, and wherein the second sensor values correspond to water extracted from the oil well.