Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

The

HistorianTable is a logical organization that groups Tags for historical archiving. Each Historian Table has a definition of which Target Database the group of Tags will be archived. You can also configure other standard settings that apply to all tags in that group in the Historian Table, such as when to save new data or how long to keep the data. The configuration of the Historian Tables is on the Solution Explorer, at 

Historian module implements data storage based on classical table systems. Although an SQLite database is integrated into FrameworkX, the module is also compatible with various other types of databases.

To streamline the table creation process across different database types, it is possible to define generic characteristics. These characteristics will subsequently be utilized in generating the table in the chosen target database (TargetDB). While this procedure can also be independently performed directly within the Database Management System (DBMS) in use, introducing this abstraction layer enables users to customize settings such as table name, data type, data lifespan, and others. In the event of a potential architectural migration, these configurations are automatically applied to the new database without the need for manual adjustments

Historian → Historian Tables

.

On this page:

Table of Contents
maxLevel3


Historian Tables Configuration

A historian table delineates some characteristics regarding how data will be written to its target, standardizing requirements for different types of databases. In practice, the software incorporates distinct implementations for various databases, aiming to accomplish identical tasks. However, for the user, the interface remains consistent irrespective of the chosen target.


Properties

PropertyDescription
NameChose a name for the table, the name is chosen by the user, respecting the naming rules.
ArchiveLocationThe Target DB's name.
AutoCreate
SaveOnChange
TimeDeadBand
LifeTime
SaveQuality
ValueType
Trigger
Normalized
Level
Category
LockState
LockOwwner
DateCreated
DateModified
Description

Paragraph


In this section...

Page Tree
root@parent
spacesV10