Question: Assume we have a Shared Nothing System with 4 processing nodes and we want to implement the ABJ algorithm with the following: R S where
Assume we have a Shared Nothing System with processing nodes and we want to implement the ABJ algorithm with the following:
R S where R has pages and S has pages Each relation is evenly divided among the four PNsThus each PN has pages of tuples. The Hashing Phase results in data skew as follows:
of the data in the first bucket pairs: RSRS
of the data in the second bucket pairs: RSRS
of the data in the third bucket pairs: RSRS
of the data in the fourth bucket pairs: RSRS
Calculate the read cost, write cost, and total computation cost
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
