Lock Based Concurrency Control Protocol In DBMS

Lock based Concurrency Control protocol in DBMS

Different concurrency control protocols in Database management include 

Lock-Based Protocols -

It is a mechanism in which a transaction cannot read or write data unless the appropriate lock is acquired. This helps in eliminating the concurrency problem by locking a particular transaction to a particular user. The lock is a variable that denotes those operations that can be executed on the particular data item.  

The various types of lock include :

  • Binary lock: It ensures that the data item can be in either locked or unlocked state 
  • Shared Lock: A shared lock is also called read only lock because you don’t have permission to update data on the data item. With this lock data item can be easily shared between different transactions. For example, if two teams are working on employee payment accounts, they would be able to access it but wouldn’t be able to modify the data on the payment account. 
  • Exclusive Lock: With exclusive locks, the data items will not be just read but can also be written 
  • Simplistic Lock Protocol: this lock protocol allows transactions to get lock on every object at the start of operation. Transactions are able to unlock the data item after completing the write operations 
  • Pre-claiming locking: This protocol evaluates the operations and builds a list of the necessary data items which are required to initiate the execution of the transaction. As soon as the locks are acquired, the execution of transaction takes place. When the operations are over, then all the locks release. 
  • Starvation: It is the condition where a transaction has to wait for an indefinite period for acquiring a lock. 
  • Deadlock: It is the condition when two or more processes are waiting for each other to get a resource released 

Want uninterrupted development, integration, testing, deployment, and monitoring of enterprise data operations?

Our experts will help enhance data availability, reduce downtime, lower operations costs, and mitigate data risks.

Lock Compatibility Matrix

  • A transaction can be granted lock on a data item if the requested lock is found compatible with the locks on the data item from other transactions 
  • Multiple number of transactions can have shared locks on any data item. In case any transaction holds exclusive lock on the data item, no other transactions can hold lock on it 
  • All incompatible locks  by other transactions must be released and the requested transaction has to wait if a lock is not granted 

Lets have a introductory call to discuss about how our team can help in your organization digital transformation journey. Schedule a Free Evaluation.

Register a Free Cloud ROI Assessment Workshop

Register a Free Cloud ROI Assessment Workshop

Get a Detailed assessment report with recommendations with an assessment report

Schedule free Workshop
Register a Free Cloud ROI Assessment Workshop
Register a Free Cloud ROI Assessment Workshop

Liked what you read !

Please leave a Feedback

2.3 3 votes
Article Rating
guest
0 Comments
Inline Feedbacks
View all comments

Related articles you may would like to read

0
Would love your thoughts, please comment.x
()
x

Request a Consultation

Proposals

Know the specific resource requirement for completing a specific project with us.

Blog

Keep yourself updated with the latest updates about Cloud technology, our latest offerings, security trends and much more.

Webinar

Gain insights into latest aspects of cloud productivity, security, advanced technologies and more via our Virtual events.

ISmile Technologies delivers business-specific Cloud Solutions and Managed IT Services across all major platforms maximizing your competitive advantage at an unparalleled value.