Question: 2 . ( 2 4 points ) Consider building a B + - tree to store numbers. You are given the following constraints on the
points Consider building a Btree to store numbers. You are given the following constraints on the mathrmBtree.
Each leaf node can store at most numbers
Each internal node can store at most numbers how many children maximum?
Suppose an internal node store The three children correspond to number with value strictly less than greater than or equal and strictly less than and greater than or equal to respectively.
If a node is split, and the number of items of the nodes are odd this implies one of the split nodes will have one more item than the other. In such case choose the node on the "right" containing larger numbers to be the one who get one more item.
a Suppose is inserted into the tree. This will cause node K to be split. That means a new key value need to be installed into node D What is in theory the range of the value that can be used there? Explain your answer. Notice that even though the algorithm uses a certain number, in theory there are other numbers that can be used without violating the mathrmBtree's requirements
b Fill in the key values of all nodes A to D assuming we take the largest possible value for each key value. Assume the insertion of in part a did not happen
cAgain assume part a did not happen Suppose the following numbers are inserted in order: Every time a node is split, lists the contents of all the nodes being affected. Use the following convention:
For any leaf nodes that has changes, list its content after the insertion
If a node is split, name the two new nodes by added letter A and B to it For example, if node K is split, the two new nodes should be named KA and KB Later if KB is split, then the two nodes should be named KBA and KBB etc.
If a new root is created, name the new root N If subsequently another new root is created then name it NN etc.
is inserted to node I
Node I is split. New values for IA KB
Node C is affected. New values for keys of C is fill it in yourself
is inserted to node to be continued by you
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
