Explain the lock based protocol, Database Management System

Lock Based Protocol

A lock is nothing but a mechanism that tells the DBMS whether a particular data item is being used by any transaction for read/write purpose. As there are two types of operations, i.e. read and write, whose basic nature are dissimilar, the locks for read and write operation might be behave differently.

Read operation performed by dissimilar transactions on the same data item poses less of a challenge. The value of the data item, if constant, can be read by any number of transactions at any given time.

 

Posted Date: 7/26/2013 7:05:24 AM | Location : United States







Related Discussions:- Explain the lock based protocol, Assignment Help, Ask Question on Explain the lock based protocol, Get Answer, Expert's Help, Explain the lock based protocol Discussions

Write discussion on Explain the lock based protocol
Your posts are moderated
Related Questions
What is the difference among a primary index and a secondary index? Primary Index: A primary index is an ordered file whose records are of fixed length along with two fields.


If the insertion violates one or more constraints, then two alternatives are available: Default option: - Insertion can be discarded and the reason of refusal can also be ex

write a database program for concurrency transaction in a bank

Timestamp Ordering Protocol A timestamp is a tag that can be attached to any transaction or any data item, which indicates a specific time on which the transaction or data item

tell me the functionality,advantages and disadvantages of student database

i have a homework assignment identical to one you have listed

Write short notes on relational model The relational model uses a collection of tables to show both data and the relationships between those data. The relational model is an ex

What are the properties of transaction? There are three properties of transactions :- A)     Atomicity B)      Consistency C)       Isolation

Describe the advantage of State chart Diagram A state chart represents a state machine, emphasizing flow of control from one state to other. A state machine is a behaviour whi