Systems for collecting, aggregating, and storing data, generating interactive user interfaces for analyzing data, and generating alerts based upon collected data

• US 9,792,020 B1
• Filed: 05/04/2016
• Issued: 10/17/2017
• Est. Priority Date: 12/30/2015
• Status: Active Grant

• Current Assignee: Palantir Technologies Incorporated
• Original Assignee: Palantir Technologies Incorporated
• Inventors: Kelley, Sean, Scott, Dylan, Sood, Ayush, Verdieck, Kevin, Baker, Izaak, Ball, Eliot, Bush, Zachary, Cai, Allen, Chen, Jerry, Dahiya, Aditya, Deutsch, Daniel, Fernandez, Calvin, Hong, Jonathan, Hu, Jiaji, Kuan, Audrey, Lemanowicz, Lucas, Minor, Clark, Miyake, Nicholas, Nazario, Michael, Ngo, Brian, Proniushkin, Mikhail, Rajgarhia, Siddharth, Rodgers, Christopher, Teramoto, Kayo, Tobin, David, Wang, Grace, Wong, Wilson, Xu, Holly, Zhang, Xiaohan
• Primary Examiner(s): Dang, Thanh-Ha
• Application Number:
  US15/146,754
• Time in Patent Office: 531 Days
• Field of Search: 707723
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06Q 10/06313 Resource planning in a project environment
• CPC Class Codes: G06Q 10/0633 Workflow analysis
• CPC Class Codes: G06Q 10/0639 Performance analysis of employees; Performance analysis of enterprise or organisation operations
• CPC Class Codes: G06T 11/206 Drawing of charts or graphs

Abstract

Systems and methods for aggregating and storing different types of data, and generating interactive user interfaces for analyzing the stored data. In some embodiments, entity data is received for a plurality of entities from one or more data sources, and used to determine attribute values for the entities for one or more given time periods. The plurality of entities may be categorized into one or more entity groups, and aggregate attribute values may be generated based upon the entity groups. A first interactive user interface is generated displaying the one or more entity groups in association with the aggregated attribute values associated with the entity group. In response to a received indication of a user selection of an entity group, a second interactive user interface is generated displaying the one or more entities associated with the selected entity group, each entity displayed in association with the attribute values associated with the entity.

Claims

1. A computer system for collecting, aggregating and storing entity data, and generating interactive user interfaces for analyzing entity data, the system comprising:

a computer processor;

one or more databases storing data corresponding to a plurality of entities, each entity of the plurality of entities corresponding to a physical asset and associated with one or more sensors configured to generate a plurality of sensed entity data values over time; and

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

for each entity of the plurality of entities;

receive sensed entity data from the one or more sensors associated with the entity, the sensed entity data comprising a plurality of sensed entity data values measured over time; and

using the received sensed entity data values, determine one or more attribute values for the entity for a given time period;

categorize the plurality of entities into a plurality of entity groups;

for each entity group of the plurality of entity groups, aggregate the attribute values of the one or more entities associated with the entity group to determine one or more aggregate attribute values for the entity group for the given time period;

generate a first interactive user interface displaying the plurality of entity groups in association with at least a portion of the aggregate attribute values associated with the entity group over the given time period; and

in response to a received indication of a user selection of an entity group of the plurality of entity groups, generate a second interactive user interface, the second interactive user interface displaying the one or more entities associated with the selected entity group, each entity of the one or more entities displayed in association with at least a portion of the attribute values associated with the entity over the given time period, wherein the at least a portion of the attribute values correspond to the attribute values used to determine the at least a portion of the aggregate attribute values associated with the entity group.

2. The computer system of claim 1, wherein the one or more attribute values comprise at least an operational status and a production value.

3. The computer system of claim 1, wherein the first interactive user interface further comprises, for each displayed aggregate attribute value, a graph illustrating values of the aggregate attribute value over multiple previous time periods.

4. The computer system of claim 1, wherein the first interactive user interface further comprises, for each displayed aggregate attribute value, a change value indicating a change in the aggregate attribute value from a previous time period.

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

retrieve, from the one or more databases, job data corresponding to a plurality of jobs, each job being associated with at least one entity of the one or more entities associated with the selected entity group, a job time, and a job cost;

retrieve, from the one or more databases, production data comprising production values determined over time associated with the one or more entities;

associate each job with a cumulative cost, the cumulative cost indicating a total cost of jobs associated with entities of the selected entity group to the job time of the job;

associate each job with a production value, based at least in part upon the job time; and

generate a chart plotting cumulative costs against production values for the plurality of jobs.

6. The computer system of claim 5, wherein each job is associated with a production value change, based upon a first production value associated with a first time and a second production value associated with a second time, the first time occurred before the job time associated with the job, and the second time occurring after the job time.

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

in response to an entity being in a non-operational status, flag the entity for review by the user, wherein the entity is associated with a reason for non-operation;

in response to a received indication that the user has reviewed the entity, unflag the entity; and

re-flag the entity for review by the user, in response to a detection that a designated period of time has passed since the user has previously reviewed the entity, or in response to detection of a change in a condition associated with the reason for non-operation, wherein the detected change is inconsistent with the reason for non-operation.

