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
What are the various forms of data transparency? a) fragmentation transparency b) replication transparency c) location transparency



The Maximum no of key fields that can be used in a header is?? 50

Define the terms entity, attribute, role and relationship between the entities, giving examples for each of them.         Ans: Entity:   An entity is a "thing" or "object" in th

Fundamentals of Database Management 1. Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? 2. With a necess


Describe domain constraints. Domain constraints contain entity integrity and referential integrity. The domain is a set of values that might be assigned to an attribute. The en

What is an entity relationship model?  The  entity  relationship  model  is  a  collection  of  basic  objects  known as entities  and  relationship  between  those objects. An

Write a query to define tables students and teachers as sub tables of people? Create table students of student under people Create table teachers of teacher under people