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
Mention various steps required to draw an E-R Diagram. Draw an E-R Diagram for Student Information System. Mention all suitable assumptions to justify your answer.

Given the following relations Vehicle (Reg_no, make, colour) Person(eno, name, address) Owner(eno, reg_no) Write expressions in the relational algebra to answer the following

what is lossless & dependency preserving decomposition ?

project on dbms

Eliminate Redundant Data In the "Database Relation" above, the primary key is made up of the D-ID and the Emp-ID. The database-name relies only on the D-ID. The similar databas

Describe the Association: Design  Before we describe association design let us define association "Association is set of links between two objects in the object model". It is

properties of derirable decomposition


For your chosen project, you need to identify the current problem that you wish your project to solve.  Produce a Problem Statement.  The Problem Statement should explain the purpo

Describe Physical Data independence ? Physical Data Independence - It is capacity to modify the internal schema without having to change conceptual schema. Therefore, the exter