8.4 Transaction States In DBMS

Поділитися
Вставка
  • Опубліковано 4 лют 2025

КОМЕНТАРІ • 101

  • @KNOWLEDGEGATE_kg
    @KNOWLEDGEGATE_kg  Рік тому

    For complete DBMS, check out this video: ua-cam.com/video/YRnjGeQbsHQ/v-deo.html

  • @shree2710
    @shree2710 6 років тому +72

    🙏thanks a lot sir!
    The photocopy example to explain partially committed st was really great! Neither in college nor by reading book i could understand what the real use of that state meant. Your video is amazing as usual!!!!

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  6 років тому +6

      Than you so much Shini.. Keep watching & learning..

  • @soumambanerjee1816
    @soumambanerjee1816 6 років тому +16

    i am getting addicted to your way of teaching ! you are becoming my hero sir !!!!! thanks a lot ... keep uploading videos..

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  6 років тому +5

      Learning is a good addiction Soumam.. Keep watching & learning.. I will try to upload more & more videos..

  • @lets_do_it1154
    @lets_do_it1154 6 років тому +15

    Finally fell in love with DBMS. It's just because of you sir...

  • @omkardeshpande7482
    @omkardeshpande7482 5 років тому +1

    I love the analogous examples which sir uses to explain every concept... esp the photocopy wala example! All the videos are amazing! Thanks a ton Sir!

  • @KNOWLEDGEGATE_kg
    @KNOWLEDGEGATE_kg  Рік тому

    🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg
    🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg

  • @ankurverma683
    @ankurverma683 6 років тому +1

    Really the teacher i had ever seen!!!
    the best part about your videos is your energy level in each and every video.

  • @amazingboss2755
    @amazingboss2755 2 роки тому +3

    Finally, got to know how to implement these topics. Explained really well.

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  2 роки тому +2

      Thanks dear ❤️ Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

  • @sonammehta8311
    @sonammehta8311 5 років тому +1

    This is the first time i am commenting on any youtube video ...sir simply i want to thank you for making videos for us n teaching us...Ur teaching style is very good and effective..sir plz upload videos for linked list and computer networking also..

  • @vaibhavdeshmukh7900
    @vaibhavdeshmukh7900 5 років тому

    Sir, DS and Algo ke vidoes bhi banaiye... Aap Bahut hi acha explain krte hai, Saare Doubts Khatam ho jate hai!! Thankyou sir for providing us these videos!!

  • @meenalgautam4620
    @meenalgautam4620 4 роки тому

    Amazing way of delivering concepts. Thanks to you sir. One of the best teachers

  • @chinmaysoni4416
    @chinmaysoni4416 6 років тому

    Sir your way of teaching is extremely great!!....

  • @PARAxITACHI
    @PARAxITACHI 5 років тому +8

    sir if r/w operations occure in buffer then if there is failure , transaction move to failed state....then why is the need of roll back, since original data base has not been used till partial commited state

  • @breaktask7132
    @breaktask7132 Рік тому +1

    Awesome Explanation😲

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  Рік тому

      Thank you 🙂Keep learning & supporting! Stay connected for more amazing videos & contents 👍 You can also check out our CS bundle course for complete preparation of Computer Science subjects, sharing course link below:
      www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

  • @rupanshiagarwal4862
    @rupanshiagarwal4862 5 років тому

    you are a hero sir !!! sir aap dhaakad ho
    only bcoz of u mre university exams acche hote h

  • @xyz-hv9ud
    @xyz-hv9ud 4 роки тому

    U are great sir .....
    Superb lecture☺️🤗

  • @Ankit-we8ym
    @Ankit-we8ym 6 років тому +4

    Great and easy to understand ,Addicted to learning

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  6 років тому +3

      It is a good addiction Ankit.. Your addiction helps us to shoot & upload more videos.. Keep watching..

  • @SALMANKHAN-ox3ts
    @SALMANKHAN-ox3ts 3 роки тому +1

    Sir ur the best😃😘👍👍👍👍👍👍

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  3 роки тому

      Thanks a lot Saleem..Keep learning and supporting., Do visit our website www.knowledgegate.in for more courses and contents.

  • @ankitasarkar8378
    @ankitasarkar8378 6 років тому +4

    You saved me sir.. it seemed so difficult before this video.

  • @sarikamishra2422
    @sarikamishra2422 4 роки тому

    Thanku sry, Sare concept clear ho jate h aapke vedio se

  • @sargamagarwal4544
    @sargamagarwal4544 4 роки тому

    Bhot Harddd 👏

  • @AnkitSingh-vp7mj
    @AnkitSingh-vp7mj 5 років тому +13

    Semester Saviour

    • @swastik2787
      @swastik2787 8 місяців тому

      Even after 5 years😂

  • @ronaktaleja8517
    @ronaktaleja8517 3 роки тому +9

    Legends watching one day before the exam.
    Ultra-legends watching on the day of exam.

  • @kankmukray
    @kankmukray 6 років тому

    Thanx a lot sir. Really you are soooooo good. Some one told the truth... Addicted to learning.

  • @sukritimacker7562
    @sukritimacker7562 5 років тому +1

    Sir you are GREAT!!

  • @sudhanshushekhar4222
    @sudhanshushekhar4222 9 місяців тому

    amazing explanation ❤❤

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  9 місяців тому

      Thank you! 🙂 Keep learning & stay connected for more videos.

  • @jyotirani9224
    @jyotirani9224 Рік тому

    Every baniya follow this. My father also follow this practice 😂 4:40

  • @bukharifaraz
    @bukharifaraz Рік тому

    4:35 Kya yaad dila diya sir 😍

  • @rachitbhatt40000
    @rachitbhatt40000 5 років тому +2

    10:40 - Ticket to kat cchuka hai. 😂

  • @TechWithAryanChauhan
    @TechWithAryanChauhan 5 років тому +1

    You are another God for me

  • @SCIENCEBOARD
    @SCIENCEBOARD Рік тому

    शानदार 👌

  • @tahermandapwala135
    @tahermandapwala135 6 років тому

    Great video, I just have one question which is
    if State goes to failure directly after active, than what things will be roll back? I mean we don't have any previous instruction right. so what will happen?

  • @memecollection4138
    @memecollection4138 6 років тому

    Firstly I would like to thank you for the concept sir..
    But I have a question to ask that is till partially committed state, all the operation is done on local buffer and if something went wrong then why to rollback. Can't we simply discard that as it is just a photocopy.

  • @purveshdubey7562
    @purveshdubey7562 6 років тому

    Sir please upload videos on computer organization before gate

  • @Nitin-oz8dn
    @Nitin-oz8dn 2 роки тому

    In the case of failure in partially committed state, why are we doing rollback as we performed R/W operations on the copy of the original database. If any failure occurs, just discard that copy. Isn't it?

  • @ehsankhan9836
    @ehsankhan9836 6 років тому

    Thnku sir G Shoaib Arshad

  • @shivamsingh-uz7zp
    @shivamsingh-uz7zp 6 років тому +2

    Sir please upload vedio deadlock in dbms

  • @shivambhardwaj2051
    @shivambhardwaj2051 2 роки тому

    Why do we need to rollback changes in local buffer ? if the changes are only present in Local buffer we can discard the buffer altogether.

  • @vinayaksharma-ys3ip
    @vinayaksharma-ys3ip 3 роки тому +1

    💯💯👍

  • @0fficialfirdos891
    @0fficialfirdos891 4 роки тому +1

    Done sir

  • @Spectral_Nights
    @Spectral_Nights 5 років тому

    Thank you sir !
    plz sir teach to my mam ,we are the first student whom she teaching first time in her life so she is not teaching not as well as you where teaching to us...

  • @OmitA25
    @OmitA25 6 років тому +5

    sir upload the videos on Computer org.

  • @priyanshusingh743
    @priyanshusingh743 5 років тому

    Agar partially committed se permanent storage me failure hua to kya hoga Jaise agar a,b,c store karna hai db me aur Sirf a and b hi store hua db me fir failure hogaya fir to db inconsistant hoga na

  • @khanmubashir3312
    @khanmubashir3312 6 років тому

    Thankuu soo much sir

  • @ghansham4067
    @ghansham4067 4 роки тому

    👍👍

  • @suniel007
    @suniel007 6 років тому

    As you mentioned if we are working on buffer/replica of database then why do we need to rollback the transaction we can simply discard that copy.

  • @ShaliniSinghMScCS
    @ShaliniSinghMScCS 6 років тому

    sir plz upload the video of query language

  • @ArunKumar-iy9se
    @ArunKumar-iy9se 6 років тому

    if firstly database is conistence then why we perform trasaction on it to make it consistence sir????
    as u told us that in aborted state after and before applied transcation the consistency will be same!!!!! then why ??

  • @dilpreetdil9047
    @dilpreetdil9047 6 років тому

    Thanku sir

  • @kapil5034
    @kapil5034 6 років тому +6

    When we are not performing transaction on our DB as mentioned that we use buffer then why we need to role back if failure occurs??

    • @viditsinghbrahmania1476
      @viditsinghbrahmania1476 4 роки тому +2

      Because it's a transaction, remember!
      The first property says it to be atomic, that means whenever an error occurs, it must go back to it's initial state. It is not about the DB, but the transaction instead.

  • @ayushguptaGupta-tg9nf
    @ayushguptaGupta-tg9nf 6 років тому

    Why are the videos uploaded again its already there in dbms-1 playlist? It confuses me what to watch plz clarify?

  • @Veto_Hakai
    @Veto_Hakai 6 років тому

    Perfect

  • @shilpishikhadas5949
    @shilpishikhadas5949 6 років тому

    Sir, ...where are the videos for B and B+ trees?

  • @deepakpandey2100
    @deepakpandey2100 6 років тому

    Thank You Sir.......

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  6 років тому +1

      You are welcome.. & Thank you buddy on posting comment on almost every video.. Keep watching..

  • @premshankarprajapat567
    @premshankarprajapat567 8 місяців тому

    thank you sir

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  8 місяців тому

      You're welcome. Keep learning, supporting & stay connected for more content👍

  • @shankysays
    @shankysays 5 років тому

    RBR sir se bhi acha padhaya hai ye topic aapne...

  • @ayushipal6948
    @ayushipal6948 6 років тому +1

    Sir plzz cfg to pda& pda to cfg conversion ki video upload kr dijiye

  • @jamespottex5197
    @jamespottex5197 5 років тому +1

    Watch at x1.25 for saving time for u next exam

  • @deathwish6340
    @deathwish6340 4 роки тому

    👍🏻 Understood
    -1530/18

  • @sayedzulfiqarahmad9920
    @sayedzulfiqarahmad9920 5 років тому

    👍👍👍👍👍👍👍👍👍👍

  • @JOJO_THE_PROGRAMMER
    @JOJO_THE_PROGRAMMER 5 років тому

    Sir mai aaj bhi aise hi form application bharta hu pehele photocopy then original

  • @priyasuman7908
    @priyasuman7908 4 роки тому

    👍

  • @malikislam4643
    @malikislam4643 2 роки тому +1

    🥰❤❤

  • @good114
    @good114 Рік тому

    💗❤️❤️💗

  • @bhanwarmeena5672
    @bhanwarmeena5672 6 років тому

    Sir pl upload relational database vedio

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  6 років тому

      Will consider your requirement & upload that too soon..

  • @krishnakrmahto97
    @krishnakrmahto97 5 років тому

    sir aap bhagwan hain.

  • @ryanaya1660
    @ryanaya1660 5 років тому +1

    Ticket to cut chuka h😀😀😀😀😀

  • @rohitjoshi6335
    @rohitjoshi6335 5 років тому +1

    M v photocopy krke from fill krra tha ....pr perfect krte krte exam ki date hi chle gai ...lamo

  • @gamma_bunta
    @gamma_bunta 2 роки тому

    sir please provide notes

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  2 роки тому

      Dear Amandeep, for free notes of DBMS, please check out the link given below:
      www.knowledgegate.in/learn/DBMSbysanchitsir

  • @soumyadeepbarik5711
    @soumyadeepbarik5711 3 роки тому

    TICKET k saath saath aap ka v taad taaq kat chuka hoga

  • @prakashbabu9390
    @prakashbabu9390 3 місяці тому

    Anyone from global group of institutes, Amritsar?

  • @MUHAMMADSAQIBAFZALMUHAMMADAFZA
    @MUHAMMADSAQIBAFZALMUHAMMADAFZA 2 роки тому

    anyone from mam tayyaba's link?

  • @shashankmishra1491
    @shashankmishra1491 6 років тому

    Ticket to cut chuka h :)

  • @rachitsharma7921
    @rachitsharma7921 6 років тому

    too much ads:(

  • @ChowthisgowdaSGowda
    @ChowthisgowdaSGowda 5 років тому

    Teach in inglish

  • @aryannaagar1686
    @aryannaagar1686 Рік тому

    why didnt i find this channel before🥲

  • @NishaSharma-nd1dk
    @NishaSharma-nd1dk 3 роки тому +1

    Thanks sir g

  • @asthatrip2028
    @asthatrip2028 4 роки тому

    Thnk u so much sir

  • @chandughai7978
    @chandughai7978 4 роки тому

    👍👍

  • @DURGESHKADAM
    @DURGESHKADAM 6 років тому +1

    thank you sir

  • @chetanarya4189
    @chetanarya4189 6 років тому

    thank you sir

  • @mainakmondal5228
    @mainakmondal5228 6 років тому +1

    Thank u sir