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
Related Topics
Related Subjects
Database Management System
CS3492 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation