Lec-89: Drawbacks in 2 Phase Locking(2PL) Protocol with examples | Concurrency Control | DBMS

Drawbacks in 2 Phase Locking(2PL) Protocol :
May not free from irrecoverability.
Not free from deadlocks.
Not free from starvation.
Not free from Cascading Rollback.

0:00 - Introduction
1:02 - Problem 1
4:13 - Problem 2
6:45 - Problem 3
8:57 - Problem 4

► 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:

#problems2PL#concurrencyControl#DBMS

[nightfuryrider]

You are god of dbms, finally i had finished your all lecture. And 100% confidence in dbms

[putushotampurushotam]

U r awesome... U tube pr only u have cleared my all doubts ...thanks

[hoshihamza]

You are great sir. I very much love you sir!!! <3

[mariazeb]

I am from Pakistan. May Allah give you best reward for providing ease to the students.... please teach the teachers here how to teach. they have no idea how to teach students. lots of respect for you and best wishes....

[shubhamsolanki]

sir hamesha bhot accha smjhate hai, ek hi bar me smjh aajata hai, thankyou sir for your hard work.❣❣❣

[adyantgupta]

if it is serializable then it should be recoverable also

[asurya]

I can't understand your language sir please try to teach in English it would be very helpful to other students from other languages

[MegaNivetha]

Sir iam requesting you to post the videos in English also, please consider my request

[kanishkaverma]

Very nice explanation ... i used to be a biology student but i took engineering line, i nvr studied computer based subjects even my teachers failed to explain thm to me but you you are like a light spot in my black world keep it up plz upload more subjects realated to it stream

[iitianphilosopher]

Sir aapka lecture dekhne se phle like nhi kru to sukoon nhi milta and I feels like I cheated you so first i like then i love to watch lecture ❤️

[shivvu]

Two persons waiting for each other to text first.
That is deadlock 🗿

[sharma_ashish]

Amazing !!I found another great teacher on utube. Also, I did not understand one thing why it is called 2PL? And 2PL and serializability r same things or different? Also, To solve transaction issue in microservice architecture people uses 2PL. can u ellaborate how that work?

[learner]

We can rollback commited transaction through campanstate transaction 👍 Isn't it?

[jeeniusgroup]

agar trans 1 mein x(a) firr r(A), w(A) ho or fir trans 2 mein r(b) ho to r(b) pe to wo lock lg sakta hai tp fir serializibilty to nhi hoga

[lpunyani]

sir in irrecoverability,
the T2 transaction is demand for shared lock s(A) when when shared lock we can do only read opertaion so there is no effect on database value of A bcs we are not updating the value we are only reading so how we can say that T2 is not recoverable although if T1 get rolls back there is no problem bcs T2 does nothing write operation in A value .. pls answer

[blursedgate]

Hey, I really appreciate this, It was so hard to feel the concept from the reference book . Thank you so much for helping us out !

[udayabhi]

Thanku sir. I always watch your video. You inspire me as a YouTuber also because I am also a YouTuber. And want to become a teacher like you . Love you sir.

[dr.amandeep]

I hv doubt here...unlock ke baad lock grant e nai hoga phr commit krne mein kaise prob ayegi...case 1

[lakshyadalal]

2:51 but sir write to kar hi nhi skhta shared lock hai!

[KIRTHANAS-jlwr]

All your videos are very useful and clear Sir!