Question

In which situation is optimistic concurrency control with validation likely to perform better than locking with 2PL? Why?

Answer 1

The Optimistics method of concurrency control is based on the assumption that the conflits of the database operations are rare and it is better to let the transactions run to its completion and onle check for before they commit it is also known as validation or certification method. The optimistic method does not require locking or timestamping techniques. Instead a transaction is executed without restriction .

Situation in which concurrency control is better:

1. It is more suitable for enviornment where there are few conflicts and long transactions are low.

2. Suitable for Query database systems that requires very few update transactions