Revision as of 16:45, 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:

For this reasons, some R scripts have been developed that perform the following actions:

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

@@ Line 1: / Line 1: @@
-HOLA
+<h1> Processing and data storage in DB </h1>
+Information from meters is stored on the server through <i>rsync</i> on a copy of the measure files.
+This information has the following properties:
+<ul>
+<li> may contains errors </li>
+<li> may be inconsistent: some minutes does not exist or be repeated </li>
+<li> contains raw values, there are only direct measures </li>
+<li> its access and use are tedious  </li>
+</ul>
+For this reasons, some R scripts have been developed that perform the following actions:
+<ul>
+<li> clean errors and process them </li>
+<li> ensure consistency by creating a continuous time reference </li>
+<li> prepare the desired raw values to be stored and process new information from these raw values </li>
+<li> store this information in a MySQL DB </li>
+</ul>