Choosing the right database

Choosing the right database is never easy. I have already discussed types of NoSQL databases and choosing between NoSQL and SQL.

I will try to cover some common use cases here

Use CaseChoice
Temporary fast access as Key-ValueRedis Cache
Data to be stored in a time-series fashionOpenTSDB
Object/ File dataBlob Data
Text SearchElastic Search
Structured Data, with relations between objects, need transactional properties, ACID complianceRDBMS
Semi-Structured Data, XML/ JSON document but the structure is not fixed, Flexible queriesDocument Based- MongoDB
Data increases with time, and a limited set of queriesColumnar database- Cassandra
Graph relation between objectsGraphDB- Neo4J
Database choice

Some useful resources from the Internet.

Image
https://storage.googleapis.com/gweb-cloudblog-publish/images/Which-Database_v07-10-21_1.max-2000x2000.jpeg
https://cloud.google.com/blog/topics/developers-practitioners/your-google-cloud-database-options-explained
https://aws.amazon.com/startups/start-building/how-to-choose-a-database/