Difference between revisions of "Monitoring systems"
From RobolaboWiki
| Line 11: | Line 11: | ||
</ul> | </ul> | ||
| − | For this reasons, some R scripts have been developed that perform the following | + | For this reasons, some R scripts have been developed that perform the following features: |
<ul> | <ul> | ||
<li> clean errors and process them </li> | <li> clean errors and process them </li> | ||
| Line 20: | Line 20: | ||
These scripts have been divided in two different families: <i>create</i> and <i>update</i> scripts. | These scripts have been divided in two different families: <i>create</i> and <i>update</i> scripts. | ||
| − | + | ||
| − | < | + | <h2><i>create</i> scripts</h2> |
| − | <i>create</i> | + | |
| − | </ | + | The objective of these scripts is create the DB with all required information, ensuring the previous features. |
| − | < | + | They remove the previous DB, get all |
| − | <i>update</i> | + | |
| − | + | ||
| − | </ | + | <h2><i>update</i> scripts</h2> |
Revision as of 15:59, 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
