What is optimistic concurrency control?In optimistic concurrency control, locks are granted without performing conflict checks. In this, a track of files which have been read or written is maintained.
While committing, files are checked to see if they have been changed in the transaction. Transactions are aborted if they are changed otherwise they are committed. Optimistic concurrency control works on the assumption that conflicts usually don’t occur. However, in situations of heavy load, the probability of failure may go up making this approach a poor choice.
What is optimistic concurrency control? Optimistic concurrency control is one of the methods that is used in relational databases without using the locking concept. It is referred as optimistic locking, which is a reference to the locks which are non-exclusive locks. This concept is based on an assumption where database do not conflict with other transactions. This is suitable for handling low contention for data.