[Announcements | Schedule and Readings | Assignments and Quizzes | Syllabus/Policies ]

Reading Questions, Lecture 14 (10/27)

Papers: Optimistic Concurrency Control, Concurrency Control Performance Modeling

These papers present an alternative method of concurrency control and evaluate its performance versus locking-based concurrency control.

As you read the papers, consider the following questions:

  1. Under what circumstances is optimistic concurrency control preferred to locking-based concurrency control? Under what circumstances would locking be preferred?
  2. How does optimistic concurrency control prevent transactions from making use of data dirtied by other transactions?

Samuel Madden (madden at csail dot mit dot edu)
Last modified: Fri Oct 15 22:29:13 EDT 2004