Dirty Read Problem| problems in concurrent execution of transactions | DBMS

[@meghnade4761]

Nice explaination..the cheating example though :D

[@KNOWLEDGEGATE_kg]

hahaha.... thanks

[@abcmedia9044]

Cheating example was the easiest to remember😂😂

[@vishalpassricha2247]

first time I have understood the concept of normalization thanks sir for explain everthing very clearly. I request you please load the lectures of time stamp protocol

[@theBirdsEyeV1ew]

Well that cracked me up XD...Great example :P Concept cleared. Thank you.

[@adityanihalkumarsingh2116]

The dirty read example was very well explained.

[@SaidElnaffar]

Swell! The Cheating Example was indispensable. You should start with it from the beginning indeed!

[@peterhenry2240]

Great explanation! The cheating example was brilliant and hilarious! thanks!

[@srivatsann7193]

Extraordinary explanation.Hatsoff,especially with the cheating example

[@mohammadsaif4508]

3:11 Respected Sir . During transaction T1 failure, the T1 rollbacks. How can we say that T2 read that value which actually doesn't exist in the database then ?? As According to me , T2 read value and committed , the value read by T2 should be stored in main database because T2 was committed .

[@thezone6256]

Apka teaching methods bahut acha Hai.Sir aap humare liye ek inspiration hai.

[@Axblaim]

The example about cheating was genius! Thanks for the clear explanation

[@KNOWLEDGEGATE_kg]

You're welcome dear! Keep learning & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

[@abdullahamir6474]

once again concept cleared.. recommended video.

[@abhishekgautam3270]

Tysm sir!! This is a feedback for every single video of yours that i've watched. You are a very good teacher with a great knowledge. Indian Youth needs these types of teachers in colleges. Glad to see you on KZbin. Sir please continue to make maximum videos on different topics/subjects on KZbin..Thank You!

[@nikhilsingh6988]

Examples are at there best from your side sir ;D explaining the topics are at top

[@tugrulbayrak4469]

English subtitles would be much better. such simple things can sometimes not be understood from the books. thank you so much nice explanation!

[@nischalpatel4591]

This lectures are life saver , one week before exams.

[@RAHULMAHESHWARIdexter]

Properly explained Hats off to you!!!

[@barbhuiyaashraf6522]

cleared ma concept through ur video....thnks a lot sir :)

[@ignishaelton831]

Excellent explanations...hats off ji

[@aiswarya5848]

Very helpful vedio... You are a great teacher... Our college teachers should watch your vedios and learn how to take lectures..

[@hemanthreddy9446]

You are awesome sir.. that example though 😂😂

[@YouTubeFreaker]

I always get some extra knowledge from your videos which i could not get in my class

[@abhishek.burkule]

You are superb man "That Cheat Example Was One of the funny which will be always remembered by mi in my exam hall for my tomorrows exam"

[@VishalTiwari-cf8ix]

You are a great Teacher !

[@KNOWLEDGEGATE_kg]

Thanx :)

[@_thepassenger2674]

sir g tusi great ho. kya pdhaya h sir mazza aa gaya.

[@tusharchhabra5522]

superb explanation.. sir plz continue uploading all the transaction videos as soon as possible..

[@dattatreyapujar4068]

Sir, when the data is transferred to "Permanent Storage" from "Local Buffer" on the completion of successful transaction will the memory in the local buffer get erased??

[@tirthk164]

best video on dirty read,thank u sir... please upload rest of the videos.

[@sallashivatejateja5572]

iam inspired with ur teaching

[@namanjain8939]

Sir your examples are superb !!

[@KNOWLEDGEGATE_kg]

Thank you so much brother :)

[@tubakhalid5222]

Crisp concept clarification ❤️

[@KNOWLEDGEGATE_kg]

Thank you, glad that u liked it,t would be great if you give us a review on our app play.google.com/store/apps/details?id=in.knowledgegate.www. It will help new audience to build trust on us 😀

[@meghaverma2833]

Sir plz explain the locking protocols and time stamping also as you explain very well n I think no one can explain like u

[@chtpx9325]

level ha boss i wish to be a teacher like him in near future but wd superior knowledge

[@nirbhaymishra5975]

Sir, You are really doing great for us 🙏😊

[@praveenkumar-se5nb]

Nice explanation of the concept........

[@shivanibirajdar5906]

Beautifully explained!

[@Epic_priya]

college me aise q nae padhate ...............:(

[@amaanjk2950]

bcz cllg wale chutiya hote h😁😁

[@joshkramer9654]

Nice example 😃👍

[@gunjankumar1038]

Sir your lectures are awesome. Just i want to know the date you will complete the syllabus for gate exam

[@arushisinghonelove9394]

wow this is the 1st time i have seen such good explanation ever

[@AmitKumar-xp5gn]

nice example of dirty read sir..

[@niravbharadiya2901]

What a perfect example sir!!

[@adityasood11]

Sir , I have my DBMS Examination tomorrow morning. It would be really good if you could upload at least the remaining videos of transaction.

[@adityasood11]

No issues Sir.

[@tauseefkhan6901]

sir , one question........... after T2 commit it simply update the DB. and value is now 6. now after certain time, T1 failed and rolled back.. means it deleted the value from local buffer. . which was previously 6. and back to initial stage that is 5.but does it mean T1 deleted the value 6 from DB also which was updated by T2 ??? because u said now 6 value is no longer in DB after rolled back............ plz expian sir...

[@srisravya9901]

yes, i too have this doubt

[@SahilGupta-qc4jx]

no you cannot rollback the already commited transaction of T2.

[@amredharaj0315]

Sir the way you explain is great ... ✨ One humble request... Can you pls number the series so that it'll be useful for us to go through again... 👍

[@KNOWLEDGEGATE_kg]

Dear Amredha, please visit our website www.knowledgegate.in

[@rajanranga1881]

good example sir

[@Indian-bx7od]

sir thanks.....u r great .....your explanation is so good.....sir please provide dccn video...

[@girishdoddi7698]

@knowledgegate sir you told that in the above video transaction T2 reads the value 6 but when i see another videos or in books its given that transaction T2 reads value 5 only. can yo uclear my doubt by explaining which process is right. thankyou

[@sanubhattacharya7695]

when can a dirty read be consistent even if the first transaction encounter failure? (other than just read operation)

[@abhishek.burkule]

:-) All your Videos will be printed in words in my todays exam #thanku

