Overview of Database

SQL

Relational Database

• Useful in services where data accuracy is very important thank to ACID Transaction.
• Example: Oracle, MySQL, PostgreSQL, MariaDB, …

NoSQL

Document Database

• Mostly doesn’t consider data duplication because generally used for distributed system. So data regularization is not performed.
• Example: MongoDB, Firebase, …

Key-value Database

• Used for sub DB or a special purpose, like caching data, video streaming, and login record.
• Example: Redis

Graph Database

• Useful when you want to store relationships between data.
• Example: Neo4j, Sparsity, OrientDB, ArangoDB, …

Column-family Database