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

Подписаться 2 млн

Просмотров 757 тыс.

50% 1

👉Subscribe to our new channel: / @varunainashots
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):
• DBMS (Database Managem...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Structured Query Language (SQL):
• Structured Query Langu...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on RU-vid: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmash...
► Follow us on Threads: www.threads.ne...
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: gatesmashers2018@gmail.com
#2PLprotocol#concurrencyControl#DBMS

Опубликовано:

29 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 209

@secretcoder3346 10 месяцев назад

Tomorrow is my exam😂

@facts._world 2 месяца назад

After one hour is my exam 😂

@sayantanmaiti2513 4 года назад

Perfect time to release this golden stuff.. thanks

@azariahalessandro5741 3 года назад

i know Im asking randomly but does anyone know of a tool to log back into an Instagram account? I was stupid lost my account password. I would appreciate any tricks you can give me!

@poojakhandelwal3067 3 года назад

your perfectly suitable for the pricious word guru.......ji..thanku sir.....the way u connect o the student i liked most

@thomaspandey3661 3 года назад

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

@happycoding5163 3 года назад

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

@vanshsingla5319 2 года назад

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

@kunalsingh5794 4 года назад

Perfect explanation sir...... Thank u so much

@kartikchaudhary4449 2 года назад

You do very good work thank you for free knowledge

@tabassumbegum2572 3 года назад

Your explanation makes the subject interesting...

@singhraman4282 3 года назад

wow. You sir are awesome! Thanks

@VuvaToniKroos 10 месяцев назад

many thanks

@AnshikaGupta-jv9qi Год назад

Great explaination sir 😊

@aayushsrivastava9569 3 года назад

Watching your videos at x1.5 done with mids preparation

@shaikafroz3164 4 года назад

Nice

@divyaagarwal3091 2 года назад

Thankyou sir

@pendyalasaritha2432 Год назад

Thanks❤

@RajuRanaVlogs 4 года назад

Thank you so much sir.

@rajeshbera4799 4 года назад

ooohh thank you sir

@ashadas8762 4 года назад

Thanku sir❤️

@rajkamalsingh4728 3 года назад

Jaa rhe h bhaiya tumhare bharose

@GateSmashers 3 года назад

All the best

@rajkamalsingh4728 3 года назад

Thanks .....

@soundaryavishwakarma8652 4 года назад

Osm explanation 👏👌

@abubakarsahib5146 4 года назад

❤️❤️

@rupadarshisamanta3288 Год назад

Semester k hardly 20 days bache hai Aur hum idhar aye hai concept clear karne Kiun ki college mai to syllabus khatam kia nehi 😅😅

@GateSmashers Год назад

👍👍

@mahawrites01 Год назад

🥰🥰

@halkat_memes 9 месяцев назад

Nutan College Talegoan like kara BC

@toratoura3 4 года назад

if its only indian then say so

@skypaulblacc2228 2 года назад

Bro mixes english with something unknown

@balaswarupinip8230 5 месяцев назад

That's Hindi

@nanimsbabu655 4 месяца назад

Today is my exam😅

@raunak.shoots 3 месяца назад

Same here 😢

@MrSkate119 2 года назад

Legit cant figure out if he is speaking english or not

@DevuNation 2 года назад

Raghav Handoo agar aap yeh exam ke 2hr phele dekh rhe hai toh sojao.........

@ansettirao6682 10 месяцев назад

10 am ko meri exam hai😅

@friction5360 10 месяцев назад

@@ansettirao6682kaisa gya exam ?

@kulkarnisoham 10 месяцев назад

@@friction5360i have exam tomorrow 75% syllabus is untouched yet.

@piyush2950 10 месяцев назад

@@kulkarnisohamyou on unit 4 bud only 2 units left that ain’t 75 %

@dikshanegi1028 9 месяцев назад

M dekhri hun bro..kya dikkat h

@textreverb1983 Год назад

Tomorrow exams in morning 🥺🥲

@sunainajoshi4782 2 года назад

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

@225-ehtishamkayani9 2 года назад

Same here😂

@piyush9906 Год назад

same if i found any topic related syllabus it'll be pleasure for me.

@techzon4456 7 месяцев назад

same here also

@DarshanSingh-ev7lx 3 года назад

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

@arnavsingh8840 2 года назад

@nihakamakshiamma3393 2 года назад

yes

@piyush9906 Год назад

it is not different but the way sir teaching far different and easy than my college teachers because they are for making things complicated and this sir for making things easy for student like us .

@KARANVEERSINGHKALRA Год назад

I was just thinking of quitting. Then I saw ur comment . Now you've put me in fit whether to continue or not.

@surajm344 2 месяца назад

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

@rithiksai5184 11 месяцев назад

Full BTECH CAN BE COMPLETED by this channel. Just one channel - 4 year BTech - Done

@codinglobe_tech 10 месяцев назад

Correction: Unlock(D) at 7:27

@surajoberai 3 года назад

Ur teaching skill is awesome just one small confusion. Transaction T2 has never acquired any lock on B then how could it unlock or release the lock on B ? In T2 column, at the end u have written unlock(B) it must be unlock(D), right? 8:20

@harshharsh9807 2 года назад

its by mistake he wants to write "D"

@yegavintisumanth5593 2 года назад

yes ur right

@abdulqudoos6824 2 года назад

yaar aapnay itna lmba chora note chaap dye bhaya aap seedha seedha likhdete kay ye gltee hoi aap say aur ye drust answer hai

@balkrishna7641 4 года назад

Bhaiya आपका video dekh kr bahut confusions dur ho Jaya hi समझ में भी आता ही, Thanks bro

@priyankajella6608 4 года назад

Sir,in last table t2 transaction unlock D comes right?

@criminalcoder6307 3 года назад

Yes dude

@bharatreddy6728 Год назад

Shrinking phase is dependent on particular transaction, if transaction t1 is done with shrinking phase t2 has nothing to do with it. Hence I feel lock of D is correct.

@preethamm.n1161 4 года назад

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

@tabinda. 4 года назад

You are the great techer ever

@bharathreddy8107 2 года назад

Mg ra

@gemerpyros 2 года назад

Wow it took me 1 min and 16 seconds to realize he wasn't speaking english

@deltaindigoyankee585 4 дня назад

Hey I just wanted to know if I could get a further explanation as to why in the second example of T1, T2 the T2 could start its growing phase but in the previous example T2 could not start its growing phase till T1 finished their own growing phase? Thank you

@ShivaprasadGouda-jq7ql Год назад

Sir Below serializability word After X(a) of T1 ,T2 wants S(A) in such case as you explained ,that T2 of S(A) should wait for unlock of x(a) in T1,but you didn't mentioned that T2 will be blocked , While in right side table : First t1 has S(a) and after that if in case t2 wants X(a) then you explained that t2 will be blocked (not mentioned wait),so I am getting confused when exclusive lock over shared lock occur or vice-versa lock ,then t2 should wait or blocked

@susmithakolluri3478 4 года назад

Perfect time pe aap mujie help karraho sir....thank you..!🔥

@yeshapatel433 3 года назад

Great Teaching sir.....! I have been learning the whole dbms from u......

@VaibhavPawar-s7f 10 месяцев назад

Where is nosql databases

@drunkpigeon628 4 месяца назад

In the last example, what happens if T2 starts its growing phase as it first asks for Shared lock (A), and then later, before the shrinking phase of T1 has started, it asks for an Exclusive lock(A)? Will it wait or will its growing phase be terminated??

@vinitasingh1117 4 года назад

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

@tworoyals7956 Год назад

Huo matlab kya hota h yrr koi batao Mere me question hai ki explain huo phase locking protocol

@ajaygohil 3 года назад

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

@ashishsimonrattan8609 Год назад

Yrr kya padhate hai ye banda!!!!!

@YASH-q8s 2 дня назад

4 ghante m 93 videos binge krdiye 🗿🤞🏻

@kuramatailed4814 6 месяцев назад

how can a transaction can take multiple (shared and exclusive ) lock at same time in growing phase ? how it is possible

@renukayadav9962 4 года назад

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

@Kunj-r5g 10 месяцев назад

sexy brother you are my hero

@bhanu9033 4 года назад

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

@AnkitRaj-sx3od 5 месяцев назад

Utkarsh ranjan agar aap ise video exam ke ed pahle dekh rahe hai tho aap sojao koi fayada nhi hai

@pratikkapase 5 месяцев назад

one think about you sir that is we cant like your video but we can comment your video about this

@prachithakur7061 9 месяцев назад

Lock based protocol=2 phase locking protocol same hai kyaaa????

@chamarthykoushik204 3 года назад

Sir besides subject i m also getting hindi😁😁...Tq sir

@vortex370 9 месяцев назад

Ooo lumli agr tu video dhekra to attendance dena 🤣🤣

@AniketDogra-x4v 9 месяцев назад

Acha bhai 😂🎉❤

@AniketDogra-x4v 9 месяцев назад

Ok bhai❤

@vortex370 9 месяцев назад

😆😆

@tusharnitharwal 3 года назад

sir how is this schedule serializable when we have allowed t2 to get shared lock?

@YashDEVELOPER12 3 года назад

Sir plz provide notes for each lecture. It will be more helpful for us.

@ubhayjohn5444 9 месяцев назад

Sher exam se 2 din pahle aata h or gate Smasher ka vdeo dekh k pass kr jata h 😊😅

@aayushgarg12 3 года назад

Doubt! When shrinking phase of one transaction starts(of let say data item A), can at the same time Growing phase of another transaction starts(where it demands same data item A, for any kind of lock) ?????

@tiya2752 3 года назад

Yes Aayush.. The growing phase of T2 can start at the time T1 starts to shrink.

@aayushgarg12 3 года назад

@@tiya2752 OK, got it.

@janhvibhilare2092 3 года назад

Ur teaching made me fall in love with DMS subject

@ritikbadshah2258 3 года назад

Your videos are good but no one will understand who haven't watched earlier videos

@fathimarazina4796 3 года назад

thank you so much sir. we are ever grateful

@alekseilitvinau 2 года назад

I am barely can understand what he is saying, and that is very unfortunate taking into account the praising comments down bellow...(

@letsgoswe Год назад

watching it on 170323, Friday, 05.00 pm

@abhirajsingh3071 Год назад

Can someone explain how we can apply exclusive lock on D as exclusive lock on B hasn't been unlocked and According to compatibility table exclusive lock on exclusive lock is not granted It can be granted only when first exclusive lock is unlocked