Principles Of Distributed Database Systems Exercise Solutions May 2026

Data isn't unnecessarily duplicated (unless specifically replicated for availability).

Dividing a relation into subsets of attributes (columns). Solutions focus on grouping attributes frequently accessed together, often using an Attribute Affinity Matrix . Common Exercise Scenario:

Managing "lock" and "unlock" phases across multiple nodes. Solutions often deal with Global Deadlock Detection , where a cycle exists in the Wait-For-Graph across different sites. Locking and Timestamping Good for clusters but suffers

Ensuring consistency when multiple users access data across sites requires sophisticated locking and ordering mechanisms. Locking and Timestamping

Good for clusters but suffers from communication overhead. Locking and Timestamping Good for clusters but suffers

Problem: What happens if the coordinator fails after sending a "Prepare" message but before receiving all votes?

Mastering the Core: Principles of Distributed Database Systems Exercise Solutions Locking and Timestamping Good for clusters but suffers

Query processing solutions typically follow a four-step process: