SQL Database vs NoSQL Database
By Tiationg Kho |
SQL Database vs NoSQL Database
- SQL Database
- Suitable for applications requiring a fixed schema
- Support complex queries
- Strict data integrity
- ACID properties
- Atomicity
- A transaction is all-or-nothing
- Consistency
- Database remains in valid state before and after a transaction
- Isolation
- Transactions do not affect each other
- Durability
- Committed transactions are saved permanently
- NoSQL Database
- Suitable for applications with changing requirements
- Store and query unstructured or semi-structured data
- Handle high volumes of data and traffic
- BASE properties
- Basically Available
- System guarantees availability
- Soft State
- System’s state is not fixed
- Eventually Consistent
- System will become consistent over time
- Type
- Key-Value Pair
- Document-Oriented
- eg. content management system
- Graph-Based
- eg. recommendation engine
- Column-Oriented
- Search Engine
- Time Series