Storage of multiple, related time-series data streams

• US 8,260,783 B2
• Filed: 02/25/2008
• Issued: 09/04/2012
• Est. Priority Date: 02/27/2007
• Status: Active Grant

• Current Assignee: Siemens AG
• Original Assignee: Siemens AG
• Inventors: Milam, Christopher Patrick
• Primary Examiner(s): COLAN, GIOVANNA B
• Application Number:
  US12/036,676
• Publication Number:
  US 20080208890A1
• Time in Patent Office: 1,653 Days
• Field of Search: 707/999.01, 707/741, 707/790, 707/821, 709/204, 369/47.1, 702/45, 702/50, 702/85, 702/108
• US Class Current: 707/741
• CPC Class Codes: G05B 19/4183 characterised by data acquisition, e.g. workpiece identification
• CPC Class Codes: G05B 23/0264 Control of logging system, e.g. decision on which data to store; time-stamping measurements
• CPC Class Codes: Y02P 90/02 Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]

Abstract

A method and system may receive time-series data of each of a plurality of real-time data streams from one or more sensors and create an electronic file based on the plurality of real-time data streams. The plurality of real-time data streams comprises a primary data stream, a low limit data stream, a high limit data stream, and a target value data stream. The electronic file includes a data portion and a metadata portion. The metadata portion of the electronic file comprises, for each of the plurality of data streams, one or more data stream identifiers, a time range, a source type, and a data type, and the data portion comprises the time-series data of each of the plurality of real-time data streams.

Claims

1. A method comprising:

receiving time-series data of each of a plurality of real-time data streams from one or more sensors, the plurality of real-time data streams comprising a primary data stream representing a measured value, a low limit data stream representing a low limit of the measured value, a high limit data stream representing a high limit of the measured value, and a target value data stream representing a target value of the measured value, wherein the time-series data of the primary data stream includes a plurality of time stamps and a plurality of data values that are separate from the plurality of time stamps, each of the plurality of data values of the primary data stream being associated with a respective one of the plurality of time stamps and representing the measured value, wherein the time-series data of the low limit data stream includes a plurality of data values that are separate from the plurality of time stamps and the plurality of data values of the primary data stream, each of the plurality of data values of the low limit data stream being associated with a respective one of the plurality of time stamps and representing a low limit of the measured value, wherein the time-series data of the high limit data stream includes a plurality of data values that are separate from the plurality of time stamps, the plurality of data values of the primary data stream and the plurality of data values of the low limit data stream, each of the plurality of data values of the high limit data stream being associated with a respective one of the plurality of time stamps and representing a high limit of the measured value, and wherein the time-series data of the target value data stream includes a plurality of data values that are separate from the plurality of time stamps, the plurality of data values of the primary data stream, the plurality of data values of the low limit data stream and the plurality of data values of the high limit data stream, each of the plurality of data values of the target value data stream being associated with a respective one of the plurality of time stamps and representing a target value of the measured value; and

creating an electronic file based on the plurality of real-time data streams, the electronic file including a data portion and a metadata portion,

wherein the metadata portion of the electronic file comprises, for each of the plurality of data streams, one or more data stream identifiers, a time range, a source type, and a data type, and

wherein the data portion comprises the time-series data of each of the plurality of real-time data streams.

2. The method of claim 1, wherein the metadata portion comprises an annotation locator index.

3. The method of claim 2, wherein the annotation locator index is associated with one or more annotations, each annotation associated with a time stamp.

4. The method of claim 1, wherein the data portion further comprises a plurality of quality levels, and wherein each quality level is associated with a time stamp and one of the plurality of received data streams.

5. The method of claim 1, further comprising:

transferring the electronic file from a first apparatus to a second apparatus, wherein the real-time measured data streams are received at the first apparatus.

6. The method of claim 1, further comprising:

displaying annotations; and

graphing the plurality of real-time data streams based on the metadata portion.

7. The method of claim 1, wherein the data portion further comprises one or more alarm indicators.

8. The method of claim 1, wherein the data portion further comprises a plurality of ascending high limit streams and a plurality of descending low limit streams.

21. The method of claim 1, wherein one of the plurality of data values of the primary data stream, one of the plurality of data values of the low limit data stream, one of the plurality of data values of the high limit data stream and one of the plurality of data values of the target value data stream are each associated with a particular one of the plurality of time stamps and are recorded at a time represented by the particular one of the plurality of time stamps.

24. The method of claim 1, wherein the primary data stream is a data stream representing a measured value of a pump flow rate, a fluid level or a level of viscosity.

27. The method of claim 21, wherein the primary data stream is a data stream representing a measured value of a pump flow rate, a fluid level or a level of viscosity.

9. A medium storing processor-executable instructions that when executed by a processor perform a method, the method comprising:

