The locking protocol, Database Management System

The Locking Protocol: To manage concurrency related problems we use locking. A lock is mainly a variable that is associated with a data item in the database. A lock can be located by a transaction on a shared resource that it needs to use. When this is completed, the data item is available for the exclusive use for that transaction that is other transactions are locked out of that data item. When the transaction that has locked a data item does not need to use it any longer, it should unlock the data item so that other transactions can use it. If a transaction attempts to lock a data item already locked by some other transaction, it cannot do so and remains for the data item to be unlocked. The parts of DBMS that controls and stores lock information is known as the Lock Manager. The locking mechanism helps us to change a schedule into a serialisable schedule. We had definite what a schedule is, but what serialisable schedule is?

 

Posted Date: 3/12/2013 1:53:06 AM | Location : United States







Related Discussions:- The locking protocol, Assignment Help, Ask Question on The locking protocol, Get Answer, Expert's Help, The locking protocol Discussions

Write discussion on The locking protocol
Your posts are moderated
Related Questions
Describe different steps of the object-oriented design process.  The broad steps of the object-oriented design process are: a. Define context and modes of use of the system

What are the parts of SQL language? The SQL language has various parts: data - definitition language  Data manipulation language  View definition  Transaction contr

Which database level is closest to the users? External database level is closest to the users.

MOSS VALE is a town with 15000 inhabitants. The fire department wishes to develop a system that automates the despatch of fire engines to attend fires. The ERD below describes the

create an er diagram for production management in film industry

Process of normalization is the integral part of designing a database. Justify this statement with suitable database design

Explain the uses of deadlock It will lead to deadlock since this is the only place where incoming acknowledgements are processed. Without this code, sender will keep timing ou


What is meant by data-transfer rate? The data-transfer rate is the rate at which data can be retrieved from or kept to the disk.

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this info