[ Prev ]
2020-03-25

-- Mar 25 In-Class Exercise
(Edited: 2020-03-25)
((resource:temp.PNG|Resource Description for temp.PNG))

-- Mar 25 In-Class Exercise
Resource Description for Screen Shot 2020-03-25 at 10.23.05 PM.png
((resource:Screen Shot 2020-03-25 at 10.23.05 PM.png|Resource Description for Screen Shot 2020-03-25 at 10.23.05 PM.png))

-- Mar 25 In-Class Exercise
Trans Op Value s Value t Memory Value A Disk Value A Memory Value B Disk Value B Log Records
<START T>
I(A) 3 3 4
R(A,s) 3 3 3 4
s:=s+4 7 3 3 4
W(A,s) 7 7 3 4 <T,A,3>
FLUSH LOG 7 7 3 4
I(B) 7 7 3 4 4
R(B,t) 7 4 7 3 4 4
t:=t*s 7 28 7 3 4 4
W(B,t) 7 28 7 3 28 4 <T,B,4>
FLUSH LOG 7 28 7 3 28 4
O(A) 7 28 7 7 28 4
O(B) 7 28 7 7 28 28
<COMMIT T>
FLUSH LOG
{| |- | Trans Op || Value s || Value t || Memory Value A || Disk Value A || Memory Value B || Disk Value B || Log Records |- | || || || || || || || <START T> |- | I(A) || || || 3 || 3 || || 4 || |- | R(A,s) || 3 || || 3 || 3 || || 4 || |- | s:=s+4 || 7 || || 3 || 3 || || 4 || |- | W(A,s) || 7 || || 7 || 3 || || 4 || <T,A,3> |- | FLUSH LOG || 7 || || 7 || 3 || || 4 || |- | I(B) || 7 || || 7 || 3 || 4 || 4 || |- | R(B,t) || 7 || 4 || 7 || 3 || 4 || 4 || |- | t:=t*s || 7 || 28 || 7 || 3 || 4 || 4 || |- | W(B,t) || 7 || 28 || 7 || 3 || 28 || 4 || <T,B,4> |- | FLUSH LOG || 7 || 28 || 7 || 3 || 28 || 4 || |- | O(A) || 7 || 28 || 7 || 7 || 28 || 4 || |- | O(B) || 7 || 28 || 7 || 7 || 28 || 28 || |- | || || || || || || || <COMMIT T> |- | FLUSH LOG || || || || || || || |}
X