Embed presentation















This document discusses optimistic concurrency control, which is a concurrency control method that assumes transactions can frequently complete without interfering with each other. It operates by allowing transactions to access data without locking and validating for conflicts before committing. The validation checks if other transactions have read or written the same data. If a conflict is found, the transaction rolls back and restarts. The document outlines the basic algorithm, phases of transactions (read, validation, write), and advantages like low read wait time and easy recovery from deadlocks and disadvantages like potential for starvation and wasted resources if long transactions abort.
Introduction to Optimistic Concurrency Control (OCC) by Mridul K. Mishra.
OCC is a method for handling conflicts in multi-user systems, allowing transactions to operate without locks while checking for interference before committing.
OCC is suited for large systems with minimal conflicting operations and tolerable temporary inconsistencies.
OCC reduces the complexity of locks and mitigates potential conflicts in a transaction.
Developed by Kung and Robinson, OCC operates under the assumption of low conflict probability, minimizing resource lock time.
Details of OCC's three phases: Read Phase (unrestricted), Validation Phase (integrity check), and Write Phase (global updates).
Read operations are immediate; write operations are tentative until validation. Upon validation, writes become global.
Strong validation checks for integrity, crucial for long transactions, using a method to avoid deadlocks.
Describes validation rules to ensure transaction isolation among concurrent processes.
Advantages include low wait times for read resources, easy deadlock recovery, and maintaining consistency in read-write transactions.
Disadvantages include potential process starvation, resource wastage during long transaction aborts, and concurrency limitations with writes.
Cites sources such as Google and Wikipedia.
Final thank you note from the presenter.














