0 votes 0 votes How can 2PL protocol ( simple one ) ensure conflict serializability even though it cannot ensure freedom from deadlock ? I mean ,if a schedule is conflict serializable it has a conflict equivalent to a serial schedule and serial schedules won't have deadlocks .Right ? Databases -2phaselocking conflict-serializable transaction-and-concurrency databases + – ashunimbz asked Mar 30, 2019 ashunimbz 553 views answer comment Share Follow See 1 comment See all 1 1 comment reply prashant jha 1 commented Apr 2, 2019 reply Follow Share equivalent is same as equal?The effect is equivalent , schedules are not equal. :) 1 votes 1 votes Please log in or register to add a comment.
0 votes 0 votes Conflict equivalent to serial schedule means final result of a given non serial schedule and corresponding serial schedule will be same. Deadlock occurs while execution of transaction but if it is executed completely then result will be identical to serial schedule. tp21 answered Oct 20, 2019 tp21 comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes In 2-Phase-Locking, if you are able to avoid deadlock, then whatever schedule you get, will be Conflict Serializable. And if you run into a deadlock, then you won’t be able to come up with a Conflict Seralizable schedule. Dexter Mandark answered Jun 22, 2022 Dexter Mandark comment Share Follow See all 0 reply Please log in or register to add a comment.