Concurrency Control and Recovery                

Topic

Link to slides

Textbook chapters (3rd edition) Suggested practice problems Read  on your own
 (included for test)

 supplementary Reading

(NOT included for test)

Tx Management

CC1.pdf  10/30/2023

chap 16

16.2, 16.3, 16.5, 16.6,

 

chap2.pdf

Serializability

 CC2.pdf

chap 17

17.2, 17.4, 17.5,

 

Haerder.pdf

CC on Index structures

indexLock.pdf (read on your own)

chap 17.5 17.10, 17.11 yes lehman.pdf

Recovery/Aries

recovery.pdf

chap 18 18.2, 18.3, 18.4, 18.6, 18.7   Aries.pdf
what is included for Test II test 2 details   Useful if you solve above problems    

 

Back to course homepage