Strict 2pl-two phase locking (2pl), Database Management System

Strict 2PL:Though, this basic 2PL suffers from the trouble that it can result into loss of isolation / atomic property of transaction as theoretically speaking once a lock is released on a data item it can be changed by another transaction before the first transaction aborts or commits.

To leave such a situation we use strict two phase locking. The strict 2PL is graphically depicted in Figure. Though, the basic drawbacks of strict 2PL are that it restricts concurrency as it locks the item afar the time it is required by a transaction.

                                 693_Strict 2PL.png

                                                           Figure: Strict Two Phase Locking

Does the two phase locking solve all the problems of concurrent transactions? No, the strict 2PL answers the problem of concurrency and atomicity, though it introduces another problem.

Posted Date: 3/12/2013 2:44:54 AM | Location : United States







Related Discussions:- Strict 2pl-two phase locking (2pl), Assignment Help, Ask Question on Strict 2pl-two phase locking (2pl), Get Answer, Expert's Help, Strict 2pl-two phase locking (2pl) Discussions

Write discussion on Strict 2pl-two phase locking (2pl)
Your posts are moderated
Related Questions
Determine the Three Views of Data We know that the similar thing, if viewed from dissimilar angles produces difference sights. Similarly, the database that we have formed alrea

Creating views with Read only option : In the view definition this option is used to make sure that no DML operations can be done on the view.

Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.

1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an

What is the use of Union and intersection operation? Union: The result of this operation contains all tuples that are either in r1 or in r2 or in both r1 and r2.Duplicate tuple

What do you mean by atomicity and aggregation? Atomicity : Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete trans

Define Query Processing Query processing is the process of selecting the best plan or strategy to be employed in responding to a database request. The plan is then executed to

Define instance and schema?  Instance:  Collection of  data  kept in the  data  base  at  a  particular  moment  is  known as an Instance of the database.  Schema: The o

Components of database manager The above functions are reached by the database manager. The major elements of a database manager are: Authorisation control: This mod