Question

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

          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

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

Added by Renee G.

Question

Please give Ace some feedback