Week 7 Discussion 1

 “Concurrency Control” Please respond to the following:

• There  are times when a database is accessed by many users across the  enterprise.  Transaction logs can help maintain concurrency in a  multiuser platform. Describe at least two business scenarios where  COMMIT and ROLLBACK would be required. Describe how these functions  would be essential for business continuity and concurrency control.  Identify how these functions would enable an organization to recover  from a database corruption event. 
• Describe how locks could be  used in order to qualify data transactions and enhance concurrency  control. Suggest at least two business scenarios that would benefit from  implementing locking methods.