Optimistic concurrency control: Difference between revisions

Revision as of 11:55, 14 February 2007

Revision as of 09:17, 9 May 2007

Line 1:

{{Unreferenced|date=February 2007}}

In [[computer science]], in the field of [[database]]s, '''optimistic concurrency control''', (OCC) is a [[concurrency control]] method used in [[relational database]]s without using [[Lock (computer science)|lock]]ing. It is commonly referred to as '''optimistic locking''', a misnomerreference to the non-exclusive locks that are created on the database.

Optimistic concurrency control is based on the assumption that most [[database transaction]]s don't conflict with other transactions, allowing OCC to be as permissive as possible in allowing transactions to execute.