IT Concept: ACID vs BASE
Two opposing consistency models: ACID (strict transactions) for SQL, BASE (eventual consistency) for NoSQL.
ACID vs BASE — ACID (Atomicity, Consistency, Isolation, Durability) guarantees strict transactional correctness, used by RDBMSs like PostgreSQL and MySQL. BASE (Basically Available, Soft state, Eventually consistent) trades strong consistency for availability and horizontal scale, used by Cassandra, DynamoDB, and MongoDB. Choose based on your consistency vs scale tradeoff.