Define deadlock term, Database Management System

a. Define the term "deadlock". There are four conditions that must hold before deadlock is possible. Name them.

b. Outline an algorithm that detects whether there is a deadlock. The algorithm should be able to cope with multiple types of resources, each type having a limited number of units available.

c. When should the algorithm be invoked? The answer to this question may depend on system characteristics such as the rate of resource requests, the granularity of resources, and the expected rate of deadlock. List three possible choices and discuss the criteria you would use to choose among them.

 

Posted Date: 3/18/2013 6:15:00 AM | Location : United States







Related Discussions:- Define deadlock term, Assignment Help, Ask Question on Define deadlock term, Get Answer, Expert's Help, Define deadlock term Discussions

Write discussion on Define deadlock term
Your posts are moderated
Related Questions
er diagtram for icici

What is Collation Collation is a kind of sort order. There are majorly 3 types of sort orders, namely: i.) Dictionary case insensitive ii.)Dictionary - case sensitive

Briefly describe concurrency execution? Lock - based protocols Locks There are several modes in which a data item may be locked in this section we restrict our attention

Explain pipelining.        Ans: In order to describe pipelining in simple terms, think of it as breaking down processor functions into smaller and smaller parts. For instance,

Describe the Menu based interfaces for web clients or browsing? Menu-Based Interfaces for Web Clients or Browsing - These interfaces present the user along with lists of option

Give the limitations of SQL authorization. The code for checking authorization becomes intermixed with the rest of the application code. Implementing authorization by applic

There are three main sources of utilities and applications for a DBMS: a. Vendor applications and utilities are given for working with or maintaining the database, and generally

Decompose the table with the following description and functional dependencies into a set of equivalent tables normalized to 3NF or BCNF. This database stores records from a (ve

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

how to implement hyrise in C plus plus