8.3 ACID Properties Of Transaction In DBMS

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

КОМЕНТАРІ • 112

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

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

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

    Transaction Management Component- ATOMICITY
    Concurrency Control Component- ISOLATION
    Recovery Management Component- Durability

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

    Atomicity + Isolation + Durability if All holds good then it is Consistent ☺......Great Explanation

  • @adityaraj5757
    @adityaraj5757 9 місяців тому +2

    01:53 ACID properties ensure consistency and reliability in database transactions.
    03:46 ACID properties ensure consistency of database through transactions.
    05:39 Transactions in DBMS ensures atomicity
    07:32 Isolation in ACID properties ensures concurrent running of multiple transactions
    09:25 Isolation in DBMS ensures that a transaction is not affected by other transactions.
    11:18 The concurrency control component takes care of isolation, while the recovery management component takes care of durability.
    13:11 Consistency ensures that the database remains in a consistent state before and after a transaction.
    15:00 Consistency is the conclusion of atomicity, isolation, and durability properties.

  • @pabitraroy3907
    @pabitraroy3907 3 роки тому +19

    B.SC I learnt from here . MCA I am here for revision 😃 This playlist is my DBMS book actually. I had never bought any dbms book 😂

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

      Superr, glad to know this. All the best for your future :) Keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

  • @animeshpandey2911
    @animeshpandey2911 Рік тому +3

    i must admit you have the most clear concepts in these subjects sir

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

      Thanks a lot dear @Animesh, keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing videos & contents👍

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

    Sir , I have so may awesome teachers in my life and you are one of them .you are amazing .I would love to meet you once in my life. Thanks for everything.

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

    Amazing explanation with examples......
    Thank you sir!!!!!!👍🏻

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

    sir..you are bestt..!! just because of u i was able to understand various topics related to my syllabus, ur videos are really helpful and explanatory ! Thankyou so much

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

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

    Thank you so much Sanchit Jain for your unparalleled method of teaching.

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

    Sir, you're an amazing teacher. You create such quality videos, it's so easy to understand. Thank you so much :)

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

      Thank you for your words of appreciation Vardaan.. Keep following and learning..

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

    Was explained well .I could even translate it in English and write my answer on the ACID properties.

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

    Awesome way of teaching and very easy way to understand...these properties of transaction...👍

  • @prakashparamanick2616
    @prakashparamanick2616 3 роки тому +1

    It was awesome video. lots of things I learned

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

      Thank you so much Prakash.. keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents.

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

    I hope this comments section is not only for praises but also for some words of suggestion, I'm a student and I feel that you are doing really a good job but the pace at which the videos go is a tad slow you could have completed acid properties within 5min so please be more precise and I hope one example is enough and no need of repeating it again, btw thanks a lot you make some wonderful content.Cheers!!

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

    Best teacher ever

  • @asthanishad5545
    @asthanishad5545 3 роки тому +1

    Because great explaination

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

      Thank you Ashu, Keep Watching, Visit tiny.cc/yt_kgwebsite for more helpful content and courses👍

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

    thanks!

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

      You're welcome Raman, keep learning & following👍😊

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

    Badiyaa 🙌

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

    very clear explanation,thank u sir

  • @ankitmehta4133
    @ankitmehta4133 3 роки тому +1

    Crystal clear

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

      Very good, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

  • @santmun2008
    @santmun2008 3 роки тому +1

    You are Superb sir ji...

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

      Thanks a lot😍Visit tiny.cc/yt_kgwebsite for more courses and content 👍

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

    Great explanation sir

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

    4:25 and 9:20 and 11:00

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

    Nice explanation sir..... 🤗🤗🤗🤗

  • @asthanishad5545
    @asthanishad5545 3 роки тому +1

    Thanq sir

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

    nice and such hardworking sir

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

    Amazing teacher and amazing explanation

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

    love u sir........................so help full

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

    Very gud explanation sir keep it up

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

    Nice explanation sir👍

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

    really nice explanation

  • @MrRishi-kr9lu
    @MrRishi-kr9lu 6 років тому

    Thank you sir Bhout Mst samaj main aa ra hai

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

    Thank u so much sir for this great explanation.

  • @shivg.5011
    @shivg.5011 5 років тому

    very nice video sir ji
    apke karan mai exam me pass ho jaunga
    thank u so much

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

    Sir please upload videos on ds & algo before gate 19

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

    sir u r so nice n ur teaching methode is very good sir plz give lecture on flat .nested .workflow transection plz sir

  • @MdSajid-jw8tl
    @MdSajid-jw8tl 6 років тому

    You are great ... amazing...

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

    Thank you sir...

  • @Kabir_zehen2_7
    @Kabir_zehen2_7 5 місяців тому

    Nice explanation

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

      Glad you liked it, thank you. Keep learning, supporting & stay connected for more content👍

  • @NidhiSingh-dw7gc
    @NidhiSingh-dw7gc 7 місяців тому

    Amazing 🎉

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  7 місяців тому +1

      Thanks, Nidhi😄 Stay connected for more content & keep learning👍

    • @NidhiSingh-dw7gc
      @NidhiSingh-dw7gc 7 місяців тому

      @@KNOWLEDGEGATE_kg of course 😊

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

    Thanks so much sir😀😄🙂

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

    Sir mai ap se bahut achy tarah samajh jata hu kya baat hai ap k teaching love from Pakistan....🇵🇰

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

    amazing explanation sir.. thanx a lot sir.
    you are a super teacher.

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

    Thank u sir kya aap computer orgenization (CO) ke upar video bana sakte ho

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

    Tysm sir ji
    U have done great job for. Us

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

    Please sir some video lecturer upload topics on concurrency control techniques , two phase locking, time stamp protocol and others log recovery based system

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

    Sir how can I access your all full gate videos

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

    Durability means if we commit an operation it should be successful write on disk. my question is that if we receive commit and hard is crash than durability property is not satisfied. can you please explain whats happens?

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

      i cant say what happens but i can comment that durability is property for a transaction on a database. hdd failure dont fall under this categ...

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

    ❤ thanks sir

  • @rajivk.b8340
    @rajivk.b8340 6 років тому

    Awesome videos

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

    Sir please post video on concurrency control and its types...lock based timestamp

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

    Very good sir

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

    love you Sir

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

    Sir please coa pr lecture banaye

  • @AmanKhan-bw3rt
    @AmanKhan-bw3rt 4 роки тому

    very nice

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

    Lagta hai Bhai Ko Bhok lagi hui thi. Isliye Khane Ki Examples deen :D :D Just kidding Sir Ap ne bohat ache se concept samjhaya. Examples se e baat wazey hoti hai. Thanks.. From PAK

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

    thank you

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

    Sir please provide ur lecture in English also

  • @Pritamdas-bg7fp
    @Pritamdas-bg7fp 6 років тому +1

    thank u sir

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

    Done sir ji

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

    Nice sir

  • @SauravKumar-ht8rr
    @SauravKumar-ht8rr 6 років тому

    THANKU SIR.

  • @SonuShukla-ib8hg
    @SonuShukla-ib8hg 9 місяців тому

    Good❤❤❤❤❤❤❤

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

    gud job sir

  • @Sanjeevsingh-np8fl
    @Sanjeevsingh-np8fl 6 років тому

    well sir ji 🙏🙏

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

    Thank u so much sir,,,,,but atomicity fir ek bar explain karna chahiye tha

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

    sir please answer this question it's urgent mujhse har company me Php developer job interview me pucha ja rha h bar bar....mai answer nhi de pa rha ...jab payment gateway pe payment success ho gyi ..account se paise kat gye..aur humara web server us time down ho gya response nhi aya...to kaise handle karte h is problem ko mysql me..please answer

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

    love u sir

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

    👍🏻 Understood
    -1530/18

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

    My engineering studies simplified 🔥😅

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

    👍👍

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

    sir can u please upload these videos in English....

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

      ua-cam.com/video/LSB4eceRsw8/v-deo.html watch it

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

    Can some one tell me How Can one become like you?

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

    👍

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

    now i am more interested in railway saying after confirm ticket... are yaar bhool gaye

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

    Learn Hindi language guys...there is scope to learn a lot from these masters...

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

    Yrr...too many ads..it disturbs all the time

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

    Pls explain in English .Every one don't know Hindi write

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

    Sir please drink some water !!!😨 💁‍♂️🧊💧🌊

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

    ENGLISH SIR I am not indian

  • @ManishGupta-vl2id
    @ManishGupta-vl2id 6 років тому

    😂 jhol jhal

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

    chote say topic ko bhot long khich diya thori choti vedio banaya kro or introduction kam diya kro

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

    Thank You..

  • @NehaKumari-kc7tv
    @NehaKumari-kc7tv 2 роки тому +1

    Nice sir

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

      Thank you dear :) Keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

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

    Tq so much sir

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

    Thank you so much sir

  • @RaviSingh-yf6jd
    @RaviSingh-yf6jd 5 років тому

    Thanks sir

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

    👍👍

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

    Thanks sir g