b trees

20
B Trees

Upload: aisu

Post on 14-Jun-2015

468 views

Category:

Education


2 download

DESCRIPTION

DBMS

TRANSCRIPT

Page 1: B Trees

B Trees

Page 2: B Trees

Sample B tree

Page 3: B Trees

• Minimization Factor : No of allowable Children for each node

• every node must have at least t - 1 keys

• Every node may have at most 2t - 1

Page 4: B Trees

• the height of an n-key b-tree

With t greater than or equal to 2,

Page 5: B Trees

Sample B tree

Page 6: B Trees
Page 7: B Trees

B-tree of order 5

all internal nodes have at least ceil(5 / 2) = ceil(2.5) = 3 children

maximum number of children that a node can have is 5

Page 8: B Trees

Insertion

• B-tree of order 5:

C N G A H E K Q M F W L T Z D P R X Y S

Order 5 means that a node can have a maximum of 5 children and 4 keys.

All nodes other than the root must have a minimum of 2 keys.

Page 9: B Trees

• C N G A Order this ACGN

• Inserting ACGN

Page 10: B Trees

Inserting H

Page 11: B Trees

Inserting E, K, and Q proceeds without requiring any splits:

Page 12: B Trees

Inserting M requires a split

Page 13: B Trees

The letters F, W, L, and T are then added without

needing any split

Page 14: B Trees

Adding Z

Page 15: B Trees

Inserting D

Page 16: B Trees

Inserting s

Page 17: B Trees

DELETION (H)

Page 18: B Trees

Delete T

Page 19: B Trees

Delete R

Page 20: B Trees

Delete E