Archiving & Aggregation
High performing historian functionality archiving digital, analogue and meter values exactly to the millisecond. Each process item can be configured individually in what level archiving (delta event, cyclic, historic) and aggregation (15 minutes, hours, days, month, year) should take place.
The data base model is consistent and totally transparent in its functionalities such as Visualization, , Charts, Reports and export of data.
Interfaces such as OPC UA or FlowChief Web API enable a simple data exchange between FlowChief and third party systems.
Using the features for Redundancy, backup, recovery and outsourcing the ensures secure data.
| DETAILS | |
| DBMS | Microsoft SQL Server |
|
Support of external SQL Server and Cluster |
Yes, unlimited |
| Data performance | > 1000 inserts per second (hardware independent) |
| Time selective recording < 100 ms | Yes, dependent of the performance of the protocol |
| UTC timestamp | Yes, plant specific parametrization of the timezone |
| Client value indication | Local time of the client |
| Processing of buffered data | Yes (dependent of the process linkage) |
| Archive value comments | Insertion in Webreports or Archive value correction |
| Frontend modules with full transparency to archive data | Visualization, Charts, Message archive, Report, Dashboard, Energymanagementsystem, Export, Correction, System log |
| User rights for archive data | Yes, plant specific: read, correct (see User Administration) |
| Archive matching | Yes, storage of offline time spans, followed by an inquiry of the time spans (e.g. OPC UA HA Client) |
|
Archive request from virtual calculation requirements (no independent archiving) |
Yes, from all frontend modules possible |
| Archiving of user activities (Audit) | Yes, events, login, configuration, commands, set values, System Log (Audit) |
| Archive data functionalities for calculated values | Yes, such as Avg, Sum, Max, Min, see Calculated Value |
| Interface for Third Party |
|
| Backup and Recovery | Yes, automatic database backup |
| Licensing | |
| License type Standard (FC_*) |
Integrated archiving limited through SQL server and hardware resources. |
| License type web.HMI (FC_HMI_*) |
|
| Frontend Configuration | |
| System settings | Storage period, outsourcing |
| Plantexplorer, Excel configuration | Archive settings for each process item |
| Digital Process Values | |
| Trigger for archiving | Value changes (on/off delay possible) |
| Information | Time stamp for incoming, outgoing, acknowledgement, priority, comments, linkage to maintenance tasks |
| Analogue Process Values | |
| Raw value archiving(Trigger Archiving) |
Direct archiving of all incoming data, delta events, cyclic |
| Information | Time stamp, status, value |
| Counter | |
| Raw value archiving (trigger archiving) | Direct archiving of all incoming data, cyclic |
| Information | Time stamp, status, meter reading, amount, 1 division of amount |
| Strings, Time and Manual values | |
| Trigger archiving | Value changes |
| Information | Time stamp, value |
| Aggregation of analogue data, meter reading and manual values | |
| Aggregation levels | 15 minutes, hours, day, month, year |
| Aggregation functionality | Avg, Sum, Min, Max, first and last value |
| Min Max archiving (envelope curves) | Yes, optional |
| Time weighting of truncated periods | Yes |
|
Scaling factor between aggregation levels |
Yes, e.g. conversion of Ws to kwh possible |
| Status Flags |
Disrupted values are not considered in aggregation. All disrupted values > aggregation 0 (error) Substitute value: amount substitute values > 50% |
|
Automatic post densification |
Yes, values are automatically compressed for all aggregation levels (use case: buffered values, amendments) |
| Time weighting |
Yes, raw data are aggregated with time weighting due to their non-synchrone capturing |
| Archive Value Correction | |
|
Registration of individual additional values |
Yes |
| Correction of time spans | Yes |
| Correction of individual values | Yes |
|
Automatic post calculation of all values and marked substitute values |
Yes |
|
Optional comment obligation when correcting values |
Yes |
| Storage period & Outsourcing | |
|
No limits from software (permanent storage possible) |
Yes |
|
Individual storage period for |
Raw values, 15 minutes, hour values, message archive, system log |
|
Permanent storage of manual- and laboratory values |
Yes |
|
Options after expiration of storage duration |
Delete, outsourcing personal database, outsourcing of other SQL servers, parameters for partition size of database and storage duration of outsourcing database |
| Permanent access to outsourced data | Yes (no corrections) |
| Archivdata functionality for calculated values | |
| Avg, Sum, Max, Min | Yes and many more |
| Interface for Third Party | |
| OPC UA | OPC UA |
| API | API |
| Export | Triggered Export via Reporting Service |
| Backup and Recovery | |
| Automatic database backup | Yes |
| External Ressources | |
| Webinar (German only) | |