search
Log In
0 votes
140 views
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 ?
in Databases 140 views
1
equivalent is same as equal?The effect is equivalent , schedules are not equal. :)

1 Answer

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.

Related questions

0 votes
0 answers
1
128 views
Can someone explain how transactions can be serialized in order of their lock points (the point where the transactions acquire their final lock)?
asked Sep 3, 2018 in Databases Parimal Paritosh 128 views
1 vote
2 answers
2
531 views
how 2PL is allowed?
asked Jan 19, 2017 in Databases Supremo 531 views
0 votes
0 answers
4
668 views
is conservative 2PL is recoverable schedule ?
asked Nov 6, 2018 in Databases Gurdeep Saini 668 views
...