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
Explain the Dynamic Hashing Techniques There are two methods in it: extendible hashing - stores an access structure in addition to the file, and therefore is somewhat identica

Draw an ER diagram that represents the information described below. Show all entity sets, relationship sets, primary keys, and the mapping cardinality of the relationship sets.


Explain the Role of a database administrator a. Defining the Schema   The DBA describes the schema which consists of the structure of the data in the application. The DBA

I just purchased a document for you guys and wanted to confirm that it will be send within an hour or 2 to my email or where will document be sent to?

What is the full form of DDL? DDL is stand for Data Definition Language.

what characterizes the levels in RAID technology

What do you understand by transitive dependencies? Define with an example any two problems that can take place in the database if transitive dependencies are available in the datab

What is database utility? Database utility is the interface among the ABAP/4 Dictionary and the underlying the SAP system.

a) Distinguish between ‘database' and ‘Database Management Systems (DBMS)'. b) List and briefly describe five potential benefits of the database approach compared to conventio