Question: Consider a database system replicated over sites in Pitt, NYC, Chicago, Washington, Philadelphia. Assume that the database system stores the following relation: Employee(eid, ename, dep_id,
Consider a database system replicated over sites in Pitt, NYC, Chicago, Washington, Philadelphia. Assume that the database system stores the following relation: Employee(eid, ename, dep_id, sal) Consider the following query: update Employee set salary = salary* 1.17; Consider also the following lock settings: Lock Pitt, Washington and NYC Lock Pitt and Philadelphia Lock Pitt and Washington Finally, consider the following four options for lock management: majority protocol; biases protocol; quorum consensus protocol; no replication. For quorum consensus protocol assume the following parameters: weights: Pitt = 2, NYC = 2, Washington = 3, Chicago = 1, Philadelphia = 2, Qr = 6, Qw = 7. For each of the lock management options indicate if it is possible for given lock setting. Your answers should be represented in the following table (each answer should be either "yeas", or "no")
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
