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
Making Common Behaviour Abstract Let us define abstraction "Abstraction means to focus on the necessary, inherent aspects of an entity and ignoring its accidental features". O

Express the subsequent query in SQL assumes which the data is stored within EMPLOYEE table with relevant fields (i) Display name, job, salary, and hire date of employee who are

What is difference among mysql_connect and mysql_pconnect? Mysql_connect() opens a new connection to the database while mysql_pconnect() opens persistent connection to the data

Explain the function of input controls. Identify four types of input control and explain the function of each. Provide an example of a data integrity error that could occur i

Attributes that are directly kept in the data base. For example, 'Birth date' attribute of a person.   Derived  Attributes that are not stored directly but can be derived

Which data type can store unstructured data? Raw data type can store unstructured data.

why three level architecture had been developed/

What is the use of Union and intersection operation? Union: The result of this operation contains all tuples that are either in r1 or in r2 or in both r1 and r2.Duplicate tuple


DISADVANTAGES OF RDBMS