What is concurrency? What are the problems due to concurrency? How the problems can be avoided, explain for one of the three problems.[D
Answers
Answered by
2
Answer:
Concurrency problems occur when multiple transactions execute concurrently in an uncontrolled manner. Dirty Read Problem, Unrepeatable Read Problem, Lost Update Problem, Phantom read Problem are the concurrency problems in DBMS.
Answered by
1
Answer:
Concurrency Control Problems
Concurrency control is important because the simultaneous execution of transactions over a shared database can create several data integrity and consistency problems. The three main problems are lost updates, uncommitted data, and inconsistent retrievals.
Similar questions