Concurrency Control

Select a business scenario involving a multiuser database. Do not repeat an example from the textbook or one that has been posted by another student. Please respond to the following in not more than 250 words:

  • ·        Identify its concurrency needs.
  • ·        Demonstrate which concurrency control mechanism is the best choice in this scenario.

Then, in separate posts, follow up to one or more of your fellow students in substantive posts of up to 200 words that further the discussion. For example, you may support or politely challenge a post with your own insights or experience, make a suggestion, or ask probing follow-up questions.

 

Week 7 Discussion 2

Optimization for Transactional Processing

Suppose you are the administrator for a database than has been running for several months. Lately, the performance seems to be declining. Please respond to the following in not more than 200 words:

  • ·        Outline which database statistics you would use to identify the bottlenecks.
  • ·        Provide a real-world example that illustrates your thinking. Do not repeat an example from the textbook or one that has been posted by another student.

 

Then, in separate posts, follow up to one or more of your fellow students in substantive posts of up to 150 words that further the discussion. For example, you may support or politely challenge a post with your own insights or experience, make a suggestion, or ask probing follow-up questions.