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

Поделиться
HTML-код
  • Опубликовано: 30 янв 2025

Комментарии • 229

  • @DarshanSingh-ev7lx
    @DarshanSingh-ev7lx 3 года назад +154

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

    • @arnavsingh8840
      @arnavsingh8840 3 года назад +3

      Ok

    • @nihakamakshiamma3393
      @nihakamakshiamma3393 3 года назад +3

      yes

    • @piyush9906
      @piyush9906 2 года назад

      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
      @KARANVEERSINGHKALRA Год назад +2

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

  • @sunainajoshi4782
    @sunainajoshi4782 2 года назад +59

    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

  • @balkrishna7641
    @balkrishna7641 5 лет назад +13

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

  • @preethamm.n1161
    @preethamm.n1161 5 лет назад +7

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

  • @sayantanmaiti2513
    @sayantanmaiti2513 5 лет назад +13

    Perfect time to release this golden stuff.. thanks

    • @azariahalessandro5741
      @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!

  • @thomaspandey3661
    @thomaspandey3661 4 года назад +6

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

  • @poojakhandelwal3067
    @poojakhandelwal3067 4 года назад +4

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

    • @AryanSingh-rizz
      @AryanSingh-rizz 2 месяца назад

      hii pooja ji aap senior ho na kuchh batao kya hua sadi ho gayi kya???

  • @bhanu9033
    @bhanu9033 5 лет назад +2

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

  • @happycoding5163
    @happycoding5163 4 года назад +2

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

  • @ajaygohil
    @ajaygohil 4 года назад +4

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

  • @vanshsingla5319
    @vanshsingla5319 3 года назад +1

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

  • @yeshapatel433
    @yeshapatel433 4 года назад +6

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

  • @monalishakalita7575
    @monalishakalita7575 8 месяцев назад

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

  • @fawazkhan7619
    @fawazkhan7619 2 года назад +3

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

  • @vinitasingh1117
    @vinitasingh1117 5 лет назад +5

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

  • @janhvibhilare2092
    @janhvibhilare2092 4 года назад +2

    Ur teaching made me fall in love with DMS subject

  • @arajjnv7
    @arajjnv7 2 года назад

    bahot accha padha rahe aap sir.....aapka tahe dil sae dhanyvad

  • @RawFromCam
    @RawFromCam 2 года назад +1

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

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

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

  • @tabinda.
    @tabinda. 5 лет назад +32

    You are the great techer ever

  • @kunalsingh5794
    @kunalsingh5794 5 лет назад +3

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

  • @renukayadav9962
    @renukayadav9962 5 лет назад +2

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

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

    Thank you so much sir for making understand each and every topic really very helpfull

  • @pujaahuja7959
    @pujaahuja7959 3 года назад

    Learning full DBMS course from you video
    Thank you ❤️👍

  • @codinglobe_tech
    @codinglobe_tech Год назад +5

    Correction: Unlock(D) at 7:27

  • @rushikeshjadhav1414
    @rushikeshjadhav1414 5 лет назад +1

    Isiki jarurat thi aaj !
    Thank you sirji !

  • @shivampatel8850
    @shivampatel8850 3 года назад

    You are the perfect sir I have ever know , I like your way of teaching

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

    You are such a good teacher. Thanks a lot

  • @kartikchaudhary4449
    @kartikchaudhary4449 2 года назад +1

    You do very good work thank you for free knowledge

  • @sratnamanjari244
    @sratnamanjari244 4 года назад

    Sir You are the Best ....🙏.Best Teacher

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

    Your explanation makes the subject interesting...

  • @surajm344
    @surajm344 6 месяцев назад +1

    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

  • @bajranggour8054
    @bajranggour8054 Год назад +1

    You saved me !
    Legend For real

  • @rounak3239
    @rounak3239 5 лет назад +1

    Gurujee shandar jabardast zindabad

  • @susmithakolluri3478
    @susmithakolluri3478 5 лет назад +4

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

  • @38-muskaansolkar57
    @38-muskaansolkar57 4 года назад

    Your teaching is just amazing 👍

  • @zohaalmas3889
    @zohaalmas3889 3 года назад

    Very very helpfulll, your teaching skills 👏👌

  • @FactsAboutWorld_20
    @FactsAboutWorld_20 22 дня назад +1

    Tommorow is my exam 😅
    Dbms is done now 😇

  • @shrikant2820
    @shrikant2820 Год назад

    Good explaination sir jii❤❤

  • @fathimarazina4796
    @fathimarazina4796 3 года назад +2

    thank you so much sir. we are ever grateful

  • @singhraman4282
    @singhraman4282 4 года назад +1

    wow. You sir are awesome! Thanks

  • @YashDEVELOPER12
    @YashDEVELOPER12 3 года назад +2

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

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

    Sir ji you are great

  • @chamarthykoushik204
    @chamarthykoushik204 3 года назад +1

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

  • @aayushsrivastava9569
    @aayushsrivastava9569 4 года назад

    Watching your videos at x1.5 done with mids preparation

  • @ritikbadshah2258
    @ritikbadshah2258 3 года назад +1

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

  • @suvratsaxena3500
    @suvratsaxena3500 4 года назад

    Thank youu sir jiii❤️
    You are tooo good!!😊

  • @shirinshirin4341
    @shirinshirin4341 3 года назад +1

    Thank you so much sir ❤

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

    Great explaination sir 😊

  • @suryaveeraraghavalu8250
    @suryaveeraraghavalu8250 Год назад

    Excellent explanation with good examples. if you present in English, it will be very useful

    • @GTZ-98
      @GTZ-98 Год назад

      He got English subtitles

  • @arastugupta_
    @arastugupta_ 2 года назад +1

    thank you so much sir!!

  • @premsoni619
    @premsoni619 2 года назад

    perfectly explained

  • @eshugoyal4579
    @eshugoyal4579 4 года назад

    really dil se thanks a lot sir...

  • @studentsheaven-d8v
    @studentsheaven-d8v 4 года назад

    LOVE AND RESPECT FROM PAKISTAN DEAR SIR...

  • @animationcrust1993
    @animationcrust1993 4 года назад

    Great teacher 😀👍

  • @jessicatiwari1330
    @jessicatiwari1330 4 года назад

    Thanku sir for nice explanation

  • @piyushtripathi5566
    @piyushtripathi5566 3 года назад

    Thank you sir ❣️

  • @YASH-q8s
    @YASH-q8s 4 месяца назад

    4 ghante m 93 videos binge krdiye 🗿🤞🏻

  • @HarshSoni003
    @HarshSoni003 3 месяца назад

    I wish that I'd have found this channel immediately after 12th ❤

  • @hinarasool3215
    @hinarasool3215 3 года назад

    Great sir

  • @pendyalasaritha2432
    @pendyalasaritha2432 Год назад

    Thanks❤

  • @surajoberai
    @surajoberai 3 года назад +5

    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
      @harshharsh9807 2 года назад +1

      its by mistake he wants to write "D"

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

      yes ur right

    • @abdulqudoos6824
      @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

  • @rithiksai5184
    @rithiksai5184 Год назад +3

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

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

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

  • @VuvaToniKroos
    @VuvaToniKroos Год назад

    many thanks

  • @pravallikamanepalli1061
    @pravallikamanepalli1061 2 года назад

    Thank you sir

  • @komalgupta356
    @komalgupta356 5 лет назад

    Thank u sir.. 🙏🙏

  • @ShivaprasadGouda-jq7ql
    @ShivaprasadGouda-jq7ql Год назад +1

    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

  • @SumitKumar-ru7kb
    @SumitKumar-ru7kb 5 лет назад

    Great sir.

  • @kunalsingh5794
    @kunalsingh5794 5 лет назад +1

    Sir please also upload videos on digital electronic (sequential circuit)

  • @shivampandey8272
    @shivampandey8272 3 года назад

    Thank you

  • @Sudeshsorout
    @Sudeshsorout 3 года назад

    V great sir g

  • @RajuRanaVlogs
    @RajuRanaVlogs 5 лет назад

    Thank you so much sir.

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

    Thanku sir❤️

  • @leetan4147
    @leetan4147 4 месяца назад

    sir can you also explain 2 phase Commit Protocol?

  • @yahyakhan5922
    @yahyakhan5922 Год назад

    Sir Explain Multiple mode locking schema and add in this series

  • @harshitatiwari4531
    @harshitatiwari4531 4 года назад

    Thanks 😊

  • @Food_Bliss_2025
    @Food_Bliss_2025 4 года назад

    Osm explanation 👏👌

  • @shaikafroz3164
    @shaikafroz3164 5 лет назад +1

    Nice

  • @jogeswaripatro8070
    @jogeswaripatro8070 3 года назад +1

    Tq sir

  • @ashishsimonrattan8609
    @ashishsimonrattan8609 Год назад +1

    Yrr kya padhate hai ye banda!!!!!

  • @viralvideoa
    @viralvideoa 3 года назад

    Thankyou sir

  • @siddharthsinghh
    @siddharthsinghh 3 года назад

    Waah

  • @kiritocyanpine5018
    @kiritocyanpine5018 3 года назад +1

    the best way to prep or review the subject for me is to put on the Gate Smaschers playlist and skim at 2x speed...
    Efficiencey : 100
    Constitution : 95

  • @rajeshbera4799
    @rajeshbera4799 5 лет назад

    ooohh thank you sir

  • @rajatyaduvanshi2617
    @rajatyaduvanshi2617 2 года назад

    Thanx ❤

  • @SpeedBrosInc
    @SpeedBrosInc 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

  • @secretcoder3346
    @secretcoder3346 Год назад +23

    Tomorrow is my exam😂

  • @syedalmastirmizi3477
    @syedalmastirmizi3477 4 года назад

    Sir according to you locking and shrinking phase starts and end together but in last table when T1 is shrinking but T2 is growing

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

    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??

  • @rajkamalsingh4728
    @rajkamalsingh4728 3 года назад +2

    Jaa rhe h bhaiya tumhare bharose

  • @javieragd
    @javieragd 8 месяцев назад

    i have no idea what hes saying, but it kinda helped???

  • @rupadarshisamanta3288
    @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 😅😅

  • @sangwanjy
    @sangwanjy 5 лет назад

    Sir plz add video of net exam questions..

  • @prachithakur7061
    @prachithakur7061 Год назад

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

  • @ubhayjohn5444
    @ubhayjohn5444 Год назад

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

  • @nanimsbabu655
    @nanimsbabu655 8 месяцев назад +8

    Today is my exam😅

  • @priyankajella6608
    @priyankajella6608 4 года назад +17

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

    • @criminalcoder6307
      @criminalcoder6307 3 года назад +2

      Yes dude

    • @bharatreddy6728
      @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.

  • @tusharnitharwal
    @tusharnitharwal 3 года назад +1

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

  • @sufiyanahmad3854
    @sufiyanahmad3854 Год назад

    COETA 🔥