Textbook Problem

123 views

Why might it take a long time to complete transactions when using an optimistic approach to concurrency control?

Program Plan Intro

Optimistic approach:

It is technique based on the assumption that the majority of database operations. This process is only checks for conflict that occurs during the validation phase.

Explanation of Solution

Reason for optimistic approach takes long time to complete transactions in concurrency control:

The optimistic approach makes the assumptions to avoid conflicts in the concurrent transactions.

• If the conflict occurs on the transaction, then the entire transaction is restarted...