In the previous post, you have learned about the ACID and BASE properties of database transactions in detail.
Here you will know about high-level differences between ACID and BASE.
| ACID | BASE |
| Provides Vertical Scaling | Provides Horizontal Scaling |
| Strong Consistency | Weak Consistency – Stale Data OK |
| Isolation | Last Write Wins, availability first |
| Transaction | Programmer Managed |
| Available/Consistent | Available/Partition Tolerant |
| Robust Database/Simple Code | Simpler Database, Harder Code |
| Focus on “Commit” | Best Effort |
| Nested Transactions | Approximated Answers |
| Less Availability | Aggressive (optimistic) |
| Conservative (pessimistic) | Simpler |
| Difficult Evaluation(i.e Schema) | Faster, Easier evolution |
| High Maintenance Cost | Low Maintenance Cost |
| Expensive Joins and Relationship | Free from joins and Relationship |
| Examples: Oracle, MySQL, SQL Server, etc. | Example : DynamoDB, Cassandra, CouchDB, SimpleDB etc. |
See Also:
Facing Issues On IT 