Multiple-mode locks: It offers two locks: exclusive locks and shared locks. But why do we require these two locks? There are a lot of transactions in the database system that never updates the data values. These transactions can coexist with some other transactions that update the database. In such a condition multiple reads are permitted on a data item, so multiple transactions can lock a data item in the read or shared lock. On the other hand, if a transaction is an updating transaction, i.e., it updates the data items, it has to make sure that no other transaction can access (read or write) those data items that it needs to update. In this situation, the transaction places an exclusive lock on the data items. Therefore, a somewhat higher level of concurrency can be achieved in comparison to the binary locking scheme

Posted Date: 3/12/2013 2:37:14 AM | Location : United States

Ask an Expert

Related Discussions:- multiple-mode locks, Assignment Help, Ask Question on multiple-mode locks, Get Answer, Expert's Help, multiple-mode locks Discussions

Write discussion on multiple-mode locks
Your posts are moderated

Write your message here..

Related Questions

Database management system, Distributed Database Management System Distributed Database Management System

Explain the weak entity set, Explain the Weak Entity Set An Entity set... Explain the Weak Entity Set An Entity set which does not have sufficient attribute to make a primay key is known as weak entity set. For instance, dependents of an employee in

Describe the concept of aggregation, Aggregation Aggregation is strong... Aggregation Aggregation is stronger form of association. It represents the "has-a" or "part-of" relationship. An aggregation association depicts a complex object which is comp

converting eerd, Create centralized relational database using Top down met... Create centralized relational database using Top down method- Construction of Logical Model: Translation EERD into Relational Schema: Use the 8 steps algorithm of converting EERD

Define the term multimedia database, Question : (a) Explain with the h... Question : (a) Explain with the help of appropriate examples the difference between ‘Data' and ‘Information'. (b) A digital image is an array of pixels, where each pixel h

Define the one-way associations, One-way Associations When an associat... One-way Associations When an association is traversed only in the one direction, then it is implemented as a pointer i.e.an attribute which contains an object reference. If mu

What is the archtetype pattern, What is the archtetype/instance pattern? ... What is the archtetype/instance pattern? The archetype/instance pattern happens when one entity tracks occurrences of another entity. A common example is the relationship among

Which file organization provides very fast access, Which file organization ... Which file organization provides very fast access to any arbitrary record of a file? Hashed file organization provides very fast access to any arbitrary record of a file.

What is recovery?, What Is Recovery?  During the life of a transaction, ... What Is Recovery?  During the life of a transaction, i.e., a after the start of a transaction but before the transaction commits, various changes may be made in a database state

Cartesian product, If R1 and R2 are two relations or functions, then the re... If R1 and R2 are two relations or functions, then the result of R3 = R1 × R2 is the combination of tuples that are in R1 and R2. The product is associative and commutative. Degr