Validation Tech. & Isolation Snapshot Done

Validation Tech. & Isolation Snapshot Done

1. Validation / Optimistic Concurrency Control

   • 1. READ
   • 2. VALIDATIION
     • No overlapping
       • 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.
       • Finish(F)--> Start(S)
   • 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

Bilder und Dateien der Mindmap