What are the anomalies occur due to interleaved execution (concurrent transactions)
Answers
Some Anomalies Associated with Interleaved Execution(DBMS) preserving, committed transactions could run against a consistent database and leaveit in an inconsistent state. Two actions on the same data object conflict if at leastone of them is a write.
I hope this will help you
If yes then please follow me
Answer: there are 4 types of anomalies 1. lost update problem 2. temporary update problem 3.incorrect summary problem 4. unpredictable read problem
Explanation:
1. lost update- value form one transaction is over written
2. temporary update problem - This problem occurs when one
transaction updates a database item and then the transaction fails for some reason, Meanwhile, the updated item is accessed (read) by another transaction before it is changed back
3. incorrect summary problem - error during aggregation
4. unpredictable read problem - same transaction read a value differently at same time