SIGN UP MEMBER LOGIN:
   
ARTICLE

Difference between Lock, Block and Deadlock

Posted by Navratna Tripathi Articles | Data Warehousing February 06, 2013
In this article, we will see the difference between lock, block and deadlock.
Reader Level:

In this article, we will see the difference between lock, block and deadlock.
 
Lock- Lock is a done by database when any connection access a same piece of data concurrently and another is demanding for it.
 
Block- It occurs when two connections need access to same piece of data concurrently and the meanwhile another is blocked because at a particular time, only one connection can have access.
 
Deadlock- Deadlock occurs when one connection is blocked and waiting for a second to complete its work, and this situation is again with another process as it waiting for first connection to release the lock. Hence deadlock occurs.

Login to add your contents and source code to this article
This Feature is Sponsored By
post comment
COMMENT USING