Difference between revisions of "Monitoring systems"
From RobolaboWiki
| Line 24: | Line 24: | ||
The objective of these scripts is create the DB with all required information, ensuring the previous features. | The objective of these scripts is create the DB with all required information, ensuring the previous features. | ||
| + | |||
| + | |||
They remove the previous DB, get all | They remove the previous DB, get all | ||
<h2><i>update</i> scripts</h2> | <h2><i>update</i> scripts</h2> | ||
Revision as of 16:01, 8 June 2016
Processing and data storage in DB
Information from meters is stored on the server through rsync on a copy of the measure files. This information has the following properties:
- may contains errors
- may be inconsistent: some minutes does not exist or be repeated
- contains raw values, there are only direct measures
- its access and use are tedious
For this reasons, some R scripts have been developed that perform the following features:
- clean errors and process them
- ensure consistency by creating a continuous time reference
- prepare the desired raw values to be stored and process new information from these raw values
- store this information in a MySQL DB
These scripts have been divided in two different families: create and update scripts.
create scripts
The objective of these scripts is create the DB with all required information, ensuring the previous features.
They remove the previous DB, get all
