{"id":12499,"date":"2021-08-19T17:57:05","date_gmt":"2021-08-19T17:57:05","guid":{"rendered":"http:\/\/ismiletechnologies.com\/?p=12499"},"modified":"2023-02-24T13:30:47","modified_gmt":"2023-02-24T08:00:47","slug":"lock-based-concurrency-control-protocol-in-dbms","status":"publish","type":"post","link":"https:\/\/ismiletechnologies.com\/en_us\/digital-transformation\/lock-based-concurrency-control-protocol-in-dbms\/","title":{"rendered":"Lock based Concurrency Control protocol in DBMS"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"12499\" class=\"elementor elementor-12499\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c16a2c0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c16a2c0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bc0f4cb\" data-id=\"bc0f4cb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-de7b414 elementor-widget elementor-widget-text-editor\" data-id=\"de7b414\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Different concurrency control protocols in Database management include\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d920029 elementor-widget elementor-widget-heading\" data-id=\"d920029\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Lock-Based Protocols - <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a9f7813 elementor-widget elementor-widget-text-editor\" data-id=\"a9f7813\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>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.\u00a0\u00a0<\/p>\n<p>The various types of lock include :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7752ac6 elementor-widget elementor-widget-text-editor\" data-id=\"7752ac6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li><span style=\"color: #000000;\">Binary lock:<\/span>\u00a0It ensures that the data item can be in either locked or unlocked state\u00a0<\/li>\n<\/ul>\n<ul>\n<li><span style=\"color: #000000;\">Shared Lock:<\/span>\u00a0A shared lock is also called read only lock because you don\u2019t have permission to update data on the data item. With this lock data item can be easily shared between different transactions. For\u00a0example,\u00a0if two teams are working on employee payment accounts, they would be able to access it but wouldn\u2019t be able to modify the data on the payment account.\u00a0<\/li>\n<li><span style=\"color: #000000;\">Exclusive Lock:<\/span>\u00a0With exclusive locks, the data items will not be just read but can also be written\u00a0<\/li>\n<li><span style=\"color: #000000;\">Simplistic Lock Protocol:<\/span> 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\u00a0<\/li>\n<\/ul>\n<ul>\n<li><span style=\"color: #000000;\">Pre-claiming locking:<\/span>\u00a0This 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.\u00a0<\/li>\n<li><span style=\"color: #000000;\">Starvation:<\/span> It is the condition where a transaction has to wait for an indefinite period for acquiring a lock.\u00a0<\/li>\n<li><span style=\"color: #000000;\">Deadlock:<\/span>\u00a0It is the condition when two or more processes are waiting for each other to get a resource released\u00a0<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-4b2ec2e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4b2ec2e\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;gradient&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-605e38c\" data-id=\"605e38c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-98517f6 elementor-widget elementor-widget-heading\" data-id=\"98517f6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Want uninterrupted development, integration, testing, deployment, and monitoring of enterprise data operations?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6bcc312 elementor-widget elementor-widget-text-editor\" data-id=\"6bcc312\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Our experts will help enhance data availability, reduce downtime, lower operations costs, and mitigate data risks.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3fe0f14 elementor-align-left elementor-mobile-align-left elementor-tablet-align-left elementor-widget elementor-widget-button\" data-id=\"3fe0f14\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-xs\" href=\"#elementor-action%3Aaction%3Dpopup%3Aopen%26settings%3DeyJpZCI6IjI5OTEiLCJ0b2dnbGUiOmZhbHNlfQ%3D%3D\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Talk to our experts<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d316c27 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d316c27\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3b62143\" data-id=\"3b62143\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e34c3d2 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"e34c3d2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1b8ad02 elementor-widget elementor-widget-heading\" data-id=\"1b8ad02\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Lock Compatibility Matrix <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b0476a3 elementor-widget elementor-widget-text-editor\" data-id=\"b0476a3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li>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\u00a0<\/li>\n<li>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\u00a0<\/li>\n<li>All incompatible\u00a0locks\u00a0 by\u00a0other transactions must be released and the requested transaction has to wait if a lock is not granted\u00a0<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b0c087c elementor-widget elementor-widget-heading\" data-id=\"b0c087c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">How ISmile Technologies Help: <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6ccf47f elementor-widget elementor-widget-text-editor\" data-id=\"6ccf47f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>ISmile Technologies can help companies in implementing the Lock based Concurrency Control protocol in their database management systems (DBMS) in a number of ways.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-97545b1 elementor-widget elementor-widget-text-editor\" data-id=\"97545b1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ol><li><span style=\"color: #000000;\">Technical Expertise:<\/span> ISmile Technologies can provide technical expertise in designing, developing and implementing the Lock based Concurrency Control protocol in a company&#8217;s DBMS. We can help in selecting the appropriate locking mechanisms, configuring the lock granularity, and optimizing the lock contention to ensure efficient concurrency control.<br \/><br \/><\/li><li><span style=\"color: #000000;\">Customized Solutions:<\/span> ISmile Technologies can provide customized solutions based on the specific needs of a company. We can help companies implement the lock-based concurrency control protocol in a way that aligns with their specific requirements.<br \/><br \/><\/li><li><span style=\"color: #000000;\">Training and Support:<\/span> ISmile Technologies can provide training and support to help companies understand how to use the lock-based concurrency control protocol effectively. We can train developers on best practices for using locks in their code, and help administrators monitor and manage lock contention in real time.<br \/><br \/><\/li><li><span style=\"color: #000000;\">Performance Tuning:<\/span> ISmile Technologies can help companies tune their lock-based concurrency control protocol for optimal performance. We can analyze the system for bottlenecks and help fine-tune locking mechanisms to improve the overall system performance.<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c8e3ae3 elementor-widget elementor-widget-text-editor\" data-id=\"c8e3ae3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Lets have a introductory call to discuss about how our team can help in your organization digital transformation journey. <span style=\"color: #14a49c;\"><a style=\"color: #14a49c;\" href=\"http:\/\/ismiletechnologies.com\/contact-us\/\">Schedule a Free Evaluation<\/a><\/span>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Different concurrency control protocols in Database management include\u00a0 Lock-Based Protocols &#8211; 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 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":13136,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[109],"tags":[173],"class_list":["post-12499","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-digital-transformation","tag-dbms"],"_links":{"self":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts\/12499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/comments?post=12499"}],"version-history":[{"count":22,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts\/12499\/revisions"}],"predecessor-version":[{"id":37963,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts\/12499\/revisions\/37963"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/media\/13136"}],"wp:attachment":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/media?parent=12499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/categories?post=12499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/tags?post=12499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}