7.9- Inconsistent Analysis Problem In DBMS | Need Of Concurrency Control in DBMS | Complete Syllabus
7.9- Inconsistent Analysis Problem In DBMS | Need Of Concurrency Control in DBMS | Complete Syllabus
Notes Link:
http://www.tutorialsspace.com/Downloa...
Complete Playlist:
(Eng) DBMS Tutorials | Sql Tutorials | RDBMS Lectures
• (Eng) DBMS Tutorials | Sql Tutorials ...
DBMS - Data Base Management System Tutorials
• DBMS Complete Syllabus- All Universit...
[With Notes & PDF File] | Database Management System In HINDI
• [With Notes & PDF File] | Database Ma...
transaction in dbms, transaction management system in dbms, dbms ugc net lectures,
dbms gate lectures,
unrepeatable read problem in dbms, unrepeatable read problem in transaction, need of concurrency control in dbms, concurrency control in dbms,
why concurrency control in dbms, dirty read problem in dbms, dirty read problem in transaction, phantom read problem in dbms, phantom read problem, inconsistent analysis problem in dbms, lost update problem in dbms
#dbms #gatedbms #ugcnetdbms #gatedbmslectures #ugcnetdbmslectures #dbmsLectures #dbmsTutorials
#dbmsTutorials
Social Links
Twitter Account: / tutorialsspace
FaceBook Page: / tutorialsspace
Instagram : / tutorialsspace
Telegram Channel: https://t.me/TutorialsSpace
Telegram Group: t.me/TutorialsSpace
Pin-Interst: / tutorialsspace
youtube: / tutorialsspace
The Inconsistent Analysis Problem
Consider the transactions shown in Figure 8.5.
Transaction Ti Time Tansaction Tj
— —
read(a) a = 10 t
1 —
read(b) b = 20 t
2 —
— — — t
3 write(a) a = 50
— — — t
4 Commit
— — Add a, b t
5
a + b = 30, not 60
—
FIGURE 8.5. The inconsistent analysis problem.
352 Introduction to Database Management System
The transaction Ti reads variable a and b at time t1 and t2 respectively. But at time t3,
Tj
updates value of a from 10 to 50 and commits at t4 that makes changes permanent. So,
addition of a and b at time t5 gives wrong result. This leads inconsistency in database because
of inconsistent analysis by Ti
.