Principles Of Distributed Database Systems Exercise Solutions [extra Quality] May 2026

Assigning unique timestamps to transactions to ensure serializability without explicit locking. 4. Reliability and the Two-Phase Commit (2PC)

Finding the best join order and communication strategy. Local Optimization: Selecting the best local access paths. Common Exercise Scenario: WHERE City = 'New York' ).

Problem: What happens if the coordinator fails after sending a "Prepare" message but before receiving all votes? WHERE City = 'New York' ).

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: WHERE City = 'New York' ).

Dividing a relation into subsets of tuples (rows). Solutions usually involve defining selection predicates (e.g., WHERE City = 'New York' ).