The Gateway to Computer Science Excellence
0 votes
73 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 by (59 points) | 73 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.
by (101 points)
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,741 questions
57,252 answers
198,061 comments
104,696 users