Optimized storage and access method for a historian server of an automated system

• US 9,104,198 B2
• Filed: 05/12/2009
• Issued: 08/11/2015
• Est. Priority Date: 11/13/2006
• Status: Active Grant

• Current Assignee: ABB Schweiz AG (ABB Limited)
• Original Assignee: ABB Technology AG (ABB Limited)
• Inventors: Hanking, Heino
• Primary Examiner(s): Fleurantin, Jean B
• Assistant Examiner(s): ASPINWALL, EVAN S
• Application Number:
  US12/464,520
• Publication Number:
  US 20090271364A1
• Time in Patent Office: 2,282 Days
• Field of Search: 702/180, 702/187, 702/188, 702/189, 707/705, 707/725, 707/821, 707/822, 707/823, 707/824, 707/825, 707/642, 707/648, 707/650, 707/653, 707/654, 707/668, 707/669, 707/670, 707/999, 707/204, 711/161
• US Class Current: 1/1
• CPC Class Codes: G05B 19/4183 characterised by data acquisition, e.g. workpiece identification
• CPC Class Codes: G05B 21/02 electric
• CPC Class Codes: G05B 2219/31288 Archive collected data into history file
• CPC Class Codes: Y02P 90/02 Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]

Abstract

Exemplary embodiments of the disclosure relate to a method and a system for the storage and processing of process values of a technical process or a technical installation in a historian server which can be integrated into a process control system of a technical installation or of a technical process. In such a method and system a dedicated signal cache can be associated with every process value for its raw values provided by the process. The raw values provided by the process are stored in the respective signal caches and additional internal signal-individual aggregate accumulators for the desired aggregates are associated with every raw value. The aggregate accumulators are incrementally modified for the defined interval when a new raw value is received.

Claims

1. A method for optimized storage and processing of process values of a technical process or a technical installation in a historian server which is integrated in a process control system of a technical installation or a technical process, comprising:

assigning each process value a separate signal cache for its raw values provided from the technical process;

storing in real time, the raw values provided from the process in respective signal caches;

assigning each raw value internal signal-specific aggregate accumulators for desired aggregates;

incrementally changing the aggregate accumulators for a defined interval when a new raw value arrives; and

forming all aggregates from the aggregate accumulators without a further operation of reading historical data when a predefined time interval is exceeded and storing all formed aggregates in an aggregate memory.

2. The method as claimed in claim 1, wherein each of the raw values are assigned a time stamp, a value and a status.

3. The method as claimed in claim 2, wherein all aggregates are formed when a predefined interval limit of the time stamp of the new raw value is exceeded, and stored in a signal-specific aggregate memory, and the aggregate accumulators are simultaneously initialized for a next interval.

4. The method as claimed in claim 3, wherein the signal-specific aggregate memory is on a hard disk configured with an individual life time, and aggregate data are organized as a ring memory.

5. A system for the optimized storage and processing of process values of a technical process or a technical installation in a historian server which is integrated in a process control system of a technical installation or a technical process, comprising:

a separate individual signal cache assigned to each process value for storing in real-time, raw values provided from the process; and

a processor for assigning each raw value internal signal-specific aggregate accumulators for desired aggregates, incrementally changing the aggregate accumulators for a defined interval when a new raw value arrives, and forming all aggregates from the aggregate accumulators without a further operation of reading historical data when a predefined time interval is exceeded and storing all formed aggregates in an aggregate memory.

6. The system as claimed in claim 5, wherein the raw values can be assigned a time stamp, a value and a status.

7. The system as claimed in claim 6, wherein when all aggregates are formed a predefined interval limit of the time stamp of the new raw value is exceeded, and stored in a signal-specific aggregate memory, and the aggregate accumulators are simultaneously initialized for a next interval.

8. The system as claimed in claim 7, wherein the signal-specific aggregate memory is on a hard disk configured with an individual life time, and aggregate data are organized as a ring memory.

9. A process control system containing a processor for performing a computer implemented method for storage and processing of process values of a technical process or a technical installation in a historian server, the method comprising:

associating a dedicated signal cache with each process value for storing raw values provided by the process for the process value;

storing in real-time, the raw values provided by the process in a respective signal cache for each process value;

associating internal signal-individual aggregate accumulators for the desired aggregates with each raw value, wherein the aggregate accumulators are incrementally modified for a defined interval when a new raw value is received; and

forming all aggregates from the aggregate accumulators without a further operation of reading historical data when a predefined time interval is exceeded and storing all formed aggregates in an aggregate memory.