Question

What are the advantages and disadvantages of using certify locks

Answer 1

$\mathfrak{\huge{\red{\underline{\underline{Question}}}}}$

What are the advantages and disadvantages of using certify locks ?

$\mathfrak{\huge{\red{\underline{\underline{Answer}}}}}$

• Certifying writes, a certify lock cl(x) is set prior to finalizing the transaction, in parallel, on every data item x modified by the transaction (lock promotions) in order to ensure that no active transaction with repeatable read isolation or higher is currently reading the current value of records.