Lec-77: All Concurrency Problems | Dirty Read | Incorrect Summary | Lost Update | Phantom Read

[@fannyjacob8535]

The dude is just not fakeing . The finishes of the goals. Beautiful. Magisterial. Love you *leapnotch!.* .🙏🏼.

[@user-gl7wp7wg2v]

00:07 Concurrency can lead to problems in parallel schedules 00:39 In case of transaction failure, rollback the invalid value to prevent errors. 01:16 Incorrect summary problem 01:57 A value was found to be 950 and B value increased by 50 resulting in 1050 02:35 Incorrect summary problem occurs when transactions with aggregate functions are interrupted 03:16 Product with id 1 received 10 likes 03:51 Multiple reads of the same value from a database 04:25 Explanation of phantom read Crafted by Merlin AI.

[@parthsalat]

In lost update I don't thing there was anything related to "likes". It was all about "quantity".

[@ManjuBala-wd8hf]

Yes it's just that the quantity is loss when it's 6

[@manishojha9398]

Great explaination ..One of the finest teacher ever seen. Thank you for all the efforts you made for us. You are really a gem for us..

[@gatesmashersyoutube2681]

Thanks for your comment, will introduce you to something quite different and profitable. W. H. A. -SA-AP +1. = 2. = 1.= 0. =8=. 0. =6. =3. 0. =9. {9.

[@mohitbhalaria2079]

This video is bit rushed I guess rest all previous videos I found were weel explained..

[@raajm4673]

U r great sir ji Sir ji KV computer teacher ke liye alg se series banao plz sir .. Agar paid video lectures ho to bhi bahut badhiya h ji . Thank u so much for these free online videos.

[@SP-bl7or]

Concurrency problems include dirty read, incorrect summary, lost update, and phantom read, which occur when multiple transactions work on the same data simultaneously, leading to inconsistent or lost data. Key moments: 00:10 Concurrency in database transactions can lead to issues like dirty reads, incorrect summaries, and lost updates, impacting data integrity and consistency. -Dirty reads occur when one transaction reads uncommitted changes made by another transaction, potentially leading to incorrect data processing. -Incorrect summaries happen when aggregate functions are performed on incomplete or outdated data, resulting in inaccurate calculations and outcomes. -Lost updates occur when multiple transactions try to update the same data simultaneously, leading to inconsistencies and data loss. 03:49 The video discusses the concept of lost update and unrepeatable read in database transactions, highlighting how conflicting changes can lead to data inconsistencies and phantom reads. -Lost update scenario occurs when one transaction overwrites changes made by another, resulting in data loss and inconsistencies. -Unrepeatable read happens when a transaction reads data that has been modified by another transaction in between reads, causing inconsistent results. -Phantom read refers to a situation where a transaction reads data that fits a certain condition, but the data disappears due to another transaction's actions.

[@November17th]

Sir please make a video on generalisation and specialization.. Love from Nepal 🥰

[@xe-non3511]

Your teaching style is good and fabulous when you use board and marker , that time your teaching is mush more clarity .

[@anzeratfatima1998]

You know how to teach every type of student 😊

[@tubafaryal8980]

Such a good tutor, no doubt🙌

[@soumisamanta8495]

Sir... Ji please algorithm wali series complete kar do....🙏 Apke alawa aur kisi teacher ki padaai samaj main nhi অতি... 😢

[@divyakeshri2831]

BEST BEST BEST THANKU FOR THIS AMAZING COURSE SIR❤

[@shashanksharma7747]

best lecture and best channel for study gate examination

[@varshaelf]

Thank you sir 😊

[@m.shazainkhan33]

Achy sy smj a gai topic ki thnx sir👍👍

[@PythonisLove]

nicely explained

[@rudradhamecha]

even if the transaction T1 doesen't fail in the example of a Dirty read Then it would be an example of an incorrect summary

[@sanatani_aesthetic]

Mera bhi yhi doubt h

[@harsh4358]

sir your intro is simple and awesome some channal having annoying intro and eats time ..

[@ramagirinavyasree]

Simply superb 💥

[@anishali8042]

You told that without commit the changes won't be made then how is A = 50 without commit 0:37?

[@vivekthakur6686]

Same doubt

[@ranjita2022]

whether to read old value or changed value, this is the conflict which occur in dirty read

[@abhijeetpanchal9881]

00:08 Concurrent problems include dirty read, incorrect summary, lost update, and phantom read. 00:41 Concurrency problems lead to incorrect data updates. 01:18 Concurrency problems include dirty read, incorrect summary, lost update, and phantom read. 01:59 Demonstrating Concurrency Problems with Dirty Read and Lost Update 02:38 Concurrency problems include dirty read, incorrect summary, lost update, and phantom read. 03:17 Concurrency problems can lead to incorrect data updates 03:49 Concurrency issues - Dirty Read, Incorrect Summary, Lost Update, Phantom Read 04:25 Concurrency problems and phantom read Crafted by Merlin AI.

[@m.kalpana3391]

Thank you sir but I don't know Hindi well.. please explain in English sir🙏

[@parthsalat]

You can turn on video captions

[@parthsalat]

Sir, what is the meaning of "Read after write"?

[@Rohitkumar-jz9ff]

congrats for one million in advance sir

[@madhusen4561]

How can I purchase ur NIELIT STQC study materials n video ??

[@utkarshsingh245]

you have not explained phantome tuple nad enrepeated read at all just displayed maybe its usefull in your goal(gate) but in college exams they ask about it its in our portion and in detail

[@VikasSharma-nx5go]

Sir notes ki PDF bhi dedo 🙏🙏🙏 please

[@amitbehera9913]

Uper Google drive ka link hai

[@jagdishpatil8680]

Thank u

[@ajitpalsingh606]

3:12 quantity

[@utkarshtripathi2349]

chaa gye guru ji

[@gatesmashersyoutube2681]

Thanks for your comment, will introduce you to something quite different and profitable. W. H. A. -SA-AP +1. = 2. = 1.= 0. =8=. 0. =6. =3. 0. =9. {9.

[@sapco12]

Well sir

[@kakalidas4506]

Sir please solve me one question.. IGNOU may ak 3rd semester may questions ayahey DBMS ke concurrency schedule ke upar o wala question please solve kardengi... IGNOU (BCA);MCS:023......year:(feb2021)Q1:d...... please solve this problem....

[@harshitmimrot9131]

Is video me ek do kamiyan thi dada

[@tusharchavan4723]

Legend watch this video before 10 minutes exam 😅😅

[@AmirMolaeiMusic]

It would be great if it was in English

[@parthsalat]

You can turn on video captions

[@iconicchandu21]

Aree America Ke Dalal 😂😂😂

[@monucutez]

Hindi is good

[@farrukhahmedsid]

There are problems in this video and also required more detail else it can lead to misguide.

[@KhushiSharma-vt2gb]

👍🏻

[@prityjain543]

Sir is ke notes hai kay

[@tubafaryal8980]

"Bichari T2"😂😂😂

[@souravbhagat1358]

Explanation was not good. Take more example of it .

[@KeerthipriyaTalluri]

Sir plz teach in English .....😭

[@gatesmashersyoutube2681]

Thanks for your comment, will introduce you to something quite different and profitable. W. H. A. -SA-AP +1. = 2. = 1.= 0. =8=. 0. =6. =3. 0. =9. {9.

[@parthsalat]

You can turn on video captions

[@sagarbhatt5489]

Ja pehle Hindi sikh ke aa.......#angrej

[@amantyagi4653]

Ro kyu rha h fir

[@parthborad5415]

North Indian mai Convert Ho Ja

[@Rehan_kashmari_7]

💗💗💗💗💗

[@Good-tz8ep]

❤️❤️💕💕

[@jamalahmed5466]

Bechari t2😂😂😂

[@maddineniamaranath5104]

Sir if u able to speak in English...then explain in English sir

[@TheUnkn0wn01]

Abee angreez ki aulaad hindi sikh

[@hellknight6299]

Why Is My Ear Bleeding? Such an accent 🤦🏻‍♂

[@bree9895]

dont watch, nobody asked you to.

[@fannyjacob8535]

The dude is just not fakeing . The finishes of the goals. Beautiful. Magisterial. Love you *leapnotch!.* .🙏🏼.