Serializability
What determines serial execution order?
| T1 |
T2 |
comments |
| begin |
|
|
| R(A) |
|
|
| add 50 to A |
|
|
| W(A) |
|
|
| R(B) |
|
|
| add 50 to B |
|
|
| W(B) |
|
|
| commit |
|
|
|
begin |
|
|
R(A) |
T1 < T2 due to WR conflict on A
|
|
multiply A by 2 |
|
|
W(A) |
|
|
R(B) |
T1 < T2 due to WR conflict on B
|
|
multiply B by 2 |
|
|
W(B) |
|
|
commit |
|
|