midCAP Theorem
Consistency vs. Availability in RDBMS vs NoSQL.
Updated Apr 28, 2026
Short answer
Traditional RDBMS (ACID) typically leans toward CP/CA; NoSQL systems (BASE) often lean toward AP.
Deep explanation
Intermediate CAP analysis focuses on real-world database choices and consistency models. Traditional RDBMS (ACID) typically leans toward CP/CA; NoSQL systems (BASE) often lean toward AP.
Real-world example
Amazon DynamoDB using eventual consistency to ensure high availability for the 'Add to Cart' feature.
Common mistakes
- Assuming a CP system is always consistent
- it is only consistent as long as the majority (quorum) is alive.
Follow-up questions
- What is the L in PACELC?