Transaction Management and Concurrency Control

Practice flashcards covering key concepts related to transaction management and concurrency control, based on lecture notes.

Transaction

A logical unit of work that must be either entirely completed or aborted; no intermediate states are acceptable.

Atomicity

The property that ensures all transaction operations must be completed; incomplete transactions are aborted.

Consistency

The property that maintains the integrity of the database by ensuring that a transaction brings the database from one valid state to another.

Isolation

The property that ensures that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

Durability

The property that ensures once transaction changes are done (committed), they cannot be undone.

Serializability

The property that ensures concurrent transactions are treated as though they were executed in serial order.

Transaction Log

A log that keeps track of all transactions that update the database, aiding in recovery from ROLLBACK statements or system failures.

Concurrency Control

The management of simultaneous operations on the database without conflicting with each other.

Rollback

The process of reverting the database to its previous state in case of a failed transaction.

Commit

The process that saves all the changes made during a transaction and makes them permanent.