Difference between revisions of "Monitoring systems"
From RobolaboWiki
| Line 25: | Line 25: | ||
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. | ||
The process is divided in the following steps: | The process is divided in the following steps: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | {| class="wikitable" | |
| − | + | |- | |
| + | ! scope="col"| Item | ||
| + | ! scope="col"| Quantity | ||
| + | ! scope="col"| Price | ||
| + | |- | ||
| + | ! scope="row"| Bread | ||
| + | | 0.3 kg | ||
| + | | $0.65 | ||
| + | |- | ||
| + | ! scope="row"| Butter | ||
| + | | 0.125 kg | ||
| + | | $1.25 | ||
| + | |- | ||
| + | ! scope="row" colspan="2"| Total | ||
| + | | $1.90 | ||
| + | |} | ||
| + | |||
| − | |||
| − | |||
| − | |||
| − | |||
They remove the previous DB, get all | They remove the previous DB, get all | ||
Revision as of 17:12, 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. The process is divided in the following steps:
| Item | Quantity | Price |
|---|---|---|
| Bread | 0.3 kg | $0.65 |
| Butter | 0.125 kg | $1.25 |
| Total | $1.90 | |
They remove the previous DB, get all
