Transaction Processing Flashcards
What is transaction processing?
Any information processing which is divided into individual, indivisible operations. Each operation must succeed or fail as a complete unit.
What is the A part of ACID?
Atomicity
A change to a database is either completely performed or not at all. A half-completed change must not be saved back to the database.
What is the C part of ACID?
Consistency
Any change in the database must retain the overall state of the database.
What is the I part of ACID?
Isolation
A transaction must not be able to be interrupted by another transaction. The transaction must occur in isolation so that other users or processes cannot have access to the data concerned.
What is the D part of ACID?
Durability
Once a change has been made to a database it must not be lost due to a system failure.