Suppose you have a relation r with n r tuples on which a secondary B + -tree
Question:
Suppose you have a relation r with nr tuples on which a secondary B+-tree is to be constructed.
a. Give a formula for the cost of building the B+-tree index by inserting on record at a time. Assume each block will hold an average of f entries and that all levels of the tree above the leaf are in memory.
b. Assuming random disk access takes 10 milliseconds, what is the cost of index construction on a relation with 10 million records?
c. Write pseudocode for bottom-up construction of a B+-tree, which was outlined. You can assume that a function to efficiently sort a large file is available.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Database System Concepts
ISBN: 9780078022159
7th Edition
Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan
Question Posted: