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 4processing nodes and we want to implement the ABJ algorithm with the following:
R S where R has 4,000pages and S has 8,000pages. Each relation is evenly divided among the four PNs.Thus, each PN has 3,000pages of tuples. The Hashing Phase results in data skew as follows:
1)30%of the data in the first 8bucket pairs: R0/S0-R7/S7
2)20%of the data in the second 8bucket pairs: R8/S8-R15/S15
3)10%of the data in the third 8bucket pairs: R16/S16-R23/S23
4)10%of the data in the fourth 8bucket pairs: R24/S24-R31/S31
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 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!