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

The Basic 2PL:The basic two phase locking allows release of lock at any time after all the locks have been obtained. For instance, we can release the locks in schedule of Figure, after we have gone through the values of Y and Z in transaction 11, even before the display of the sum. This will increase the concurrency level. The basic 2PL is given graphically in Figure.

                                644_The Basic 2PL.png

Posted Date: 3/12/2013 2:42:53 AM | Location : United States







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

Write discussion on The basic 2pl-two phase locking (2pl)
Your posts are moderated
Related Questions
what is database management system? & why it is required?

Explain the Recoverable Schedule A recoverable schedule is one in which for each pair of transactions Ti and Tj such that Tj reads a data item formerly written by Ti, the comm

Advantages of Database management system Let us summarize the advantages. Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy i

Need for Client Server Computing- Client/Server (C/S) architecture includes running the application on multiple machines in which every machine with its component software tackles

Explain Strict Two-Phase locking A transaction T does not release any type of its exclusive (X) locks until that transaction commits or aborts. In this method no other transact

Deadlock Prevention One of the easiest approaches for avoiding a deadlock would be to obtain all the locks at the begin of the transaction. Though, this approach restricts conc

Describe the responsibilities of the DBA and the database designer ? The responsibilities of DBA and database designer are: 1. Planning for the database's future storage needs

What is Primary key? Primary Key - Primary key is one of the candidate keys which uniquely identifies each row in the relation.

E-R model uses this symbol to represent weak entity set ? A Doubly outlined rectangle symbol is used to represent weak entity set.

What are the disadvantages of file processing system? The drawbacks of file processing systems are a) Data redundancy and inconsistency b) Complexity in accessing data