When an optimistic approach to concurrency management is employed, transactions frequently require a considerable amount of time to conclude. Explain?

When an optimistic approach to concurrency control is utilised, transactions can take an extremely lengthy time to complete. Explain.

Transaction management deals with the problems of always keeping the database in a consistent state even when concurrent accesses and failures occur. Isolation requires that each transaction sees a consistent database at all times and that an executing transaction cannot reveal its results to other concurrent transactions before its commitment. ANSWER If two concurrent transactions access a data item that is being updated by one of them, it is not possible to guarantee that the second will read the correct value. Dirty reads and nonrepeatable reads may occur when one transaction can see intermediate results of another transaction before it has been committed.. Given below are two concurrent transactions T1 and T2 whose balances of amount x (balx) were recorded at times t, between t₁ and tg. As shown in the table below: If these two transactions interfere with each other, fill in the table below by selecting from the drop down list the values of balance X (bal,) at specified times…

When an optimistic approach to concurrency management is used, it is typical for transactions to take a long time to complete. Explain?