[@sunnygupta5924]

very nice explanation..👍

[@pritibopche2667]

super super 1 no. thnks sir wht a example super you r best teacher

[@anuradhawithanage9861]

Great explanation

[@irfanmanzoor5450]

Very nicely elaborated!!! do you also have videos on advance data management like distributed data management, Paxos Nodes and Paxos Algorithm, Mongo DB and XML?

[@mrityunjoysen10]

Great example!!

[@deepeshgupta4270]

Respected Sir, i have a doubt, the example used in dirty read problem the two transactions (t1 and t2) are not satisfying the isolation criterion so if a transaction is not satisfying ACID property , so there is no fault in concurrency but in the transaction itself.

[@Arshdeep0171]

Example is quite relatable 😂😂

[@kishoresrinivas6322]

Wow , nice example !!!!!

[@crix_05]

Just outstanding.

[@KNOWLEDGEGATE_kg]

Thanks a lot! keep learning & supporting👍😊

[@Engineer_With_A_Life]

is there any lecture on the methods to prevent concurrency in transaction? waiting desperately

[@shivangiverma819]

Nice real life example

[@dhirajsingh9248]

Now I know how to prevent dirty read at the exam.

[@sudheertripathi3882]

Cheating example was awesome

[@rohitgird]

Awesome Explanation :)

[@divyabharti3204]

awsome explanation :)

[@anudeepkosuri1481]

Super example bro

[@amarbhadulkar8094]

nice explanation...

[@siabshafique2792]

Thankyou v.much. Your teaching style is excellent. And what an example :'D

[@shivamgupta5476]

how is it possible that local buffer of all the transaction is same . even though transaction is done from different sytesm

[@narendraparmar1631]

good one sir ji😆

[@sakshamjain4287]

Sir what is checkpoint record in DBMS

[@aku_11_11]

Sir plz make some videos on concrency protocol

[@anitathakur4590]

excellent

[@akashdhaka2922]

Sir , You should become my exam invigilator

[@gbdhal3804]

any one please help!!! Why T2 is reading a value from T1 !! rather it could read from Database directly to get the fresh copy . correct me if I am wrong!

[@roshantopno1253]

T2 is not reading values from T1. They are both reading from a temporary memory which is a copy of original data. They are not directly accessing original data.

[@gbdhal3804]

thanks

[@anirbanbagal3062]

how is the value of 5 becoming 6 at first? couldn't understand that

[@robinranabhat3125]

He said us to consider A was changed ... think Transaction-1 like this then : read(A) A = A+1 Write(A)

[@mufaddalalazher2381]

He updated the value

[@deepakbeatz7048]

awesome video

[@sumitgoyal385]

sir ap local buffer ka concept bta chuke ho kya >???? previously plz tell

[@sumitgoyal385]

ok

[@zg7860]

nice, thanks

[@KNOWLEDGEGATE_kg]

Welcome 😊

[@darshanchheda6719]

Example haha... by the way amazing explanation sir

[@sumitgoyal385]

ye new topic add hua h kya dbms me never heard of it

[@codewithovi997]

best example ,,,,

[@kapilpareek6961]

Good explanation but too slow you should be a little bit faster

[@hoorkhan3596]

But sir how solve this problem ??

[@aakashchaudhary5171]

when i have nothing i'll have "KNOWLEDGE GATE".

[@784_lalatenduparija4]

My friend copied the Dirty Read Problem from me in the test. Now I have more marks than him. xD

[@maheshchhetri6084]

saas leko bhai nice explanation

[@sumitgoyal385]

at 2:01 sir u said transaction t2 updates value 6 how t2 updated ???

[@iamrehan18]

T2 is not updating it is just reading the value which is showing now as 6

[@sumitgoyal385]

@@iamrehan18 bhai bhul gya hu 5 years phle ka comment hai hha

[@rizwanghanchi5537]

ye kya samaj nahi aaya

[@RajVerma-mc2pj]

Great

[@najeebnazir]

Snakes don't hiss or bite they just tell u the wrong answers to MCQ's !!

[@abhinavs03]

Nice example though. :p

[@abhishek-kapoor]

dont leave exam hall before your friend summit copy :)))

[@prathameshgabhane9264]

Respect

[@bealion6062]

thnkxxxxxx

[@kunalsamnani6782]

Cheating is conceptually okkk😂😂😂😂😂

[@akkiei]

3/12/2017 anyone??? exam tomorrow !! :D:D:D:D:D

[@zadfab]

Friend was cunning shit

[@saurabhgupta-nr5vr]

aapne cheating kiya that was mistake?? that is not mistake.. hahaha xd..

[@mufaddalalazher2381]

THANK YOU SO FUCKING MUCH!