ACID Flashcards
What is ACID
ACID stands for Atomicity, Consistency, Isolation, Durability. It is used to ensure that the data transactions are processed reliably in a database system.
Atomicity
Atomicity refers to the transactions that are completely done or failed where transaction refers to a single logical operation of a data. It means if one part of any transaction fails, the entire transaction fails and the database state is left unchanged.
Consistency
Consistency ensures that the data must meet all the validation rules. In simple words, you can say that your transaction never leaves the database without completing its state.
Isolation
The main goal of isolation is concurrency control.
Durability
Durability means that if a transaction has been committed, it will occur whatever may come in between such as power loss, crash or any sort of error.