Principles Of Distributed Database Systems Exercise Solutions Review

She reached for the physical, dog-eared copy of the Grimoire. Inside, a handwritten note from Professor Tanaka said: "The exercise is never the storm. The exercise is learning how to patch the hull while the storm is still raging."

Consider a distributed database system that stores information about customers and orders. The database is fragmented and replicated across multiple sites. Describe how the system provides transparency. She reached for the physical, dog-eared copy of the Grimoire

Coordinator C, Participants P1, P2. All vote YES. Coordinator sends COMMIT, fails after writing COMMIT log but before sending to P2. P1 receives COMMIT, P2 still in READY state. The database is fragmented and replicated across multiple

| Topic | Core Principle | Classic Pitfall | |-------|----------------|------------------| | Fragmentation | Horizontal: predicates; Vertical: key preservation | Lossless join not ensured | | Query optimization | Semi-join reduction before full join | Ignoring transmission cost | | Concurrency control | Distributed 2PL + deadlock detection | Circular wait across sites | | Commit | 2PC: prepare → commit | Blocking if coordinator crashes | | Replication | Read/write quorums: R+W > N | Underestimating quorum intersection | All vote YES

: If you are an instructor, you can often request these materials directly from the publisher or through the University of Waterloo CS faculty portal . Publicly Accessible Solution Samples