Identify one benefit and one drawback of each concurrency control strategy in an OLTP

application. Explain.</li> <li>Identify one benefit and one drawback of each concurrency control strategy in a data warehouse. Explain.</li> <li>Suggest a scenario for a hypothetical OLTP business system where optimistic concurrency control is most appropriate and another scenario where pessimistic concurrency control is most appropriate.</li> <li>How would the type of user, such as a computer program, an internal business user, or a customer on the web, affect your choices?

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"