(iii)Inconsistent analysis anomaly – The problem of inconsistent analysis occurs when a transac-
tion reads several values from the database but a second transaction updates some of them
during the execution of the fi rst.
Example 8.3
Let us consider the example of a banking system in which two transactions T3 and T4 are accessing the
database concurrently. The transaction T3 is calculating the average balance of all customers of a particular
branch while the transaction T4 is depositing $1,000 into one customer account with balance bal
x
at the
same time. Hence, the average balance calculated by the transaction ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.