SYSTEM AND METHOD FOR COMPARING AND VISUALIZING DATA ENTITIES AND DATA ENTITY SERIES

• US 20160275122A1
• Filed: 07/30/2015
• Published: 09/22/2016
• Est. Priority Date: 03/19/2015
• Status: Active Grant

• Current Assignee: Palantir Technologies Incorporated
• Original Assignee: Palantir Technologies Incorporated
• Inventors: Rahill-Marier, Bianca, Iadevaia, Vincent, Bunge, Breanna, Ryan, Alexander, Schaffer, Simone, Imamoglu, Cihat, Kara, Feridun Arda, Lee, Brian
• Granted Patent: US 9,886,467 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2291 User-Defined Types; Storage management thereof
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/285 Clustering or classification

Abstract

Systems and methods for creating and using a workflow template for analyzing data entities stored in the one or more databases. After a desired workflow is identified, one or more series, data source, and/or entity restrictions based upon the workflow may be received. In addition, one or more chart configuration settings based upon the workflow may also be received. The restrictions and configuration settings may be saved as the workflow template. The workflow may then be performed by loading the saved workflow template, in order to automatically generate charts in accordance with the configuration settings of the template, based upon a received selection of series, data sources, and entities that adheres to the restrictions defined in the template.

Claims

1. A computing system configured to access one or more databases to create and use a workflow template for analyzing data entities, the computing system comprising:

a computer processor; and

one or more databases storing data corresponding to a plurality of entities, the plurality of entities being associated with a plurality of data sources and a plurality of series, wherein a series corresponds to values of an attribute of an entity that can be measured over time using one or more sensors or modeled using one or more models;

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

create a template for a workflow usable to guide other users in generatin one or more charts based upon series values corresponding to one or more entities, wherein creating the template comprises;

receiving, from a first user of the computing system, a plurality of criteria indicating one or more series restrictions, data source restrictions, and entity restrictions to be associated with the workflow, wherein a data source is used to determine values of a series for an entity, and wherein the one or more restrictions specify a number or type of series, data sources, and entities that may be selected during performance of the workflow;

receiving, from the first user, one or more chart configuration settings to be associated with the workflow, wherein the one or more chart configuration settings specify a type of chart to be created during performance of the workflow; and

saving the template including the plurality of criteria and the chart configuration settings;

perform the workflow using the template, wherein performing the workflow comprises;

loading the saved template;

based upon the saved template, generating an interactive user interface comprising user interface elements allowing a second user of the computing system to select one or more series, data sources, and entities, wherein a number of series, data sources, and entities that can be selected by the second user is restricted based upon the plurality of criteria of the template;

via the interactive user interface, receiving selection of one or more series in accordance with the plurality of criteria of the template;

via the interactive user interface, receiving selection of one or more data sources in accordance with the plurality criteria of the template;

via the interactive user interface, receiving selection of one or more entities in accordance with the plurality criteria of the template;

using the selected one or more data sources, retrieving values of the selected one or more series corresponding to the selected one or more entities, the retrieved values corresponding to one or more measured sensor values or one or more modelled values; and

generating and displaying to the second user one or more charts indicated in the chart configuration settings of the template, based upon the retrieved series values.

2. The computing system of claim 1, wherein the plurality of data entities correspond to a plurality of geological structures.

3. The computing system of claim 1, wherein a series of the one or more series corresponds to a time-based attribute, and wherein a chart of the one or more charts is a time series chart.

4. The computing system of claim 1, wherein the one or more data sources comprises a historical data source containing values of a series measured over time using one or more sensors.

5. The computing system of claim 1, wherein the one or more data sources comprises a model data source containing values of a series modelled using one or more models.

6. The computing system of claim 5, wherein the model data source is constructed based at least in part upon a historical data source.

7. The computing system of claim 1, wherein the one or more data entities are selected based at least in part upon similarity to a selected baseline entity.

8. The computing system of claim 7, wherein a similarity of a data entity to the baseline entity is determined based at least in part upon a calculated similarity score, the similarity score being calculated as a weighted average.

9. The computing system of claim 1, wherein the plurality of criteria indicate one or more restrictions on a number of series, data sources, and entities that can be received.

10. The computing system of claim 1, wherein:

the plurality of criteria of the template indicate a number of series to be received restricted to one, a number of data sources to be received restricted to two, and a number of entities to be received restricted to one; and

wherein the one or more charts indicated in the chart configuration settings comprises a chart that plots a difference between first data source series values and corresponding second data source series values.

11. A computer-implemented method for accessing one or more databases in to create and use a workflow template for analyzing data entities, comprising:

