DATA SAMPLING METHOD FOR DETERMINING SALIENT VALUES IN A LARGE DATA STREAM

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

• Current Assignee: Air Liquide Electronics US LP (Air Liquide SA), Air Liquide Large Industries U S LP (L'Air Liquide SA)
• Original Assignee: Air Liquide Electronics US LP (Air Liquide SA)
• Inventors: MUKHI, Sultan Q., MOMIN, Emitaz A., MOMIN, Mehrab
• Granted Patent: US 9,372,603 B2
• Time in Patent Office: Days
• US Class Current: 715/771
• CPC Class Codes: G05B 19/4185 characterised by the network communication
• CPC Class Codes: G05B 2219/32128 Gui graphical user interface
• CPC Class Codes: G05B 23/0216 Human interface functionality, e.g. monitoring system providing help to the user in the selection of tests or in its configuration
• CPC Class Codes: G05B 23/0221 Preprocessing measurements, e.g. data collection rate adjustment; Standardization of measurements; Time series or signal analysis, e.g. frequency analysis or wavelets; Trustworthiness of measurements; Indexes therefor; Measurements using easily measured parameters to estimate parameters difficult to measure; Virtual sensor creation; De-noising; Sensor fusion; Unconventional preprocessing inherently present in specific fault detection methods like PCA-based methods
• CPC Class Codes: G06F 3/0484 for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
• CPC Class Codes: Y02P 90/02 Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]

Abstract

Techniques are disclosed for presenting users with relevant data and statistics related to the operations of an industrial system. Data obtained by a SCADA system may be stored in a real-time status database (which reflects the current process data of the industrial system) and a historian database (which archives the process data from the industrial system as it changes over time). A user may request from the SCADA system process data obtained during a specified period of time. The request may be subdivided into a plurality of time intervals, and process data associated with each time interval may be analyzed to determine one or more salient values that are representative of the interval. The salient values associated with each time interval then may be transmitted to the user in response to the process data request.

Claims

1. A method for fulfilling a request for process data related to the operations of a system comprising:

receiving, from an application program executing on a client computing system, a first selected interval granularity and a request for process data associated with a first time period;

dividing the first time period into a first plurality of intervals based on the first selected interval granularity;

for each interval in the first plurality of intervals, analyzing the process data of the monitored system to determine salient values, the salient values comprising an initial value, a maximum value, a minimum value, and any local extrema of the process data of the monitored system; and

transmitting the salient values associated with the first plurality of intervals to the application program, wherein the application program is configured to render a graph of the process data according to the first selected interval granularity, wherein the graph preserves the salient values irrespective of the selected interval granularity.

2. The method of claim 1, further comprising:

receiving, from the application program, a second selected interval granularity; and

responsive to the second selected interval granularity;

dividing the first time period into a second plurality of intervals based on the second selected interval granularity, wherein the second plurality of intervals are different than the first plurality of intervals;

for each interval in the second plurality of intervals, analyzing the process data of the monitored system to determine the salient values; and

transmitting the salient values associated with the second plurality of intervals to the application program, wherein the application program is configured to render a graph of the process data according to the second selected interval granularity while preserving the salient values.

3. The method of claim 1, further comprising:

receiving, from the application program, a request for process data of the monitored system acquired during a second time period; and

responsive to the request;

dividing the second time period into a second plurality of intervals based on the first selected interval granularity;

for each interval in the second plurality of intervals, analyzing the process data to determine the salient values; and

transmitting the salient values associated with the second plurality of intervals to the application program, wherein the application program is configured to render a graph of the process data according to the first selected interval granularity while preserving the salient values.

4. The method of claim 1, further comprising reordering the initial value, maximum value, minimum value, and any local extrema associated with each interval prior to transmitting each initial value, maximum value, minimum value, and any local extrema to the application program.

5. The method of claim 1, further comprising:

determining that the salient values associated with at least two consecutive intervals in the first plurality of intervals are substantially the same; and

based on the determination, consolidating one or more salient values associated with the at least two consecutive intervals prior to transmitting the salient values to the application program.

6. The method of claim 5, wherein the consolidating comprises removing one or more salient values associated with the at least two consecutive intervals.

7. The method of claim 5, wherein the consolidating comprises removing one or more salient values associated with the at least two consecutive intervals.

8. A non-transitory computer-readable storage medium including instructions that, when executed by a processing unit, cause the processing unit to fulfill a request for process data related to the operations of a system, by performing the steps of:

receiving, from an application program executing on a client computing system, a first selected interval granularity and a request for process data associated with a first time period;

