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 conceptual schema? The schemas at the view level are known as subschema that describe dissimilar views of the database.

User error :  This contains errors in the program (e.g., Logical errors) with errors made by online users of database.  These types of errors can be avoided by applying some check

please describe the data base management with the easy example &give the application?

Suppose that in an organisation, an employee may do different roles in dissimilar projects. Say, RAM is doing coding in one project and doing designing in another. Suppose that the


how to solve the C type problems?

Describe Query evaluation engine? Query Evaluation engine: Vehicle executes low-level instructions obtained through the DML compiler. The Storage Manager Components gives in

Define an operator that a Relational Algebra does not have Ans: Relational Algebra does not have Aggregation operators.

What is multiple relationship ?

Object-oriented decompositions Object-oriented decompositions of systems better are able to cope with change. Each subsystem has a well-defined interface which communicates with