Multiuser database applications
Describe the issues that arise from concurrency. What are the main concerns when multiple users have access to the same data? How does a DBMS handle these situations? What is locking? How is it resolved?
© BrainMass Inc. brainmass.com March 6, 2023, 12:49 pm ad1c9bdddfhttps://brainmass.com/computer-science/sql/multiuser-database-applications-23941
Solution Preview
---------------------------------------------------------
Multiuser database applications encounter concurrency problems whenever several users try to access or update the same data at the same time. Concurrency has to do with separate processes or users, running or operating at the same time, trying to use the same data item(s).
In a well-developed DBMS, concurrency issues are resolved by using locks. Locking can prevent one process from reading data that is being changed by another process, and it can prevent a process from changing data that is about to be changed by another concurrent process.
Locking provides the benefit of ensuring correct data, but it also makes the other concurrent applications wait to apply their changes. The application design trade-off is to carefully lock what you ...
Solution Summary
Multiuser database application problems are noted.