dividing the first time period into a first plurality of intervals based on the first selected interval granularity;

for each interval in the first plurality of intervals, analyzing the process data of the monitored system to determine salient values, the salient values comprising an initial value, a maximum value, a minimum value, and any local extrema of the process data of the monitored system; and

transmitting the salient values associated with the first plurality of intervals to the application program, wherein the application program is configured to render a graph of the process data according to the first selected interval granularity, wherein the graph preserves the salient values irrespective of the selected interval granularity.

9. The non-transitory computer-readable storage medium of claim 8, further comprising:

receiving, from the application program, a second selected interval granularity; and

responsive to the second selected interval granularity;

dividing the first time period into a second plurality of intervals based on the second selected interval granularity, wherein the second plurality of intervals are different than the first plurality of intervals;

for each interval in the second plurality of intervals, analyzing the process data of the monitored system to determine the salient values; and

transmitting the salient values associated with the second plurality of intervals to the application program, wherein the application program is configured to render a graph of the process data according to the second selected interval granularity while preserving the salient values.

10. The non-transitory computer-readable storage medium of claim 8, further comprising:

receiving, from the application program, a request for process data of the monitored system acquired during a second time period; and

responsive to the request;

dividing the second time period into a second plurality of intervals based on the first selected interval granularity;

for each interval in the second plurality of intervals, analyzing the process data to determine the salient values; and

transmitting the salient values associated with the second plurality of intervals to the application program, wherein the application program is configured to render a graph of the process data according to the first selected interval granularity while preserving the salient values.

11. The non-transitory computer-readable storage medium of claim 8, further comprising reordering the initial value, maximum value, minimum value, and any local extrema associated with each interval prior to transmitting each initial value, maximum value, minimum value, and any local extrema to the application program.

12. The non-transitory computer-readable storage medium of claim 8, further comprising:

determining that the salient values associated with at least two consecutive intervals in the first plurality of intervals are substantially the same; and

based on the determination, consolidating one or more salient values associated with the at least two consecutive intervals prior to transmitting the salient values to the application program.

13. The method of claim 12, wherein the consolidating comprises removing one or more salient values associated with the at least two consecutive intervals.

14. The method of claim 12, wherein the consolidating comprises removing one or more salient values associated with the at least two consecutive intervals.

15. A computing device, comprising:

a memory; and

a central processing unit coupled to the memory, configured to;

receive, from an application program executing on a client computing system, a first selected interval granularity and a request for process data associated with a first time period;

divide the first time period into a first plurality of intervals based on the first selected interval granularity;

for each interval in the first plurality of intervals, analyze the process data of the monitored system to determine salient values, the salient values comprising an initial value, a maximum value, a minimum value, and any local extrema of the process data of the monitored system; and

transmit the salient values associated with the first plurality of intervals to the application program, wherein the application program is configured to render a graph of the process data according to the first selected interval granularity, wherein the graph preserves the salient values irrespective of the selected interval granularity.

16. The computing device of claim 15, wherein the central processing unit is further configured to:

receive, from the application program, a second selected interval granularity; and

responsive to the second selected interval granularity;

divide the first time period into a second plurality of intervals based on the second selected interval granularity, wherein the second plurality of intervals are different than the first plurality of intervals;

for each interval in the second plurality of intervals, analyze the process data of the monitored system to determine the salient values; and

transmit the salient values associated with the second plurality of intervals to the application program, wherein the application program is configured to render a graph of the process data according to the second selected interval granularity while preserving the salient values.

17. The computing device of claim 15, wherein the central processing unit is further configured to:

receive, from the application program, a request for process data of the monitored system acquired during a second time period; and

responsive to the request;

divide the second time period into a second plurality of intervals based on the first selected interval granularity;

for each interval in the second plurality of intervals, analyze the process data to determine the salient values; and

transmit the salient values associated with the second plurality of intervals to the application program, wherein the application program is configured to render a graph of the process data according to the first selected interval granularity while preserving the salient values.

18. The computing device of claim 15, wherein the central processing unit is further configured to reorder the initial value, maximum value, minimum value, and any local extrema associated with each interval prior to transmitting each initial value, maximum value, minimum value, and any local extrema to the application program.

19. The computing device of claim 15, wherein the central processing unit is further configured to:

determine that the salient values associated with at least two consecutive intervals in the first plurality of intervals are substantially the same; and

based on the determination, consolidate one or more salient values associated with the at least two consecutive intervals prior to transmitting the salient values to the application program.

20. The computing device of claim 19, wherein the consolidating comprises removing one or more salient values associated with the at least two consecutive intervals.