Validation Tech. & Snapshot Isolation Concurrency Control

Validation Tech. & Snapshot Isolation Concurrency Control

1. Validation / Optimistic Concurrency Control

   • 1. READ
   • 2. VALIDATIION
     • No overlapping
       • Finish(f) --> Start(S)
       • If Overlapping
         • NO overlapping of Same Data
         • First Tr. must complete WRITE before Second Tr. enters into validation
           • WritePh(F) 'C' || 'E' Val.Ph(S)
             • Passes First Tr.
   • WRITE

2. Snapshot Isolation

   • Shows Only Comm. Trans.
   • X
     • Dirty Problem
     • Avoid Non-repeatable read
   • Better than 2PL
     • No READ Lock
     • Only WRITE LOCK
   • Examples

Images and files in the map