creating a template for a workflow usable to guide other users in generating one or more charts based upon series values corresponding to one or more entities, wherein a series corresponds to values of an attribute of an entity that can be measured over time using one or more sensors or modeled using one or more models, and wherein creating the template comprises;

receiving, from a first user, a plurality of criteria indicating one or more series restrictions, data source restrictions, and entity restrictions to be associated with the workflow, wherein a data source is used to determine values of a series for an entity, and wherein the one or more restrictions specify a number or type of series, data sources, and entities that may be selected during performance of the workflow;

receiving, from the first user, one or more chart configuration settings to be associated with the workflow, wherein the one or more chart configuration settings specify a type of chart to be created during performance of the workflow; and

saving the template including the plurality of criteria and the chart configuration settings;

performing the workflow using the template, wherein performing the workflow comprises;

loading the saved template;

based upon the saved template, generating an interactive user interface comprising user interface elements allowing a second user to select one or more series, data sources, and entities, wherein a number of series, data sources, and entities that can be selected by the second user is restricted based upon the plurality of criteria of the template;

via the interactive user interface, receiving selection of one or more series in accordance with the plurality of criteria of the template;

via the interactive user interface, receiving selection of one or more data sources in accordance with the plurality criteria of the template;

via the interactive user interface, receiving selection of one or more data entities in accordance with the plurality criteria of the template;

using the selected one or more data sources, retrieving values of the selected one or more series corresponding to the selected one or more entities, the retrieved values corresponding to one or more measured sensor values or one or more modelled values; and

generating and displaying to the second user one or more charts indicated in the chart configuration settings of the template, based upon the retrieved series values.

12. The computer-implemented method of claim 11, wherein the plurality of data entities correspond to a plurality of geological structures.

13. The computer-implemented method of claim 11, wherein a series of the one or more series corresponds to a time-based attribute, and wherein a chart of the one or more charts is a time series chart.

14. The computer-implemented method of claim 11, wherein the one or more data sources comprises a historical data source containing values of a series measured over time using one or more sensors.

15. The computer-implemented method of claim 11, wherein the one or more data sources comprises a model data source containing values of a series modelled using one or more models.

16. The computer-implemented method of claim 15, wherein the model data source is constructed based at least in part upon a historical data source.

17. The computer-implemented method of claim 11, wherein the one or more data entities are selected based at least in part upon similarity to a selected baseline entity.

18. The computer-implemented method of claim 17, wherein a similarity of a data entity to the baseline entity is determined based at least in part upon a calculated similarity score, the similarity score being calculated as a weighted average.

19. The computer-implemented method of claim 11, wherein the plurality of criteria indicate one or more restrictions on a number of series, data sources, and entities that can be received.

20. The computer-implemented method of claim 11, wherein:

the plurality of criteria of the template indicate a number of series to be received restricted to one, a number of data sources to be received restricted to two, and a number of entities to be received restricted to one; and

wherein the one or more charts indicated in the chart configuration settings comprises a chart that plots a difference between first data source series values and corresponding second data source series values.

21. A system comprising:

a first one or more sensors associated with a first oil or gas well, the first one or more sensors configured to measure a first plurality of sensor values obtained over time of attributes associated with the first well, the measured attributes including one or more of temperature, volume, pressure, flow rate, or composition of a fluid;

one or more data sources storing sensor values of a plurality of time series associated with a plurality of attributes of a plurality of wells, wherein each of at least some of the plurality of time series includes a plurality of sensor values, measured at different times, of a particular attribute of a particular well, the one or more data sources including at least a first data source storing a first time series including the first plurality of sensor values obtained from the first one or more sensors associated with the first well;

a computing system having one or more hardware computer processors and a computer readable storage medium storing program instructions configured for execution by the one or more hardware computer processors to cause the computing system to;

create a template for a workflow usable to guide other users in generating one or more charts based upon one or more time series associated with one or more wells, wherein creating the template comprises;

receiving, from a first user of the computing system, a plurality of criteria to be associated with the workflow, the plurality of criteria including;

one or more attribute restrictions indicating a quantity of attributes and/or type of attribute selectable during performance of the workflow;

one or more data source restrictions indicating a quantity of data sources and/or type of data source selectable during performance of the workflow; and

one or more well restrictions indicating a quantity of wells and/or type of wells selectable during performance of the workflow;

receiving, from the first user, chart configuration settings to be associated with the workflow, the chart configuration settings specifying a type of chart to be created during performance of the workflow; and

saving the template including the plurality of criteria and the chart configuration settings;

perform the workflow using the template, wherein performing the workflow comprises;

receiving a request, from a second user of the computing system, for performance of the workflow associated with the template;

loading the saved template;

based upon the saved template, generating an interactive user interface including user interface elements restricting a quantity of attributes, data sources, and wells selectable by the second user in accordance with the attribute restrictions, data source restrictions, and well restrictions, respectively;

