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
Copy Data from One Database to another Database Project Description: I am having two MySQL databases with same tables. I just need to copy one Data from one to another dat

Write short notes on extension and intension? In any data model, it is significant to distinguish among the description of the database and the database itself the description

What is serializability? Explain its types? The data base system must control concurrent implementation of transactions, to ensure that the data base state remains consistent.

Can we delete data element, which is being used by table fields. No we cant delete data element.

Question: a) What is Client/Server and what benefits can be expected from Client/Server systems? b) Explain what middleware is and what it does. Why would MIS managers be p

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

Data Definition Language It organises the data in the form of columns and rows. But what does the data field column of table accumulate? How do you describe it using SQL? Th

Project Description: I am updating my Javascript + HTML website with five domains for the same website I would like to know if I want to create site map and submit it in all the

Define tuple variable Tuple variable is a type of variable whose domain is the set of all tuples.

What are the technique to define a schema completely ? A schema is completely define by DDL and DML query language.