Cascade Historian™
Real-time historical data storage
The Cascade Historian is an event driven data storage program used to maintain persistent time-sequence data
sets derived from process data.
Features and Benefits
In addition to providing storage the Historian also offers a historical query facility suitable for generating
graphs and tabular output for export to other analysis programs. Other programs can also send data to the
Cascade Historian by linking the API library and making the appropriate function calls.
The data storage mechanism within the Cascade Historian will maintain any number of simultaneous time
histories, one for each configured process point.
The data for each point is maintained in one or more files, allowing for removal of stale data or offline
archival of old data. These files are either numbered in increasing numerical order, or dated. When using
dated files, the Cascade Historian automatically begins logging to a new file at midnight.
Data logging by event
The Cascade Historian records data by event. If no data change event occurs for a point, no data is written
to disk. This saves disk space when the process point is idle, and captures even very short duration events
when the point is changing. This is both more efficient and more accurate than a sampling historian. It is
possible to place both a time and value deadband on each point to reduce storage for points whose values are
constantly changing by insignificant amounts. The Cascade Historian will not reorder out of sequence data.
Data is stored on disk in fixed length binary records to minimize disk space, with a time resolution of
nanoseconds. These files can be easily read by any custom program as well as by the Cascade Historian.
Any process may request data from the Cascade Historian. The Cascade Historian maintains a configurable
in-memory cache for each point being recorded so that queries of recent data will not require disk access.
If the request cannot be satisfied from the in-memory cache, then the disk files related to the point will be
consulted for the data to satisfy the request. The requests can take one of the following forms:
- Raw Data - Simply returns all recorded events for the data point, reported vs. time.
- Periodic Data - Performs linear interpolation on the data to produce a data set at an even time interval.
This produces the same result that a sampling historian would produce.
- Relative Interpolation - Performs interpolation of one data point against another to produce a Y vs.
X data set. Interpolation is performed on Y to produce (X,Y) pairs at the times of known values of X.
The Cascade Historian has been built to allow quick addition of other forms of historical query.
Configuration
he Cascade Historian is configured through an ASCII configuration file. The file consists of a set of
commands, and may contain comments. Any configuration command that is available in the configuration file
may also be transmitted to the running Cascade Historian at any time. This allows the control system to
reprogram the historian based on control events or on-line user configuration. The configuration command
set consists of:
| add: |
add a new point value manually |
| bufsize: |
set the size of the in-memory cache for a point |
| deadband: |
set a value or percentage deadband for a point |
| deletehistory: |
permanently stop recording data for a point |
| disable: |
temporarily stop recording data for a point |
| enable: |
restart recording data for a point |
| filebase: |
change the root file name for a point |
| flush: |
write any cached data to disk |
| history: |
add a new point to the historian for recording |
| unregister: |
stop accepting value changes from the Cascade DataHub |
| register: |
begin accepting value changes from the Cascade DataHub |
In addition to the data queries, the following commands can be transmitted at run-time to the Cascade
Historian to request information:
| describe: |
query configuration information for a point |
| earliest: |
query the earliest known value of a point |
| latest: |
query the latest known value of a point |
| historylength: |
query the number of values recorded for a point between a given start and end time |
| historycount: |
query the number of points configured in the Cascade Historian matching a given pattern |
| version: |
query the Cascade Historian version |
The Cascade Historian is designed to run optimally with the Cascade DataHub, but this is not a requirement
for proper operation. It is possible for any task to transmit information to the Cascade Historian as it
becomes available.
Options
The Cascade Historian can be supplied as a complete package with graphical trend displays and configuration
screens to determine log file parameters. We can also supply the Cascade Historian without a graphical
interface so that it may be easily integrated into existing applications. Cogent can work with you to
integrate the Historian into your current control application or we can provide you with a complete
turnkey application including field device drivers and complete historical file backup facilities.
Catalogue Entry
|