System Design Fundamentals
Vote

0% completed

​

ACID vs BASE Properties

Transfer money and the system fails halfway. The bank took 100 from your account and never added it to the recipient's. Nobody accepts that from a bank.

Databases have two famous answers to this danger, and they pull in opposite directions.

ACID keeps every transaction strictly correct, even if the system must pause or refuse work to do it. BASE keeps the system answering, even if some answers are briefly out of date.

This lesson explains both. It also clears up the one confusion that costs candidates points: the word consistency means a different thing in each.

.....

.....

.....

Like the course? Get enrolled and start learning!
Gerhard Matzen

Gerhard Matzen

· a year ago

The course text say:

In the CAP theorem, a distributed system can only guarantee two out of three: Consistency, Availability, Partition tolerance. 

However, it seems to me that "partition tolerance" is not a choice. Partitions will happen in distributed systems. When they do, you can choose between consistency and availability.

K

knowledgeshop

· 6 days ago

There is major difference in what Consistentcy is in CAP theorem vs what is in ACID. In ACID we are talking about single transaction, rules and constraints in one single database and in CAP we are talking about nodes - about replicas agreeing, multiple machines (distributed systems). This should be corrected and informed.

Show 1 reply