Explain the concept of two-phase locking, Database Management System

Assignment Help:

Explain the Concept of Two-phase Locking

It concerns the positions of locking and unlocking operations in each transaction.  In this protocol every transaction issue lock and unlock requests in two phases. 

Growing Phase:  In this phase a transaction might acquire locks but may not release any lock. Here the of locks rises from zero to the maximum for the transaction. 

Shrinking Phase:  In this phase a transaction might release locks but may not obtain any new locks. Here the number of locks reduces from maximum to zero. 

The major concept of this protocol is that, all the locks are first obtained before any of the locks released. No new locks can be granted later than the releasing of any lock.


Related Discussions:- Explain the concept of two-phase locking

What is the use of group by clause, What is the use of group by clause?  ...

What is the use of group by clause?  Group  by  clause  is  used to apply  aggregate  functions  to a  set  of  tuples. The attributes given in the group by clause are used to

For known, What are the function of DBA?

What are the function of DBA?

Access, I have to solve a problem using access

I have to solve a problem using access

Describe the two alternatives for specifying structural, Describe the two a...

Describe the two alternatives for specifying structural constraints on relationship kinds? Relationship kinds have certain constraints in which limit the possible combination o

Describe graphical user interface, Describe Graphical User Interface? ...

Describe Graphical User Interface? Graphical User Interfaces (GUIs) - A GUI typically displays a schema to the user in diagrammatic form. The user can then specify a query th

Database life cycle, Enumerate or state the steps in creating a relevant da...

Enumerate or state the steps in creating a relevant database of a shop.

What is a database, What is a database? Database - Basically in simpl...

What is a database? Database - Basically in simple terms A database is a collection of inter related data and/or information stored so which it is available to several users

Hangman, a method named WonGame that checks each letter in the word is matc...

a method named WonGame that checks each letter in the word is matched by its label

Microeconomic, anyone have a textbook solutions case fair, 8 edition of vo...

anyone have a textbook solutions case fair, 8 edition of vol 1 ?, please give me

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd