Operational historian refers to a complementary set of time-series database applications that are developed for operational process data. Historian software is often embedded or used in conjunction with standard DCS and PLCcontrol systems to provide enhanced data capture, validation, compression, and aggregation capabilities. 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.
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 and SDKs 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.' 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:
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
Request modes
Sampling
Data omission
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.
