Propose a vertical fragmentation.
Official exercise solutions for Principles of Distributed Database Systems Propose a vertical fragmentation
Compute R ⋉ S: project R.B values that appear in S.B. Assume 80% of R.B in S.B → 800 tuples. Ship R' (800 tuples) to Site2 to join with S → result RS of 400 tuples (estimated). Ship RS to Site1 to join with T: 400 ⨝ 2000 = 400 tuples final (assuming foreign key). Cost: transfer R' (800) + transfer RS (400) = 1200. but a strategy.
Elara's eyes widened. She began to see the logic. The exercise wasn't about finding a single, perfect solution; it was about understanding the trade-offs. The "answer" wasn't a formula, but a strategy. Propose a vertical fragmentation