Ask Question
18 October, 12:50

If relation R and relation S are both 32 pages and round-robin partition over 2 machines with 4 buffer pages each, what is the network cost (number of bytes sent over the network by any machine) for performing a sort-merge join in the worst case

+3
Answers (1)
  1. 18 October, 14:32
    0
    224

    Explanation:

    There's need for us to read the data from disk after which we now stream the data to the appropriate machine, the machine will then performs a sort-merge join between two 16page relations with 4 buffer pages.

    So, this Will be = (1 + 6) * (16 + 16) = 224 I/Os per machine.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “If relation R and relation S are both 32 pages and round-robin partition over 2 machines with 4 buffer pages each, what is the network cost ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers