Principles Of Distributed Database Systems Exercise Solutions

: Compute total weighted cost for each candidate site. Use the formula: Total cost = Σ (reads_from_other_site × read_cost) + Σ (updates_from_other_site × update_cost). Choose site with lowest cost.

Profile update → eager replication (strong consistency). Like counter → lazy replication (eventual consistency). : Compute total weighted cost for each candidate site

Rewriting the calculus query into an algebraic one. Salary) with two sites:

Relation EMPLOYEE(EID, Name, Dept, Salary) with two sites: : Compute total weighted cost for each candidate site