Hello everyone ,
This is not my usual data related post but would like to share something which I have been working on .
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 -
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 .
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 .
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 .
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.