Question: AS Problem 3.8 (**). Assume the following view definition CREATE VIEW EMPVIEW (ENO, ENAME, PNO, RESP) SELECT EMP.ENO, EMP.ENAME, ASG.PNO, ASG. RESP FROM EMP, ASG

AS Problem 3.8 (**). Assume the following view definition CREATE VIEW EMPVIEW (ENO, ENAME, PNO, RESP) SELECT EMP.ENO, EMP.ENAME, ASG.PNO, ASG. RESP FROM EMP, ASG WHERE EMP.ENO-ASG.ENO AND DUR-24 is accessed by application q, located at sites 1 and 2, with frequencies 10 and 20, respectively. Let us further assume that there is another query 92 defined as SELECT ENO, DUR FROM ASG which is run at sites 2 and 3 with frequencies 20 and 10, respectively. Based on the above information, construct the use(9,A;) matrix for the attributes of both relations EMP and ASG. Also construct the affinity matrix containing all attributes of EMP and ASG. Finally, transform the affinity matrix so that it could be used to split the relation into two vertical fragments using heuristics or BEA
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
