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)
“Could it not be that just at the moment masculinity has brought us to the brink of nuclear destruction or ecological suicide, women are beginning to rise in response to the Mother’s call to save her planet and create instead the next stage of evolution? Can our revolution mean anything else than the reversion of social and economic control to Her representatives among Womankind, and the resumption of Her worship on the face of the Earth? Do we dare demand less?”
—Jane Alpert (b. 1947)