Exercise Write-up: Principles of Distributed Database Systems
Maintaining data integrity across sites is perhaps the most difficult aspect of DDBS. Exercises often center on the (Consistency, Availability, Partition Tolerance) and the Two-Phase Commit (2PC) protocol.
Is there a way to do this with fewer bytes?
Reliability exercises often focus on what happens when a site or a link fails during a transaction. The 2PC Protocol Steps:
Both fragments contain ProjID (the join key). The global relation is reconstructed as V1 ⨝ V2 .