eru icon indicating copy to clipboard operation
eru copied to clipboard

Create the Historian snapshotter

Open marl0rd opened this issue 8 years ago • 4 comments

Historian is a important feature in Eru and it have a pretty basic concept:

The Historian is a thread that takes snapshots of the tags each fixed time and save it in the Historic table in the database.

There is some details about functionality:

  1. Only the Historian Enabled tags are taken into consideration to be included in historic table.
  2. The historian has to run in a isolated thread.
  3. The sampling time is fixed and configured in the preferences.
  4. The Historian thread start running when the SCADA is launched.
  5. Each time the Historian is started, new columns have to be added to the table if a new tag is created and historian enabled. If a tag is no more historian enabled, the column in the historian table have to be deleted.

marl0rd avatar Aug 30 '17 01:08 marl0rd

This is an example of what historic table looks like with 3 tags: historic_table

marl0rd avatar Sep 16 '17 19:09 marl0rd

Are DISTANCE, SPEED and FUEL tags?

gilbertojrequena avatar Sep 16 '17 19:09 gilbertojrequena

Yes. Read from a car computer.

marl0rd avatar Sep 16 '17 20:09 marl0rd

But, if you guys implement the Jason array technique, would be a 2 columns table...

marl0rd avatar Sep 19 '17 13:09 marl0rd