reset password
Author Message
ashasabeer
Posts: 55
Posted 12:50 Dec 02, 2010 |

 After we apply 2PL to a  serializable schedule and found that it will end up in deadlock. Can we say that the schedule is serializable but not 2PL?

 

Thanks

Asha

cysun
Posts: 2935
Posted 14:44 Dec 02, 2010 |

Yes.

ptran6
Posts: 25
Posted 16:22 Dec 07, 2010 |

Dr. Sun, is the following statement correct?

A schedule is 2PL if and only if the schedule does not deadlock when we apply 2PL locks to the schedule.

cysun
Posts: 2935
Posted 16:27 Dec 07, 2010 |
ptran6 wrote:

Dr. Sun, is the following statement correct?

A schedule is 2PL if and only if the schedule does not deadlock when we apply 2PL locks to the schedule.

Yes.