ANZ Pied Piper

This is not the first time we discuss NoSQL databases in this blog. In previous posts we have seen how NoSQL databases differ from traditional SQL databases. NoSQL is a growing market forecasted to reach $5 billion this year and within that category MongoDB is the most popular and successful database. According to the latest rankings MongoDB is the 5th database most popular overall just trailing PostgreSQL and 3x more popular than other famous NoSQL databases like Redis, Cassandra and ElasticSearch. The MongoDB company itself had a successful IPO in October 2017 During our team project we decided to use MongoDB because it has a rich query language that allowed us to implement the functionality we were looking for. MongoDB stores BSON (Binary JSON) documents. This is what they look like: MongoDB is open source and its architecture allows it to scale horizontally in a load balanced fashion by adding more servers to reach very high performance. It also supports indexing for fa...

NoSQL Databases Redis is a distinguished member of a whole new category of databases called NoSQL, which stands for "Not Only" SQL. As we will see in a moment the NoSQL family is by no means a uniform one. There is in fact lots of diversity but in general they have the following characteristics: They have no fixed schema. You can even modify it as you go along They are more scalable. How big is the largest Oracle database you have come across? 100TB and 4 nodes? Some NoSQL databases can scale to PB and beyond They are able to handle unstructured data And they are usually cheaper to manage ... btw, I am not questioning your Oracle DBA's salary All this sounds great, but everything in life has a trade-off. What are the downsides? They can have duplicated data Most of them offer "eventual" consistency, ie during a "hopefully" short period of time a record is likely to have different values in different nodes ... I can see in your eyes what yo...