|
What are the differences between lost updates and uncommitted dependencies?Lost updates
Last update overwrites other updates
Cannot report on data that does not exist.
Data is lost
Uncommitted dependencies
Access a row being updated by others.
May report on data that does not exist
Updates are lostWhat are the differences between lost updates and uncommitted dependencies? In lost update, the data is lost. Here, the last update overwrites updates made by other transactions. On the other hand, in uncommitted dependency data is changed by other transactions. So, a transaction reads data of another transaction which has not been committed yet.What are the difference between lost updates and uncommitted dependencies?Lost updates results in loss of data. It is a write operation. Uncommitted dependency reads data that has not been committed yet.
|
