Getting your database ready for IoT
If you want to harness the opportunities given by the Internet of Things, your database has to be ready to rapidly deal with continuously growing, vast amount and various types of data in a connected environment. It will be lucrative to look at an open source alternative, which can grow according to your needs and which will have an enormous positive impact on your total cost of ownership.
One of our clients delivers sensors for cooling cells and transport solutions. Their customers are companies like Shell and McDonalds. In the case of McDonalds, they use the sensors to continuously monitor the temperature inside the trucks. Every minute the sensor delivers a signal, providing information and sending off a warning when the temperature is too high.
When rolling out a IoT initiative like this, you need a database that is:
Fast: these kind of data sources are sending new information to store every minute, but other IoT projects will even send of signals more rapidly, probably every second, on a continuous basis. You will need a database that is able to process this data fast and makes it suitable for further analysis to be able to foster insights from it.
Scalable: because you are continuously collecting data, you will need a database that is scalable. You will want to expand when necessary, but if you decide to stop monitor for whatever reason, you will need to scale down easily as well.
Fault-protection: many IoT initiatives are embedded in core-processes, so your data needs to be secure and the database needs fault-protection for when one cluster fails. So you won’t loose any insights or, in this case, miss critical warnings about temperature increases.
Often IoT initiatives, like combining data for general analyses, asks of a database that it stores various types of data. For example, a video stream is a different type of data compared to the temperature and time based data. Combining those together will give the business insight into what happened with a truck at the moment a warning was send.
Why open source is the alternative for your IoT
Choosing an open source database for your IoT initiative will give you the advantage of a highly scalable, fast, fault-protective and multi-structured solution against considerable lower costs than a locked-in, vendor specific alternative. Look for example at our PostgresPURE offer based on the IBM PowerLinux architecture compared to the Oracle Red Stack: we offer a faster solution against up to 95 per cent lesser costs.
In our next blog we will show exactly how our database and IBM PowerLinux infrastructure is best suitable for your IoT initiative.