receiving time-series data of each of a plurality of real-time data streams from one or more sensors, the plurality of real-time data streams comprising a primary data stream representing a measured value, a low limit data stream representing a low limit of the measured value, a high limit data stream representing a high limit of the measured value, and a target value data stream representing a target value of the measured value, wherein the time-series data of the primary data stream includes a plurality of time stamps and a plurality of data values that are separate from the plurality of time stamps, each of the plurality of data values of the primary data stream being associated with a respective one of the plurality of time stamps and representing the measured value, wherein the time-series data of the low limit data stream includes a plurality of data values that are separate from the plurality of time stamps and the plurality of data values of the primary data stream, each of the plurality of data values of the low limit data stream being associated with a respective one of the plurality of time stamps and representing a low limit of the measured value, wherein the time-series data of the high limit data stream includes a plurality of data values that are separate from the plurality of time stamps, the plurality of data values of the primary data stream and the plurality of data values of the low limit data stream, each of the plurality of data values of the high limit data stream being associated with a respective one of the plurality of time stamps and representing a high limit of the measured value, and wherein the time-series data of the target value data stream includes a plurality of data values that are separate from the plurality of time stamps, the plurality of data values of the primary data stream, the plurality of data values of the low limit data stream and the plurality of data values of the high limit data stream, each of the plurality of data values of the target value data stream being associated with a respective one of the plurality of time stamps and representing a target value of the measured value; and

creating an electronic file based on the plurality of real-time data streams, the electronic file including a data portion and a metadata portion,

wherein the metadata portion of the electronic file comprises, for each of the plurality of data streams, one or more data stream identifiers, a time range, a source type, and a data type, and

wherein the data portion comprises the time-series data of each of the plurality of real-time data streams.

10. The medium of claim 9, wherein the metadata portion comprises an annotation locator index.

11. The medium of claim 10, wherein the annotation locator index is associated with one or more annotations, each annotation associated with a time stamp.

12. The medium of claim 10, wherein the data portion further comprises a quality level of each of the plurality of received data streams.

13. The medium of claim 9, wherein the method further comprises:

transferring the electronic file from a first apparatus to a second apparatus, wherein the real-time data streams are received at a first apparatus.

14. The medium of claim 13, wherein the method further comprises:

displaying annotations at the second apparatus; and

graphing the plurality of real-time data streams based on the metadata portion at the second apparatus.

22. The medium of claim 9, wherein one of the plurality of data values of the primary data stream, one of the plurality of data values of the low limit data stream, one of the plurality of data values of the high limit data stream and one of the plurality of data values of the target value data stream are each associated with a particular one of the plurality of time stamps and are recorded at a time represented by the particular one of the plurality of time stamps.

25. The medium of claim 9, wherein the primary data stream is a data stream representing a measured value of a pump flow rate, a fluid level or a level of viscosity.

28. The medium of claim 22, wherein the primary data stream is a data stream representing a measured value of a pump flow rate, a fluid level or a level of viscosity.

15. A system comprising:

a receiver to receive time-series data of each of a plurality of real-time data streams from one or more sensors, the plurality of real-time data streams comprising a primary data stream representing a measured value, a low limit data stream representing a low limit of the measured value, a high limit data stream representing a high limit of the measured value, and a target value data stream representing a target value of the measured value, wherein the time-series data of the primary data stream includes a plurality of time stamps and a plurality of data values that are separate from the plurality of time stamps, each of the plurality of data values of the primary data stream being associated with a respective one of the plurality of time stamps and representing the measured value, wherein the time-series data of the low limit data stream includes a plurality of data values that are separate from the plurality of time stamps and the plurality of data values of the primary data stream, each of the plurality of data values of the low limit data stream being associated with a respective one of the plurality of time stamps and representing a low limit of the measured value, wherein the time-series data of the high limit data stream includes a plurality of data values that are separate from the plurality of time stamps, the plurality of data values of the primary data stream and the plurality of data values of the low limit data stream, each of the plurality of data values of the high limit data stream being associated with a respective one of the plurality of time stamps and representing a high limit of the measured value, and wherein the time-series data of the target value data stream includes a plurality of data values that are separate from the plurality of time stamps, the plurality of data values of the primary data stream, the plurality of data values of the low limit data stream and the plurality of data values of the high limit data stream, each of the plurality of data values of the target value data stream being associated with a respective one of the plurality of time stamps and representing a target value of the measured value;

a processor to;

create an electronic file based on the plurality of real-time data streams, the electronic file including a data portion and a metadata portion,

wherein the metadata portion of the electronic file comprises, for each of the plurality of data streams, one or more data stream identifiers, a time range, a source type, and a data type, and

wherein the data portion comprises the time-series data of each of the plurality of real-time data streams.

16. The system of claim 15, wherein the metadata portion comprises an annotation locator index.

17. The system of claim 16, wherein the annotation locator index is associated with one or more annotations, each annotation associated with a time stamp.

18. The system of claim 16, wherein the data portion further comprises a plurality of quality levels, and wherein each quality level is associated with a time stamp and one of the plurality of received data streams.

19. The system of claim 15, wherein the electronic file is to be transferred from a first system to a second apparatus, and wherein the real-time data streams are received at a first apparatus.

20. The system of claim 19, wherein annotations are displayed and the plurality of real-time data streams are graphed based on the metadata portion at the second apparatus.

23. The system of claim 15, wherein one of the plurality of data values of the primary data stream, one of the plurality of data values of the low limit data stream, one of the plurality of data values of the high limit data stream and one of the plurality of data values of the target value data stream are each associated with a particular one of the plurality of time stamps and are recorded at a time represented by the particular one of the plurality of time stamps.

26. The system of claim 15, wherein the primary data stream is a data stream representing a measured value of a pump flow rate, a fluid level or a level of viscosity.

29. The system of claim 23, wherein the primary data stream is a data stream representing a measured value of a pump flow rate, a fluid level or a level of viscosity.