BaSE

To start with, ACID and BaSE both are Data Consistency models which compete on a use case requirement basis. In previous topic, we discussed ACID, let’s discuss BaSE. What is BaSE? Never heard about it right ??.

Let’s decode it….

The basic difference between ACID and BaSE models is the way they deal with this limitation.

●???????The ACID model provides a consistent system.

●???????The BASE model provides high availability.

?‘ACID is about Atomicity, Consistency, Isolation and Durability.’

‘BaSE is about Basically Availability, Soft State and Eventually Consistent.’

Image: https://www.guru99.com/sql-vs-nosql.html

There are 3 traits of BaSE i.e., basically available, soft state and eventually consistent.

●???????Basically Available: The system is guaranteed to be available in the event of failure.

●???????Soft State: Due to the lack of immediate consistency, data values may change over time. The BaSE model breaks off with the concept of a database that enforces its consistency, delegating that responsibility to developers.

●???????Eventually Consistent: The fact that BASE does not enforce immediate consistency does not mean that it never achieves it. However, until it does, data reads are still possible (even though they might not reflect reality).

The ACID model is a must for OLTP systems where application users can’t afford to have inconsistent databases e.g., in the Banking Domain, user transactions must be deposited before he/ she can go for withdrawal. ACID is the to-go model for RDBMS databases.

Whereas, with the introduction of semi or unstructured datasets e.g., for Marketing and Campaigning purposes which can live without ACID features, rather are more focuses on huge datasets coming from everywhere and losing consistency may not impact their use case as compared to OLTP systems required for e.g., Banking Systems. And we know in the new era NoSQL databases are becoming very popular which are not ACID.

For easy reference, most SQL/ RDBMS databases support the ACID model whereas most NoSQL databases support the BaSE model. Not to miss Hadoop and Object Storage are not ACID compliance but Databricks via its product i.e., Delta Lake provides an ACID model on top of Object Storage.

Cheers.