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.
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.
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.
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.
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
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....
The dude is just not fakeing . The finishes of the goals. Beautiful. Magisterial. Love you *leapnotch!.* .🙏🏼.
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.
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..
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.
In lost update I don't thing there was anything related to "likes". It was all about "quantity".
Yes it's just that the quantity is loss when it's 6
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.
yrr sahi hai yrrr thanks foe explanation
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.
You know how to teach every type of student 😊
Sir please make a video on generalisation and specialization..
Love from Nepal 🥰
Your teaching style is good and fabulous when you use board and marker , that time your teaching is mush more clarity .
Such a good tutor, no doubt🙌
Sir... Ji please algorithm wali series complete kar do....🙏 Apke alawa aur kisi teacher ki padaai samaj main nhi অতি... 😢
best lecture and best channel for study gate examination
sir your intro is simple and awesome some channal having annoying intro and eats time ..
BEST BEST BEST
THANKU FOR THIS AMAZING COURSE SIR❤
Simply superb 💥
This video is bit rushed I guess rest all previous videos I found were weel explained..
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.
Achy sy smj a gai topic ki thnx sir👍👍
Thank you sir 😊
nicely explained
You told that without commit the changes won't be made then how is A = 50 without commit 0:37?
Same doubt
whether to read old value or changed value, this is the conflict which occur in dirty read
congrats for one million in advance sir
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
Mera bhi yhi doubt h
How can I purchase ur NIELIT STQC study materials n video ??
Thank you sir but I don't know Hindi well.. please explain in English sir🙏
You can turn on video captions
Sir, what is the meaning of "Read after write"?
3:12 quantity
chaa gye guru ji
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.
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
Well sir
Sir notes ki PDF bhi dedo 🙏🙏🙏 please
Uper Google drive ka link hai
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....
Legend watch this video before 10 minutes exam 😅😅
Thank u
Sir is ke notes hai kay
It would be great if it was in English
You can turn on video captions
Aree America Ke Dalal 😂😂😂
Hindi is good
Is video me ek do kamiyan thi dada
👍🏻
There are problems in this video and also required more detail else it can lead to misguide.
"Bichari T2"😂😂😂
Explanation was not good. Take more example of it .
💗💗💗💗💗
❤️❤️💕💕
Bechari t2😂😂😂
Sir if u able to speak in English...then explain in English sir
Abee angreez ki aulaad hindi sikh
Sir plz teach in English .....😭
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.
You can turn on video captions
Ja pehle Hindi sikh ke aa.......#angrej
Ro kyu rha h fir
North Indian mai Convert Ho Ja
Why Is My Ear Bleeding? Such an accent 🤦🏻♂
dont watch, nobody asked you to.
The dude is just not fakeing . The finishes of the goals. Beautiful. Magisterial. Love you *leapnotch!.* .🙏🏼.