ACID vs BASE in Databases

No, It’s Not What You Learned In Chemistry

Deciding between SQL and No SQL databases can be a difficult task for which it is important to understand the key differences between their transaction models. In this article, we are going to discuss the two most popular database transaction models: ACID and BASE.

ACID(Atomicity, Consistency, Isolation, Durability)

ACID properties are used for maintaining data integrity during transaction processing. The term ACID stands for Atomicity, Consistency, Isolation and Durability. In order to maintain consistency before and after a transaction relational databases follow ACID properties. Let us understand the different terms in the word:

Atomicity

The all or none principle, either the transaction takes place or it doesn’t. If one element of the transaction fails the entire transaction fails, they don’t occur partially.

Consistency

The transactions should follow all rules defined in the system. The database must be in a consistent state before and after a transaction.

Isolation

Each transaction is independent of the other. A transaction does not have access to other transactions…