Discussion:
2 phase commit Q
(too old to reply)
chris
2011-04-11 03:17:21 UTC
Permalink
I seem to recall it mentioned in class that 2PC guarantees global
serializability for distributed queries. Does anybody remember why that is?

Thanks

Chris
Alexander Bass
2011-04-11 04:00:58 UTC
Permalink
I believe the specific claim was that 2PC in conjunction with local
*strict* 2PL at each site guarantees global serializability. Strict 2PL
means that a transaction holds its locks until commit. This implies that
if T1 happens before T2 at site S1, there is no way that T2 can happen
before T1 at site S2. If it does, this results in a deadlock and one of the
transactions will be aborted.
Post by chris
I seem to recall it mentioned in class that 2PC guarantees global
serializability for distributed queries. Does anybody remember why that is?
Thanks
Chris
Continue reading on narkive:
Loading...