Question: Consider relations R ( a , b , c ) , S ( a , d ) , and T ( a , e ,
Consider relations Ra b c Sa d and Ta e f to be joined on the common attribute a Assume that there are no indexes available on the tables.
There are B pages in the buffer
R spans M pages with tuples per page
S spans N pages with tuples per page
T spans O pages with tuples per page
In computing the IO cost you can assume the simplest cost model where pages are read and written one at a time. You can also assume that you will need one buffer block to hold the evolving output block and one input block to hold the current input block of the inner relation. You may ignore the cost of the writing of the final results.
Compute the IO cost of the block nested loop join with S as the outer relation and R as the inner relation.
Question options:
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
