Question: Question 2 ( 5 points ) Assume that initially ( mathrm { A } = 5 ) and ( mathrm

Question 2(5 points)
Assume that initially \(\mathrm{A}=5\) and \(\mathrm{B}=10\) are values on hard disk. The following is a transaction T1 of user program on A and B (-> denotes assignment, ';' gives order of operations):
T1: A+B -> A; A+B -> B
T1 generates the following actions (read/write/output) to the database:
T1: Read(A, t); Read(B, u); t+u -> t; Write(A, t); t+u -> u; Write(B, u); Output(A); Output(B);
and the following undo/redo log records:
; ; ;
For the following transaction T3,
T3: B+1-> A; A+1-> B
1. Add necessary read/write/output actions to the computation;
2. Show the undo/redo log records it generates.
Question 2 ( 5 points ) Assume that initially \ (

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!