You're currently browsing the Ignition 8.0 docs. Click here to view the latest docs.


Overview

Ignition has two main approaches to recording historical data:

  • Tag Historian Module: Individual or groups of tags can be configured to record history based on scan class execution.
  • Transaction Groups: Groups of OPC items that are recorded on an execution cycle. More information on Transaction Groups can be found in the SQL Bridge (Transaction Groups) section.

The Tag Historian Module provides power and flexibility for storing and accessing historical data. When history is enabled on an Ignition Tag, data is stored automatically in your SQL database in an efficient format. This data is then available for querying through scripting, historical bindings, and reporting. Options for partitioning and deleting old data help to ensure the system stays maintained with minimal extra work. Also, you can drag-and-drop Tags directly onto an Easy Chart component to create trends or onto a table to display historical values. Tag Historian's robust querying features provide you great flexibility in how you retrieve the stored data.

On this page ...



Historian Tables

With the Vision Table component or the Perspective - Table component you can quickly make custom tables that display historical data. You can customize your table to bring back the most recent history, a specific date range, fixed sample size, and interval sample size, In Vision, you can drag and drop history-enabled tags onto a table component to display historical values. 


Tag Historian Querying

While the data is stored openly in the database, it does not lend itself well to direct querying. Ignition offers a range of built-in querying options that are very powerful and flexible. In addition to simple on-change querying, the system can perform advanced functions such as querying many Tags from multiple providers, calculating their quality, interpolating their values, and coordinating their timestamps to provide fixed resolution returns. Tag History Bindings allow you to pull Tag History data that is stored in the database into a component through a binding. The binding type, which is only available for Dataset type properties, runs a query against the Tag Historian. 
For more information, see Tag History Bindings in Perspective or Tag History Bindings in Vision.

Querying can be performed on tables and charts through the Historical binding, Nested Queries, and through scripting. You can also query Tags from the Reporting Module.


Vision Historian Charts

In the Vision module, you can use the Easy Chart component to make powerful timeseries charts from Tag Historian data. Drag and drop history-enabled Tags onto a chart to create chart pens and data trends. Your charts and graphs can include subplots, axes, digital offsets, and moving averages. You can quickly and easily turn your historical and realtime data into dynamic charts and graphs for your users. These charts can be configured in the runtime to give users quick access to data in the time range they need. 

To see all the chart options and features for the Vision module's Easy Chart, refer to the section on Using the Vision Easy Chart.



Store and Forward

The Store and Forward system provides a reliable way for Ignition to store historical data to the database. The Store and Forward system is not exclusively part of Tag History, but systems such as the Tag Historian and Transaction Groups use it to prevent data loss and store data efficiently using a record cache.


Other Methods of Storing Historical Data

The SQL Bridge (Transaction Groups) Module performs a variety of tasks to store data historically. In their simplest form, Transaction Groups read values from the OPC addresses and store them into a SQL database. There are four types of Transaction Groups; Standard, Block, Historical, and Stored Procedures. 

  • Standard Group is the most flexible, and can also write database values to OPC addresses or synchronize data changes between both the database and PLC. This allows you to create true realtime values tables in a database, and push values to a PLC.
  • Historical Group can quickly store data from the plant floor into any kind of SQL database. 
  • Block Group transfers large amounts of data very efficiently.
  • Stored Procedures uses PLC data as inputs and outputs from your existing stored procedures. 

Data storage

Historical Tag values pass through the Store and Forward system before they are stored in the database connection associated with the historian provider. The data is stored according to its datatype directly to a table in the SQL database, with its quality and a millisecond resolution timestamp. The data is only stored on-change, according to the value mode and deadband settings on each Tag, thereby avoiding duplicate and unnecessary data storage. The storage of scan class execution statistics ensures the integrity of the data. While advanced users may change the table according to their database to be more efficient (for example, using a compression engine), Ignition does not perform binary compression or encrypt the data.


In This Section ...


  • No labels