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 Case | Choice |
---|---|
Temporary fast access as Key-Value | Redis Cache |
Data to be stored in a time-series fashion | OpenTSDB |
Object/ File data | Blob Data |
Text Search | Elastic Search |
Structured Data, with relations between objects, need transactional properties, ACID compliance | RDBMS |
Semi-Structured Data, XML/ JSON document but the structure is not fixed, Flexible queries | Document Based- MongoDB |
Data increases with time, and a limited set of queries | Columnar database- Cassandra |
Graph relation between objects | GraphDB- Neo4J |
Some useful resources from the Internet.
![https://storage.googleapis.com/gweb-cloudblog-publish/images/Which-Database_v07-10-21_1.max-2000x2000.jpeg](https://storage.googleapis.com/gweb-cloudblog-publish/images/Which-Database_v07-10-21_1.max-2000x2000.jpeg)
![](https://d1.awsstatic.com/Startups/StartupPageAssets/how-to-choose-a-database-1.12737182f86dcb29938f211ad303d63ab7bdf29a.png)