via the interactive user interface, receiving selection of one or more particular wells for which time series are to be included in one or more charts associated with the workflow, wherein the interactive user interface limits selection of the one or more particular wells to the quantity of wells indicated in the well restrictions of the template, wherein the one or more particular wells includes the first well;

via the interactive user interface, receiving selection of one or more particular attributes of the one or more particular wells to include in one or more charts associated with the workflow, wherein the interactive user interface limits selection of the one or more particular attributes to the quantity of attributes indicated in the attribute restrictions of the template;

via the interactive user interface, receiving selection of one or more particular data sources from which time series of at least one of the particular attributes of at least one of the particular wells is accessible, wherein the interactive user interface limits selection of the one or more particular data sources to the quantity of data sources indicated in the data source restrictions of the template;

accessing time series of the particular attributes of the particular wells from the particular data sources; and

generating and displaying the accessed time series in one or more charts configured according to the chart configuration settings of the template.

22. The computing system of claim 21, wherein each of at least a second portion of the plurality of time series comprises a plurality of model values of a particular attribute of a particular well, the model values being determined using one or more constructed models.

23. The computing system of claim 22, wherein the one or more data sources includes at least a second data source storing a second time series including values associated with the first attribute, the values being obtained using a first model associated with the first well.

24. The computing system of claim 23, wherein the first model is constructed based at least in part upon the first plurality of sensor values obtained from the first one or more sensors associated with the first well.

25. A system comprising:

one or more data sources storing data for a plurality of time series associated with a plurality of attributes of a plurality of oil or gas wells, wherein each of at least some of the plurality of time series includes a plurality of sensor values, measured at different times, of a particular attribute of a particular well, the one or more data sources including at least a first data source storing a first time series including a first plurality of sensor values obtained from a first one or more sensors associated with a first well, the first one or more sensors configured to measure the first plurality of sensor values of attributes associated with the first well over time, the measured attributes including one or more of temperature, volume, pressure, flow rate, or composition of a fluid;

a computing system having one or more hardware computer processors and a computer readable storage medium storing program instructions configured for execution by the one or more hardware computer processors to cause the computing system to;

create a template for a workflow usable to guide other users in generating one or more charts based upon one or more time series associated with one or more wells, wherein creating the template comprises;

receiving, from a first user of the computing system, a plurality of criteria to be associated with the workflow, the plurality of criteria including;

one or more attribute restrictions indicating a quantity of attributes and/or type of attribute selectable during performance of the workflow;

one or more data source restrictions indicating a quantity of data sources and/or type of data source selectable during performance of the workflow; and

one or more well restrictions indicating a quantity of wells and/or type of wells selectable during performance of the workflow;

receiving, from the first user, chart configuration settings to be associated with the workflow, the chart configuration settings specifying a type of chart to be created during performance of the workflow; and

saving the template including the plurality of criteria and the chart configuration settings;

perform the workflow using the template, wherein performing the workflow comprises;

receiving a request, from a second user of the computing system, for performance of the workflow associated with the template;

loading the saved template;

based upon the saved template, generating an interactive user interface including user interface elements restricting a quantity of attributes, data sources, and wells selectable by the second user in accordance with the attribute restrictions, data source restrictions, and well restrictions, respectively;

via the interactive user interface, receiving selection of one or more particular wells for which time series are to be included in one or more charts associated with the workflow, wherein the interactive user interface limits selection of the one or more particular wells to the quantity of wells indicated in the well restrictions of the template, wherein the one or more particular wells includes the first well;

via the interactive user interface, receiving selection of one or more particular attributes of the one or more particular wells to include in one or more charts associated with the workflow, wherein the interactive user interface limits selection of the one or more particular attributes to the quantity of attributes indicated in the attribute restrictions of the template;

via the interactive user interface, receiving selection of one or more particular data sources from which time series of at least one of the particular attributes of at least one of the particular wells is accessible, wherein the interactive user interface limits selection of the one or more particular data sources to the quantity of data sources indicated in the data source restrictions of the template;

accessing time series of the particular attributes of the particular wells from the particular data sources; and

generating and displaying the accessed time series in one or more charts configured according to the chart configuration settings of the template.

26. The computing system of claim 25, wherein each of at least a second portion of the plurality of time series comprises a plurality of model values of a particular attribute of a particular well, the model values being determined using one or more constructed models.

27. The computing system of claim 26, wherein the one or more data sources includes at least a second data source storing a second time series including values associated with the first attribute, the values being obtained using a first model associated with the first well.

28. The computing system of claim 27, wherein the first model is constructed based at least in part upon the first plurality of sensor values obtained from the first one or more sensors associated with the first well.