Explain growing phase of locking, Database Management System

Explain Growing Phase of locking

Growing Phase: In this phase the transaction can only obtain locks, but cannot release any lock. The transaction enters the growing phase as soon as it obtains the first lock it wants. From now on it has no option but to keep acquiring all the locks it would require. Ultimately the transaction reaches a point where all the lock it may require has been acquired. This point is known as Lock Point.

 

Posted Date: 7/26/2013 7:09:24 AM | Location : United States







Related Discussions:- Explain growing phase of locking, Assignment Help, Ask Question on Explain growing phase of locking, Get Answer, Expert's Help, Explain growing phase of locking Discussions

Write discussion on Explain growing phase of locking
Your posts are moderated
Related Questions
How does Oracle act as ODBC and give examples of front end uses with ODBC? ODBC achieve portability at the level of the executable by introducing an extra level of indirection.

Describe relational model? Structure of relational data base Basic structure Database schema Keys Schema diagram Query languages

Problem Explain at least five relational algebraic operators with a suitable example. Note: All the above descriptions should be done by taking at least two examples from ou

Define hot swapping? Hot swapping permits the removal of faulty disks and changes it by new ones without turning power off. Hot swapping decreases the mean time to repair.

Describe integrity constraints? Integrity Constraints - A database is just as excellent as the information stored in it, and a DBMS must therefore help avoid the entry of inc

External failure : A failure can also result because of an external cause, such as earthquakes, fire, floods, etc. The database must be duly backed up to avoid troubles occurring d

How many types of Views are there? There are Four types of views:- Database View Help View Projection View Maintenance View

Determine the language that needs a user to specify the data to be retrieved with no specifying exactly how to get it is Ans: Non-Procedural DML

We need help in Booking System for Golf Business Development of a web based booking system which permits clients to book golf lessons with the following features- a) 4 user p

Explain the concept of a data model ? Data Model - Model is an abstraction procedure which hides irrelevant details although highlighting details relevant to the application