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 are the components of storage manager? The storage manager components include a) Authorization and integrity manager b) Transaction manager c) Buffer manager d

Describe the iterative and incremental life cycle For an iterative and incremental life cycle, two criteria are process and time. The main components of showing a project devel

Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000.  CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA

A step-wise distributed database design methodology Following is a step-wise methodology for distributed database design. (1) Examine the nature of distribution. Find out wh

what is er digram given that example of hospital,bank and library er digram.

Define functional and multivalued dependencies.       Ans:  A functional dependency is a assets of the semantics of the attributes in a relation. The semantics point out how at


Define a view and a trigger. Construct a view for the above relations that have the information about suppliers and the elements they supply. The view holds the S#, SNAME, P# , PNA

Question (a) Concurrent access to data from a database is a normal part of application program usage. Describe three approaches to concurrency control (b) Distinguish among

Explain forms based and graphical interface? Forms based and graphical interface: graphical user interface (GUI) is a kind of user interface which permits people to interact