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,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!