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

E-R MODEL, WHAT IS MEANT BY E-R MODEL WHAT IS MEANT BY E-R MODEL

Explain er model, Question 1 Explain ER model Question 2 What are the... Question 1 Explain ER model Question 2 What are the characteristics of a computer provided information? Question 3 What are facts and guidelines to be considered when se

Distributed control and data sharing , Distributed Control and Data sharing... Distributed Control and Data sharing: The geographical distribution of an organization can be showed in the distribution of the data; if a number of different sites are linked to e

Write the sql code, Express the following queries in SQL: (a) Write the... Express the following queries in SQL: (a) Write the SQL code that will create ALL the four tables given in the appendix. Your answer should not contain the primary key and

Synonyms and indexes, Synonyms and Indexes Some of the essential proper... Synonyms and Indexes Some of the essential properties of indexes are: An Index is a schema Object Indexes can be formed explicitly or automatically Indexes are m

What is association, What is association? Give an example of association ... What is association? Give an example of association Association is used for establishing relationships among classes. Association describe links among/between classes. For exa

Draw enhanced er-diagram for hierarchy of a student database, Draw an EER d... Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name)

What is a state chart diagram, What is a state chart diagram? State dia... What is a state chart diagram? State diagrams (State Chart Diagram) explain all possible states that a particular object can get into, and how object's state changes as result

Computer, 1. Will you advise that your organization uses open source softwa... 1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

Advantages of database systems, Problem 1. Describe the following a)... Problem 1. Describe the following a) Advantages of Database Systems b) Functions of a DBMS Explanation of part (a) and (b) 2. Explain the following concepts w