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.