Optimistic concurrency control: Difference between revisions

Revision as of 22:31, 24 October 2003

Revision as of 14:59, 5 March 2005

Line 5:

There are three phases in OCC:

1. '''READ''': Transaction executes, reading values, writing to a private [[sandbox (security)|sandbox]].

2. '''VALIDATION''': When transaction commits, the database checks if the transaction could have possibly conflicted with any other concurrent transaction. If there is a possibility, the transaction aborts, and restarted.