transaction.md

transaction manger consists of

1. concurrency control protocol -strict 2pl (different from 2pc - 2 phase commit) with deadlock detection
2. ARIES recovery manger handles durability and atomicity of transactions, recovery of database from failed state

resources that helped me:

aries simulator

aries paper

deadlock detection, prevention

2pl wikipedia

alternate to 2pl, optimistic concurrency control protocol called MVCC

CS-186 Transactions and Concurrency II Lecture 19

concurrency control protocols, isolation levels,.. general concepts related to transactions

todo:

1. the 2pl protocol locks the pages for all transactions. Need to introduce granular locks for rows
2. implement undo function in Aries
3. in logrecord get XOR of prev, next. use the result to get prev, next