The Process Data Historian from Intelligent Plant

Intelligent Plant's data historian is integrated as a part of Data Core, this is able to use data from any Data Core datasource, and to record data from that as subscribed to with a data stream.

eg. Modbus, OPC, MQTT, etc.. The majority of data can all be automatically recorded and mostly filtered with default exception and compression rules.

Snapshot queries return the current values of the tags polled.

A raw query returns the unprocessed data for a tag i.e. the actual data points persisted in the historian's archive.

Raw queries are generally not advised as they are likely to return a bulky result-set that may well be cropped by size constraints. In the majority of cases, a plot or aggregated data query can return a data set that is acceptable for the task at hand.

Plot queries return a best-fit data set for a given query time range and level of granularity, suitable for visualisation in a chart. For every interval in the chart, the minimum and maximum values for a tag will be returned, as well as values that best represent the shape of the raw data (as far as is possible based on the requested granularity).

A values-at-times query is used to retrieve the value of a tag at specified points in time. IPHist will return the closest raw value at or before each specified sample time.

Aggregated queries can be used to perform ad hoc processing and filtering of raw historical data based on a query time range and sample interval. IPHist supports a number of aggregation functions, as described below:

Groups the raw data for a tag into buckets using the specified sample interval and returns the number of annotations defined on a tag in each bucket.

Groups the raw data for a tag into buckets using the specified sample interval and computes the mean value of a tag in each bucket.

Groups the raw data for a tag into buckets using the specified sample interval and returns the number of raw samples in each bucket.

Groups the raw data for a tag into buckets using the specified sample interval and returns the signed difference between the first and last raw samples in each bucket.

Groups the raw data for a tag into buckets using the specified sample interval and interpolates a value at each bucket start and/or end time using the values from the previous and current buckets.

Groups the raw data for a tag into buckets using the specified sample interval and returns the minimum value from each bucket. Note that the original raw samples are returned, so the values are the “true” minimum values.

Groups the raw data for a tag into buckets using the specified sample interval and returns the maximum value from each bucket. Note that the original raw samples are returned, so the values are the “true” maximum values.

Groups the raw data for a tag into buckets using the specified sample interval and computes the percentage of raw samples in each bucket that have a quality flag set to “bad”.

Groups the raw data for a tag into buckets using the specified sample interval and computes the percentage of raw samples in each bucket that have a quality flag set to “good”.

Groups the raw data for a tag into buckets using the specified sample interval and returns the absolute difference between the first and last raw samples in each bucket.

Groups the raw data for a tag into buckets using the specified sample interval and returns the standard deviation for each bucket.

Calculates a time-based rolling average for a tag.

Groups the raw data for a tag into buckets using the specified sample interval and returns the variance for each bucket.

IPHist supports

A Single index for all data (recommended for constants, or values that change infrequently) An index per year, month, etc.. we normally recommend index per month as the indexing period for process data.

Indexes can be backed up and restored on another IPHist instance,

IPHist instances that are connected to the Industrial App Store are free. The free 1000 tag license is applied automatically, but increasing this tag count will be done free of charge by client request.

Instances that are not directly connected to the app store (on the PIN or PCN) are charged per 1000 tags.

Connections can be setup in datacore to provide reslient transfer of historical data between IPHist instances. this means that a loss in connectivity will not result in a permanent loss of data on the remote IPHist to the datasource. that data will be back filled, and consistent.

this can be configured by ..?