Database Management System05 marksLost update problem
Show how lost update and incorrect summary problem might occur in concurrent execution of transactions.
Show how lost update and incorrect summary problem might occur in concurrent execution of transactions. [5]
The lost update problem occurs when two transactions read the same data item and then both update it, causing one transaction's update to be overwritten (lost) by the other. Let X = 100 (a bank account balance). Two transactions T1 and T2 execute concurrently: Time T1 T2 X (in DB) ---------------...