ACID
What Is ACID Property Of A System?
ACID is an acronym which is commonly used to define the properties of a relational database system, it stands for the following terms.
Transaction is atomic, consistent, isolated & durable for relational database.
- Atomicity - This property guarantees that if one part of the transaction fails, the entire transaction will fail, all success , the entire transaction will success and the database state will be left unchanged in case of failure or persisted during success.
- Consistency - This property ensures that any transaction will bring the database from one valid state to another.
- Isolation - This property ensures that the concurrent execution of transactions results in a system state that would be obtained if transactions were executed serially.
- Durable - means that once a transaction has been committed, it will remain so, even in the event of power loss.
What Is BASE Property Of A System?
BASE properties are the common properties of recently evolved NoSQL databases. According to CAP theorem, a BASE system does not guarantee consistency. This is a contrived acronym that is mapped to following property of a system in terms of the CAP theorem
- indicates that the system is guaranteed to be available
- Soft state indicates that the state of the system may change over time, even without input. This is mainly due to the eventually consistent model.
- Eventual consistency indicates that the system will become consistent over time, given that the system doesn't receive input during that time.
