Explain the concept of deadlock, Database Management System

Assignment Help:

Question:

In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also lead to an undesirable problem of deadlock.

(a) Explain the concept of deadlock, and give an example of a deadlock situation as a result of locking.

(b) There are three main problems related to concurrency in multi-user database systems: lost updates, inconsistent analysis, and uncommitted dependency.

(i) Discuss the different types of locking mechanisms which can be used to overcome these problems support your answer with appropriate example.

(ii) Describe the concept of granularity level for locking, and discuss the effect of locking granularity on the degree-concurrency: in the database systems.


Related Discussions:- Explain the concept of deadlock

Lock, lock and types of lock

lock and types of lock

Explain trigger, Explain trigger? Trigger: A database trigger is proc...

Explain trigger? Trigger: A database trigger is procedural code which is automatically executed within response to certain events on a particular table in a database. Trigger

Consistency, what do you mean by consistency in rdbms?

what do you mean by consistency in rdbms?

File manager-database management system, File Manager File manager ha...

File Manager File manager handles the allocation of space on disk storage. It starts and maintains the list of structures and indices described in the internal schema that is

Define the immediate update, Define the Immediate Update The immediate...

Define the Immediate Update The immediate update methods may apply changes to the database on disk before the transaction arrives a successful conclusion. Though, these change

Which is a legal expression in sql, Which is a legal expression in SQL? ...

Which is a legal expression in SQL? SELECT NAME FROM EMPLOYEE is a legal expression in SQL.

In an e-r diagram how attributes are represented, In an E-R diagram how att...

In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.

#normalisation.., define normalisation and functional dependency

define normalisation and functional dependency

Structure of client server systems, Structure of Client Server Systems: In ...

Structure of Client Server Systems: In client/server architecture, clients show users who require services while servers give services. Both client and server are a combination of

Locking, define locking in simple language and decribed it

define locking in simple language and decribed it

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd