Overview
The Historian module implements data storage based on classical table systems. Although Despite the presence of an integrated SQLite database is integrated into within FrameworkX, the module is also compatible it also exhibits compatibility with various other types of databases.
To In order to streamline the table creation process across different database types, it is possible feasible to define generic characteristics. These characteristics will subsequently be utilized in generating the table employed for table creation in the chosen target database (TargetDB). While this selected database, designated as TargetDB. This procedure can also be independently performed conducted directly within the Database Management System (DBMS) in use, introducing . The introduction of 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 adjustmentsso forth. This not only facilitates the automatic creation of the table but also provides numerous advantages from the perspective of potential database architectural migrations.
On this page:
| Table of Contents | ||
|---|---|---|
|
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
| Property | Description |
|---|---|
| Name | Chose a name for the table, the name is chosen by the user, respecting the naming rules. |
| ArchiveLocation | The 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 | ||||
|---|---|---|---|---|
|