Operational historian
Operational historian refers to a complementary set of time-series database applications that are developed for operational process data.[1] Historian software is often embedded or used in conjunction with standard DCS and PLC control systems to provide enhanced data capture, validation, compression, and aggregation capabilities.[2] Historians have been deployed in almost every industry and contribute to functions such as supervisory control, performance monitoring, quality assurance, and, more recently, machine learning applications which can learn from vast quantities of historical data.
These systems were originally developed to capture instrumentation and control data, which led many to use the term "tag" for a stream of process data, referring to the physical "tags" which had been placed on instrumentation for manually capturing data. Raw data may be accessed via OPC HDA, SQL, or REST API interfaces.[3]
Operational Support
Operational historians are typically used within the manufacturing facility by engineers and operators for supervisory functions and analysis. An operational historian will typically capture all instrumentation and control data, whereas an enterprise historians that is deployed to support business functions will take a subset of the plant data.
Typically, these applications offer data access through dedicated APIs (Application Programming Interfaces) and SDKs (Software Development Kits) which offer high-performance read and write operations through vendor-specific or custom applications. Front-end tools for trending process data over time are the most common interfaces to these databases.
Because these applications are typically deployed next to or near the source of their process data, these are often marketed and sold as 'real-time database systems.'[4] This distinction varies among vendors who often have to make development choices between performance in capturing and presenting data vs. application and analysis functionality.
Usual challenges the operational historians must address are as follows:
- data collection from instrumentation and controls,
- storage and archiving of very large volumes of data,
- organization of data in the form of "tags" or "points",
- limit monitoring (alarms) and validation,
- aggregation and interpolation,
- and manual data entry (MDE).
Data access
As opposed to enterprise historians, the data access layer in the operational historian is designed to offer sophisticated data fetching modes without complex information analysis facilities. The following settings are typically available for data access operations:
- Data scope (single point or tag, history based on time range, history based on sample count),
- Request modes (raw data, last-known value, aggregation, interpolation),
- Sampling (single point, all points without sampling, all points with interval sampling),
- Data omission (based on the sample quality, based on the sample value, based on the count).
Even though the operational historians are rarely relational database management systems, they often offer SQL-based interfaces to query the database. In most of such implementations, the dialect does not follow the SQL standard in order to provide syntax for specifying data access operations parameters.
Notable software
Commercial
- ABB Decathlon History
- Aspen Technology InfoPlus.21 [5]
- Automsoft RAPID [6]
- Enea's Polyhedra Historian, a module of Polyhedra DBMS[7]
- Canary Labs Enterprise Historian[8]
- Capstone Technology's dataPARC Historian
- Control Consulting CCI Cake[9]
- Emerson Ovation Process Historian[10]
- GE Intelligent Platforms Proficy Historian[11]
- GP Strategies EtaPRO System[12]
- Honeywell Uniformance PHD[13]
- Iconics Hyper Historian[14]
- Inductive Automation SQL Bridge module of Ignition SCADA[15]
- National Instruments Citadel, used in LabVIEW DSC and other products[16]
- OSIsoft PI System
- AVEVA Enterprise Historian[17]
- AVEVA Historian[18]
- Siemens SIMATIC Process Historian[19]
- Yokogawa Exaquantum Historian[20]
See also
References
- ↑ R. H. (Rick) Meeker, Jr. (13 January 1999). "A Practical Guide to Process Data Historians and Process Information Systems" (PDF). TAPPI. Retrieved 14 September 2012.
- ↑ "Globalspec Historian Article". Retrieved 12 Jul 2012.
- ↑ "Operational Historian vs Enterprise Historian". Retrieved 5 June 2018.
- ↑ Wonderware Historian - Example of naming the operational historian the real-time database
- ↑ aspenONE MES Brochure (PDF), Aspen Technology, Inc., 2014, p. 2, retrieved 30 July 2014
- ↑ RAPID Data Historian, Automsoft, retrieved 7 September 2017
- ↑ Handling time-series data in Polyhedra IMDB, Enea AB, 11 May 2012, retrieved 30 July 2014
- ↑ Enterprise Historian, Canary Labs, retrieved 25 July 2018
- ↑ CCI Cake Historian, Control Consulting, Inc., retrieved 13 September 2018
- ↑ Ovation Process Historian, Emerson Electric Co., retrieved 13 September 2018
- ↑ Datasheet: Proficy Historian 5.5 (PDF), GE Intelligent Platforms, Inc., 2013, retrieved 30 July 2014
- ↑ EPArchive
- ↑ Uniformance PHD Product Information Note (PDF), Honeywell International Inc., 2013, retrieved 30 July 2014
- ↑ Hyper Historian
- ↑ High-Powered Data Acquisition, Inductive Automation, 2014, retrieved 30 July 2014
- ↑ Logging Data with National Instruments Citadel, National Instruments Corp., 19 July 2012, retrieved 30 July 2014
- ↑ "Enterprise Historian - Providing Real-Time Access to Critical Data". sw.aveva.com. Retrieved 2018-09-24.
- ↑ "Process Data Historian - Wonderware Historian, Time-series Database". sw.aveva.com. Retrieved 2018-09-24.
- ↑ SIMATIC Process Historian, Siemens AG, retrieved 13 September 2018
- ↑ Exaquantum delivers Production Excellence (PDF), Yokogawa Marex Limited, 2013, retrieved 30 July 2014