Lec-88: 2 Phase Locking(2PL) Protocol in Transaction Concurrency Control | DBMS

Two Phase Locking Protocol also known as 2PL protocol is a method of concurrency control in DBMS that ensures serializability by applying a lock to the transaction data which blocks other transactions to access the same data simultaneously. Two Phase Locking protocol helps to eliminate the concurrency problem in DBMS.

► Database Management System(Complete Playlist):

Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
►Computer Architecture (Complete Playlist):
► Theory of Computation
►Artificial Intelligence:
►Computer Networks (Complete Playlist):
►Operating System:
►Structured Query Language (SQL):
►Discrete Mathematics:
►Compiler Design:
►Number System:
►Cloud Computing & BIG Data:
►Software Engineering:
►Data Structure:
►Graph Theory:
►Programming in C:
►Digital Logic:

---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:

#2PLprotocol#concurrencyControl#DBMS

[DarshanSingh-evlx]

One tip for those who are new.... "Do not skip".
Content of every second is different and informative.

[sunainajoshi]

You have saved my semester whenever I have to study for my ignou exam first I came to ur channel and check your playlist if it is present here I am relaxed thank you so much

[balkrishna]

Bhaiya आपका video dekh kr bahut confusions dur ho Jaya hi

समझ में भी आता ही,

Thanks bro

[preethamm.n]

2pl regulates the mischievs played by parallel transactions
Thank u sir 💞🌹🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳

[poojakhandelwal]

your perfectly suitable for the pricious word way u connect o the student i liked most

[sayantanmaiti]

Perfect time to release this golden stuff.. thanks

[thomaspandey]

Your teaching style is awesome. U very well know how to connect to student.

[bhanu]

First time yeah topic bahut acche se clear Hua Hai thank you thank you thank you Varun sir

[yeshapatel]

Great Teaching I have been learning the whole dbms from

[janhvibhilare]

Ur teaching made me fall in love with DMS subject

[happycoding]

i cant thankyou enough for this wonderful video....every video is worth commenting !!!

[monalishakalita]

Literally I learn every topic so smoothly because of this channel❤ your efforts are priceless 🙏

[vanshsingla]

Ty bhaiya g very overwhelmed by this video no one can explain like u ❣️🙂

[ajaygohil]

Sir your teaching method is amazing ! My all doudght is clear . Thank you 👍

[vinitasingh]

Thank you sir, you are really awesome teacher, i m fan of your way of teaching

[surajm]

00:02 2 Phase Locking is an extension of simple, shared, and exclusive locking with modifications to address their problems.
01:21 2 Phase Locking protocol consists of growing and shrinking phases for lock acquisition and release
02:50 2PL ensures serializability by using exclusive and shared locks
04:03 2 Phase Locking(2PL) Protocol ensures serializability
05:16 2 Phase Locking (2PL) protocol ensures strict locking and unlocking of resources by transactions
06:32 2 Phase Locking(2PL) Protocol ensures serializibity and basic locking in transaction concurrency control
07:36 Lock point is a key concept for serialization and concurrency control.
08:48 2 Phase Locking ensures serializability

[fawazkhan]

After watching several videos i came here and finally understood this topic thanks for making learning easy for us 👍🏻

[RawFromCam]

Thank you sir because of you I knew 100 marks answer in 100 marks paper, you are greatttt!!!♥️♥️♥️

[sahanashreeg]

I am not perfect in Hindi means while by seeing ur vedio I learned hindi I understanding now ur language ❤sir tqs 😊

[renukayadav]

Very good explanation.. Thank you very very much for this video