8. The computer system of claim 7, wherein the designated period of time is based at least in part upon an attribute value or job status associated with the reason for non-operation.

9. The computer system of claim 7, wherein the condition is associated with an attribute value of the entity, and wherein the detected change corresponds to a detection that the attribute value is not within an undesired value range.

10. The computer system of claim 7, wherein the condition is associated with a job status, and wherein the detected change corresponds to a change of the job status.

11. A method for collecting, aggregating and storing sensed entity data, and generating interactive user interfaces for analyzing sensed entity data, comprising:

for each entity of a plurality of entities stored in one or more databases, wherein each entity of the plurality of entities corresponds to a physical structure asset and is associated with one or more sensors configured to generate a plurality of sensed entity data values over time;

receiving sensed entity data from the one or more sensors associated with the entity, the sensed entity data entity data comprising a plurality of sensed entity data values measured over time;

using the received sensed entity data values, determining one or more attribute values for the entity for a given time period;

categorizing the plurality of entities into a plurality of entity groups;

for each entity group of the plurality of entity groups, aggregating the attribute values of the one or more entities associated with the entity group to determine one or more aggregate attribute values for the entity group for the given time period;

generating a first interactive user interface displaying the plurality of entity groups in association with at least a portion of the aggregate attribute values associated with the entity group over the given time period; and

in response to a received indication of a user selection of an entity group of the plurality of entity groups, generating a second interactive user interface, the second interactive user interface displaying the one or more entities associated with the selected entity group, each entity of the one or more entities displayed in association with at least a portion of the attribute values associated with the entity over the given time period, wherein the at least a portion of the attribute values correspond to the attribute values used to determine the at least a portion of the aggregate attribute values associated with the entity group.

12. The method of claim 11, wherein the one or more attribute values comprise at least an operational status and a production value.

13. The method of claim 11, wherein the first interactive user interface further comprises, for each displayed aggregate attribute value, a graph illustrating values of the aggregate attribute value over multiple previous time periods.

14. The method of claim 11, wherein the first interactive user interface further comprises, for each displayed aggregate attribute value, a change value indicating a change in the aggregate attribute value from a previous time period.

15. The method of claim 11, wherein the method further comprises:

retrieving, from the one or more databases, job data corresponding to a plurality of jobs, each job being associated with at least one entity of the one or more entities associated with the selected entity group, a job time, and a job cost;

retrieving, from the one or more databases, production data comprising production values determined over time associated with the one or more entities;

associating each job with a cumulative cost, the cumulative cost indicating a total cost of jobs associated with entities of the selected entity group to the job time of the job;

associating each job with a production value, based at least in part upon the job time; and

generating a chart plotting cumulative costs against production values for the plurality of jobs.

16. The method of claim 15, wherein each job is associated with a production value change, based upon a first production value associated with a first time and a second production value associated with a second time, the first time occurred before the job time associated with the job, and the second time occurring after the job time.

17. The method of claim 11, further comprising:

in response to an entity being in a non-operational status, flagging the entity for review by the user, wherein the entity is associated with a reason for non-operation;

in response to a received indication that the user has reviewed the entity, unflagging the entity; and

re-flagging the entity for review by the user, in response to a detection that a designated period of time has passed since the user has previously reviewed the entity, or in response to detection of a change in a condition associated with the reason for non-operation, wherein the detected change is inconsistent with the reason for non-operation.

18. The method of claim 17, wherein the designated period of time is based at least in part upon an attribute value or job status associated with the reason for non-operation.

19. The method of claim 17, wherein the condition is associated with an attribute value of the entity, and wherein the detected change corresponds to a detection that the attribute value is not within an undesired value range.

20. The method of claim 17, wherein the condition is associated with a job status, and wherein the detected change corresponds to a change of the job status.

21. A non-transitory computer readable storage device having instructions stored thereon for execution by a computing system to perform:

for each entity of a plurality of entities stored in one or more databases, wherein each entity of the plurality of entities corresponds to a physical asset and is associated with one or more sensors configured to generate a plurality of sensed entity data values over time;

receiving sensed entity data from the one or more sensors associated with the entity, the sensed entity data entity data comprising a plurality of sensed entity data values measured over time;

using the received sensed entity data values, determining one or more attribute values for the entity for a given time period;

categorizing the plurality of entities into a plurality of entity groups;

for each entity group of the plurality of entity groups, aggregating the attribute values of the one or more entities associated with the entity group to determine one or more aggregate attribute values for the entity group for the given time period;

generating a first interactive user interface displaying the plurality of entity groups in association with at least a portion of the aggregate attribute values associated with the entity group over the given time period; and

in response to a received indication of a user selection of an entity group of the plurality of entity groups, generating a second interactive user interface, the second interactive user interface displaying the one or more entities associated with the selected entity group, each entity of the one or more entities displayed in association with at least a portion of the attribute values associated with the entity over the given time period, wherein the at least a portion of the attribute values correspond to the attribute values used to determine the at least a portion of the aggregate attribute values associated with the entity group.