Hello everyone ,
This is not my usual data related post but would like to share something which I have been working on .
Backstory
So couple of weeks ago , a new project came to me in my office and it was related to temperature monitoring in the server rooms.
So basically I have to put a temperature sensor in the office and keep on monitoring the temperature .
If the temperature reaches certain threshold a mail should go to the relevant department .
While exploring this , I started listing down the requirements -
- Temperature sensor [ Costed about 1$]
- Arduino board to read the sensor data. [ Costs about 4$]
- A database to store the data.
- Program which reads the database and sends mail [ I have written this in python]
So 1,2,4 was covered easily but when I approached the IT department for 3rd , they said ahh we already have too much of data in the MySQL database and do you plan to keep the old data ?
I said yes it would help in analysis and other related stuff . They were against the idea of keeping old data because there are 5 server rooms in each building we own and we own 5 building [ total of 25 rooms data ] .
That is when I thought , hey wait , why not use Hive for this? A simple Custom_JSON transaction .
Custom_JSON
I set it up and running within 2 days and everything is working smoothly right now.
I can keep pushing the data [ right now it publishes to the blockchain only if the temperature is equal to or above 20* C ]
I can read the historical data and I need not spend any money on this unless I run out of RC .
I delegated some RC from my main account to @seo.bot account for testing it out . The testing is complete and we will be making it live in the coming month .
Transactions
Now this wasn't sensitive data so I didn't use any encryption . If needed I will just encrypt the JSON and push it to the blockchain .
Here "T" is the temperature and "Name" is the Building Name and "Server Room" is self-explanatory .
Only thing I need to make sure is that I have enough RC in the account .
Will post the results when all 25 rooms data is live
After this project , I am thinking if there is any other data that I can push to Hive after encryption instead of putting it all in the MySQL database .
Regards ,
MR.