Lec-77: All Concurrency Problems | Dirty Read | Incorrect Summary | Lost Update | Phantom Read
Вставка
- Опубліковано 8 чер 2024
- 👉Subscribe to our new channel: / @varunainashots
0:00 - Introduction
0:22 - Dirty Read
1:29 - Incorrect Summary
2:51 - Lost Update
3:58 - Unrepeatable Read
4:35 - Phantom Read
► Database Management System(Complete Playlist):
• DBMS (Database Managem...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Structured Query Language (SQL):
• Structured Query Langu...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on UA-cam: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmashersofficial
► Follow us on Threads: www.threads.net/@gate.smashers
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: gatesmashers2018@gmail.com
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.
The dude is just not fakeing . The finishes of the goals. Beautiful. Magisterial. Love you *leapnotch!.* .🙏🏼.
BEST BEST BEST
THANKU FOR THIS AMAZING COURSE SIR❤
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
Such a good tutor, no doubt🙌
You know how to teach every type of student 😊
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.
This video is bit rushed I guess rest all previous videos I found were weel explained..
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.
Sir please make a video on generalisation and specialization..
Love from Nepal 🥰
Simply superb 💥
Your teaching style is good and fabulous when you use board and marker , that time your teaching is mush more clarity .
best lecture and best channel for study gate examination
nicely explained
Thank you sir 😊
Well sir
sir your intro is simple and awesome some channal having annoying intro and eats time ..
Sir... Ji please algorithm wali series complete kar do....🙏 Apke alawa aur kisi teacher ki padaai samaj main nhi অতি... 😢
How can I purchase ur NIELIT STQC study materials n video ??
Thank u
Sir, what is the meaning of "Read after write"?
Achy sy smj a gai topic ki thnx sir👍👍
👍🏻
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.
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.
❤
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
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
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....
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
Thank you sir but I don't know Hindi well.. please explain in English sir🙏
You can turn on video captions
💗💗💗💗💗
congrats for one million in advance sir
Sir notes ki PDF bhi dedo 🙏🙏🙏 please
Uper Google drive ka link hai
❤️❤️💕💕
Legend watch this video before 10 minutes exam 😅😅
Sir is ke notes hai kay
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"😂😂😂
It would be great if it was in English
You can turn on video captions
Aree America Ke Dalal 😂😂😂
Bechari t2😂😂😂
Explanation was not good. Take more example of it .
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!.* .🙏🏼.