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)
“Surrealism, n. Pure psychic automatism, by which it is intended to express, whether verbally or in writing, or in any other way, the real process of thought. Thought’s dictation, free from any control by the reason, independent of any aesthetic or moral preoccupation.”
—André Breton (1896–1966)