Unformatted text preview: nts contains k1 keys. A leaf page contains at least m / 2  1 keys and no more than m 1 keys.) Index set: indexed keys as separators stored in internal nodes Sequence set: all indexed keys stored in sequence nodes
25 worstcase search depth Level 1(root) 2 3 4 ... d Minimum number of descendants 2 2 m / 2 2 m / 2 m / 2 2 m / 2 ... 2 m / 2
d 1 3 A tree with N keys has N+1 descendants from its leaf level d. Then, 2 m / 2 d 1 N + 1 d 1 + log m / 2 (( N + 1) / 2)
e.g. N=1,000,000 and m=512, then d <= 3.37
26 FIGURE 14.11 The nodes of a B+tree. (a) Internal node of a B+tree with q 1 search values. (b) Leaf node of a B+tree with q 1 search values and q 1 data pointers. 27 28 Delete Algorithm for B+Tree Delete Key k from leaf level Check minimum requirement: Each node has Case 1: If k is also in index node m / 2  1 Replace k with the the previous key value Case 2: If underflow occurs in node n Find sibling leaf node (left/right) Redistribute the entries among n and its sibling to achieve half full, ow Merge node n and its (left/right) sibling , ow Three nodes merged into two leaf nodes Propagate merging to parent nodes. 29 New Version 30 31 B+Tree vs. BTree E.g.1. (to calculate the order of p of a Btree Suppose the search field is V = 9 bytes long, the disk block size is B = 512 bytes, a record pointer is Pr = 7 b...
View
Full Document
 Spring '09
 Denny
 hash function, records

Click to edit the document details