I'm wondering how can lost update problem occur in an on-line auction database. as you know lost update is a problem that can be occurred when a database item accessed and updated at the same time.
Can you guys give me some real-world examples of lost update problem in a online auction database?? only in a case of online auction.
“Online auction” is offering online auction services to its clients. Customers are able to register in the system and make bids on selected products and customers could also sell products. Imagine that you are employed as a database developer by this company and your major tasks are to optimize the system to work efficiently in a multiuse environment.
To store all the data “Online auction” developed a relational database, see DB ER diagram on Fig. 1. At the beginning the database worked fine but as the service become more popular the number of customers increased and as a result increased the number of DB transactions some problems started to arise.
Provide a 2 - 3 page summary of the problems and the methods used to demonstrate the:
i. Lost Update problem
ii. Inconsistent Analysis problem