reset password
Author Message
shreyas.darwhatkar@hotmail.com
Posts: 9
Posted 10:11 Dec 07, 2015 |

Can we consider the below schedule is a valid strict 2PL example.

xl1(x),w1(x),sl2(x),r2(x),c1,c2,ul1(x),ul2(x)

vsluong4
Posts: 87
Posted 12:10 Dec 07, 2015 |
shreyas.darwhatkar@hotmail.com wrote:

Can we consider the below schedule is a valid strict 2PL example.

xl1(x),w1(x),sl2(x),r2(x),c1,c2,ul1(x),ul2(x)

xl1(x),w1(x),sl2(x),

this is not following proper locking protocol

tx1 has an EXCLUSIVE lock on x, but TX2 is requesting a lock on x

so this is not even 2PL, which is the first requirement for strict 2pl

shreyas.darwhatkar@hotmail.com
Posts: 9
Posted 12:26 Dec 07, 2015 |

xl1(x),w1(x),c1,ul1(x),sl2(x),r2(x),c2,ul2(x)

Now is it a valid example for strict 2PL

cysun
Posts: 2935
Posted 13:11 Dec 07, 2015 |
shreyas.darwhatkar@hotmail.com wrote:

xl1(x),w1(x),c1,ul1(x),sl2(x),r2(x),c2,ul2(x)

Now is it a valid example for strict 2PL

Yes.