Database Management System: Unit III: Transactions
Multi-version Concurrency Control
Transactions - Database Management System
The DBMS maintains multiple physical versions of single logical object in the database. When a transaction writes to an object, the database creates a new version of that object.
Multi-version Concurrency Control
• The DBMS maintains multiple physical
versions of single logical object in the database.
• When a transaction writes to an
object, the database creates a new version of that object.
• When a transaction reads an object,
it reads the newest version that exists when the transaction started.
• In this technique, the writers don't
block readers or readers don't block writer.
• This scheme makes use of:
i) Locking protocol and
ii) Timestamp protocol.
• The multiversion is now used in
almost all database management system as a modern technique of concurrency
control.
Database Management System: Unit III: Transactions : Tag: : Transactions - Database Management System - Multi-version Concurrency Control
Database Management System: Unit III: Transactions
Under Subject
Database Management System
CS3492 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Related Subjects
Environmental Sciences and Sustainability
GE3451 ESS 4th Semester | 2021 Regulation | 4th Semester EEE Dept 2021 Regulation
Theory of Computation
CS3452 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Artificial Intelligence and Machine Learning
CS3491 4th Semester CSE/ECE Dept | 2021 Regulation | 4th Semester CSE/ECE Dept 2021 Regulation
Database Management System
CS3492 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Algorithms
CS3401 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Introduction to Operating Systems
CS3451 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation