Question: Consider a disk with a block size of 2 0 0 0 bytes, block transfer time of 0 . 5 milliseconds, average rotational delay of
Consider a disk with a block size of bytes, block transfer time of milliseconds, average rotational delay of milliseconds, and average seek time of milliseconds. Suppose that a file containing records of bytes each is to be stored on such disk and that no record is allowed to span two blocks.
a Compute number of passes, number of disk accesses, and time in milliseconds required to sort this file using general external merge sort without any improvement algorithm assumingthat buffer pages are available in the memory.
b Assume that an unclustered B tree index using Alternative is constructed on the file. In this index, you can assume that the key field and address pair occupy bytes for each record, and each leaf node is full. Only the leaf nodes and the file are stored on disk. Compute time required for sorting the file by using the unclustered B tree index.
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
