specialized locking techniques in dbms wikipedia
#1

Plz give content for specialized locking technique in DBMS
Reply
#2
In a multithreaded system, blocking is an unwanted situation that arises in a shared resource environment, where one process indefinitely waits for a resource that is in another process.


For example, suppose a set of transactions {T0, T1, T2, ..., Tn}. T0 needs an X resource to complete his task. The resource X is retained by T1, and T1 is waiting for a resource Y, which is retained by T2. T2 is waiting for resource Z, which is retained by T0. Therefore, all processes wait for each other to release resources. In this situation, none of the processes can complete its task. This situation is known as a deadlock.

Deadlocks are not healthy for a system. In the event that a system is locked in a deadlock, the transactions involved in the lock are re-enabled or restarted.

Deadlock Prevention

To avoid any deadlock situation on the system, the DBMS aggressively inspects all operations, where transactions are about to run. The DBMS inspects the operations and analyzes if they can create a deadlock situation. If you find that a deadlock situation may occur, then that transaction can never be executed.

There are deadlock prevention schemes that use the mechanism to sort the transaction due dates in order to predetermine a deadlock situation.
Reply

Important Note..!

If you are not satisfied with above reply ,..Please

ASK HERE

So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page
Popular Searches: specialized locking techniques in dbms wikipedia, implementation techniques in dbms lecture notes, switching techniques in bsnl in wikipedia, specialized locking techniques, different commutation techniques of scr from wikipedia, specialized high schools in, advanced dbms techniques wikipidia,

[-]
Quick Reply
Message
Type your reply to this message here.

Image Verification
Please enter the text contained within the image into the text box below it. This process is used to prevent automated spam bots.
Image Verification
(case insensitive)

Possibly Related Threads...
Thread Author Replies Views Last Post
  foot step power generation system wikipedia 0 707 02-10-2018, 12:50 PM
Last Post: Guest
  e ball technology wikipedia 0 2,158 28-09-2018, 08:44 PM
Last Post: Guest
  advantages and disadvantages of natural resources wikipedia 0 673 20-09-2018, 03:09 PM
Last Post: Guest
  biography of poet markus natten wikipedia 0 1,200 21-08-2018, 03:04 PM
Last Post: Guest
Rainbow design fabrication of hydraulic sheet bending machine wikipedia 3 1,168 15-08-2018, 06:10 PM
Last Post: Guest
  download journal papers on new techniques of erosion control in hilly roads 0 681 12-08-2018, 11:12 PM
Last Post: Guest
  minda remote central locking user manual 0 697 11-08-2018, 01:43 PM
Last Post: Guest
  seminar topics on food preservation techniques 0 599 27-07-2018, 07:31 AM
Last Post: Guest
  digital locking system for material handling vehicle for industrial application 0 635 26-07-2018, 12:01 PM
Last Post: Guest
  digital locking system for material handling vehicle for industrial application 0 658 26-07-2018, 11:49 AM
Last Post: Guest

Forum Jump: