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
Describe Hashing in DBMS? Hashing: Hashing is a technique to store data within an array so which storing, searching, inserting and deleting data is fast (in theory it's O(1))

compare the features of oracle RDBMS with MySQL and Microsoft SQL server

Attributes attached to an entity can be of various types. Simple The attribute that cannot be further separated into smaller parts and shows the basic meaning is known as a

Define deadlock prevention. Deadlock prevention is a set of methods for ensuring that at least one of the four essential conditions like mutual exclusion, hold and wait, no pre

Data Fragmentation "Fragmentation includes decomposing the data in relation to non-overlapping component relations". Why do we require fragmenting a relation?

Example: RELATIONAL SCHEMA for PERSON: PERSON (PERSON_ID: integer, NAME: string, AGE: integer, ADDRESS: String) RELATION INSTANCE In this instance, m = 3 and n = 4

What is completeness constraint on generalization? Define the variation between total and partial design constraint. Give an example each.       Ans: Completeness Constraints

Increased overheads on update : On the drawbacks side, it will need the system to ensure that all replicas of a relation are consistent. This shows that all the replicas of the rel

Write a short note on built in function in QBE? Built in function in QBE: QBE involves various built in functions like AVG, MAX,MIN,SUM and CNT. We must prefix these operator

Design a generalization–specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles, passenger cars, vans, and buses. Justify your placement of attrib