Transaction Processing (OCR A-Level Computer Science): Flashcards

Operations as single logical unit ensuring data integrity

Atomicity, Consistency, Isolation, Durability

Transaction fully completes or fully fails

Database moves from one valid state to another

Transactions operate independently without interference

Results permanent after commit, even if system crashes

Maintain data integrity and reliability

Prevents data overwriting by concurrent transactions

Multiple transactions can read, but none can modify

Only one transaction can write, no other access allowed

Two transactions waiting for each other to release locks

Storing duplicate copies of data

Only one transaction can modify data at any given time

Increases reliability and fault tolerance

Single, indivisible unit of database operations