LSN
LOG
Exercise 7. Answer the following questions considering the log records
in Figure 1. In each case, justify your answer.
10
Update: T? writes P1
1. Assuming that locking is applied for pages, does strict 2PL allow
the schedule in these log records? (10 marks)
20
Update: T? writes P1
30
T? commit
2. Which transaction is a loser transaction? (5 marks)
40
T? end
3. Can ARIES recover the database from this crash while preserving
the ACID properties? If the answer is no, which ACID property
can not be guaranteed? (10 marks)
50
Update: T3 writes P2
60
Update: T3 writes P?
CRASH, RESTART
Figure 1: The log records in Ex. 7