In the field of relational database management systems, optimistic concurrency control (OCC) is a concurrency control method that assumes that multiple transactions can complete without affecting each other, and that therefore transactions can proceed without locking the data resources that they affect. Before committing, each transaction verifies that no other transaction has modified its data. If the check reveals conflicting modifications, the committing transaction rolls back. Optimistic concurrency control was first proposed by H.T. Kung.
OCC is generally used in environments with low data contention. When conflicts are rare, transactions can complete without the expense of managing locks and without having transactions wait for other transactions' locks to clear, leading to higher throughput than other concurrency control methods. However, if conflicts happen often, the cost of repeatedly restarting transactions hurts performance significantly; other concurrency control methods have better performance under these conditions.
Read more about Optimistic Concurrency Control: OCC Phases, Web Usage
Famous quotes containing the words optimistic and/or control:
“A man may be a pessimistic determinist before lunch and an optimistic believer in the will’s freedom after it.”
—Aldous Huxley (1894–1963)
“Not being able to control events, I control myself; and I adapt myself to them, if they do not adapt themselves to me.”
—Michel de Montaigne (1533–1592)