6.830/6.814: Database Systems
Spring 2021
In this lecture, we will continue our discussion of concurrency control and study another approach for isolating transactions called "Optimistic Concurrency Control." Read:

As you read, note any terms you are unfamiliar with and come to class prepared to answer the following questions:

  • When would you expect that optimistic concurrency control would outperform locking-based concurrency control?
  • Can optimistic concurrency control result in deadlock?
  • How would you implement optimistic concurrency control in SimpleDB?