Answered step by step
Verified Expert Solution
Question
1 Approved Answer
5. (9 pt) Suppose that we are using a disk system where the time to move the read/write head to a block is 15 ms,
5. (9 pt) Suppose that we are using a disk system where the time to move the read/write head to a block is 15 ms, and the time for a block transfer is 0.4 ms. Suppose we want to compute a two-pass hash-join of R with S, and we have that B(R)=1000, B(S)=500, and M=101. To speed up the join, we want to use as few buckets as possible (assuming tuples distribute evenly among buckets), and read and write as many blocks as we can to consecutive positions on the disk. Answer the following questions: a) (1 pt) How many disk I/O's are required to perform this join operation? b) (5 pt) How long would it take to perform this operation if we use hybrid hash-join (as described in Example 15.9)? c) (3 pt) How long does a sort-based join take under the same conditions, assuming we write sorted sublists to consecutive blocks in disk
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started