OPTIMIZED STORAGE AND ACCESS METHOD FOR A HISTORIAN SERVER OF AN AUTOMATED SYSTEM

• US 20090271364A1
• Filed: 05/12/2009
• Published: 10/29/2009
• 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
• Granted Patent: US 9,104,198 B2
• Time in Patent Office: Days
• 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 can be 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 the raw values provided from the process in respective signal caches;

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

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

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 when a predefined interval limit of the time stamp of the new raw value is exceeded, all aggregates are formed from the aggregate accumulators without a further operation of reading historical data, are 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 can be 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 raw values provided from the process; and

a processor for assigning each raw value internal signal-specific aggregate accumulators for desired aggregates, and for incrementally changing the aggregate accumulators for a defined interval when a new raw value arrives.

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 a predefined interval limit of the time stamp of the new raw value is exceeded, all aggregates are formed from the aggregate accumulators without a further operation of reading historical data, are 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 the raw values provided by the process in a respective signal cache for each process value; and

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.