A Level Computer Science: Transaction processing and ACID
This module contains:
Compatible with the following examination boards
Download A Level Module 18: Transaction processing and ACID
This download is exclusively for Teach Computer Science subscribers!
To download this file, click the button below to signup (it only takes a minute) and you'll be brought right back to this page to start the download!
Already a member? Log in to download.
Transaction processing and ACID
A transaction is a single logical operation in a database. Example: Booking a ticket in an airline ticket reservation system. A transaction consists of several actions.
Concurrency: Even though many users can access and edit data at the same time, a database ensures the changes are reflected to all of them.
This A Level Computer Science module introduces transaction processing and ACID to your students, explaining:
- ACID rules
- Issues in multi-user database
- Record locking
- Deadlocks
- How deadlocks can be prevented?
More Exchanging data Modules
Transaction processing and ACID is one lesson in our Exchanging data module. The other theory lessons can be found below: