Database usecase ( how and when to use which database)

Difference SQL and No Sql

Difference SQL and No Sql

• Use a relational database for

where data integrity is absolutely paramount (i.e., for financial applications, defense and security, and private health information)

Highly structured data

Automation of internal processes

• Use a document database for: (MongoDB, Couchbase)
  Unstructured or semistructured data
  Content management
  In-depth data analysis
  Rapid prototyping
• Use a key-value store for (Redis, Memcached)
  Recommendations
  User profiles and settings
  Unstructured data such as product reviews or blog comments
  Session management at scale
  Data that will be accessed frequently but not often updated
• Use a wide-column store for: ( Cassandra, Hbase)
  Big data analytics where speed is important
  Data warehousing on big data
  Large scale projects (this database style is not a good tool for average transactional applications)

Content from

How to choose the right database for your enterprise

CAP Images from http://edureka.com/