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
In this programming assignment, you will develop a simple database of student records. Here are the requirements: 1) A student record contains a name and a number. We assume tha

Write short notes on Schema diagram.  A database schema along with primary key and foreign key dependencies can be depicted pictorially by schema  diagram. Every relation appea

Table Handling  In RDBMS more than one table can be tackled at a time by using join operation. Join operation is a relational operation that causes 2 tables with a common domai

Consider employee (e_no, e_name, e_salary, d_code), dept (d_code, d_name) and dependent (depndt_name, e_no, relation). Show the names of employees in purchase and accounts departm

Determine the benefits of Object oriented design OOD also gives reusability, which saves time, costs and productivity gains through direct mapping to properties of Object-Orie

Greater potential for bugs: Since the sites of a distributed system operate simultaneously, it is more complex to ensure the correctness of algorithms. The art of constructing dis

#questiontypes of keys examples..

Define DBMS? DBMS: database management system (DBMS) is computer software designed for the reason of supervision databases based on a variety of data models.

What is disadvantage of multiple inheritances? There is potential ambiguity if the similar variable or method can be inherited from more than one superclass.eg: student class m

Explain the systems development life cycle. This is the traditional method to develop, maintain, and replace information systems that contains the project identification and se