Question: Let relations r 1 ( A , B , C ) and r 2 ( C , D , E ) have the following properties:
Let relations rA B C and rC D E have the following properties: r has tuples, r has tuples, tuples of r fit on one block, and tuples of r fit on one block. Estimate the number of block transfers and seeks required using each of the following join strategies for r r
Consider the following assumptions:
Memory size M blocks.
For Hash join, assuming blocks bb are allocated for the input buffer and each output buffer. Number of partitions nh
You may use the following expressions to estimate required block transfers and seeks for a hash join:
a # of block transfers: br bsnh
b # of seeks: br bb bs bbnh
a Nestedloop join.
b Block nestedloop join.
c Merge join.
d Hash join.
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
