Smart technology for a strong manufacturing industry with 24/7 uninterrupted production of IIoT solutions for companies.
Gone are the days that we stored our data only in Relational Database Management Systems (RDBMS). RDBMS have been on the forefront of every Operational and Business Intelligence system in the past. Not anymore. Nowadays we have to deal with multiple types of NoSQL databases. In this blog we’ll give an overview of all the different kinds of databases out there.
Traditionally RDBMS come with support for Structured Query Language (SQL). More about half a century SQL is and has been the default standard to execute queries on databases, add and modify data, etc.
NoSQL means Not Only SQL. To deal with the high amounts of data we process nowadays alternative types of databases emerged. Companies like Google, Amazon and Facebook, just to name a few, developed other database systems than our well-known RDBMS.
A lot of these database systems have been open-sourced leading to a wide variety of powerfull database systems that can actually process todays big data requirements. Of course most of these database systems have a fully open-source community edition and a payable enterprise version.
Why do we have all these different types of databases? Because, as Vogels said: “A one size fits all database doesn’t fit anyone”.
Applications require sound architectures. We want them to scale effectively. And we know that there will always be somewhere a monkey inducing chaos amongst our infrastructure. Hence design for failure is a must!
Apart from technical requirements we have different functional requirements when we want to develop a web application, an IoT solution or a Data Warehouse. And maybe we want that our system is available all over the world so our customers can buy from everywhere around the globe, with split-second response from our system.
In contrast to the one-ring of Lord Sauron, there’s not a single database that captures all use cases and requirements that we need for our applications.
"A one size fits all database doesn’t fit anyone"
So let’s have a look at different types of databases and which use cases they will fit.
The following table provides an overview of available NoSQL databases (next to the RDBMS systems) and how we can apply those NoSQL databases. Apart from the Amazon databases which are only available in the cloud most of them are available as well on-premise as in the cloud.
