WHAT IS ACID
Atomicity
Atomicity means that either the entire transaction takes place completely at once or doesn’t happen at all, there is no midway. Each transaction is considered as one unit and either runs to completion or is not executed at all.
It involves the following two operations:-
Abort:- If a transaction aborts, changes made to the database are not visible.
Commit:- If a transaction commits, changes made are visible.
Consistency
This means that the integrity of the data must be maintained so that the database is consistent before and after the transaction.
Isolation
This property ensures that transactions occur independently without interference. Changes occurring in a particular transaction will not be visible to any other transaction until that particular change in the transaction is written to memory or has been committed.
Durability
This property ensures that once the transaction has completed execution, the updates and modifications to the databases are persist even if a system failure occurs.
Conclusion
Congratulations! You have just learned about the ACID property. I hope this article will give you the knowledge.
