Skip to content
Related Articles

Related Articles

Difference between B tree and B+ tree

View Discussion
Improve Article
Save Article
  • Difficulty Level : Easy
  • Last Updated : 22 Jul, 2022

B-Tree: B-Tree is known as a self-balancing tree as its nodes are sorted in the inorder traversal. In B-tree, a node can have more than two children. B-tree has a height of logM N (Where ‘M’ is the order of tree and N is the number of nodes). And the height is adjusted automatically at each update. In the B-tree data is sorted in a specific order, with the lowest value on the left and the highest value on the right. To insert the data or key in B-tree is more complicated than a binary tree. Some conditions must be held by the B-Tree:

  • All the leaf nodes of the B-tree must be at the same level.
  • Above the leaf nodes of the B-tree, there should be no empty sub-trees.
  • B- tree’s height should lie as low as possible.

 

B+ Tree B+ tree eliminates the drawback B-tree used for indexing by storing data pointers only at the leaf nodes of the tree. Thus, the structure of leaf nodes of a B+ tree is quite different from the structure of internal nodes of the B tree. It may be noted here that, since data pointers are present only at the leaf nodes, the leaf nodes must necessarily store all the key values along with their corresponding data pointers to the disk file block, to access them. Moreover, the leaf nodes are linked to providing ordered access to the records. The leaf nodes, therefore form the first level of the index, with the internal nodes forming the other levels of a multilevel index. Some of the key values of the leaf nodes also appear in the internal nodes, to simply act as a medium to control the searching of a record.  

Let’s see the difference between B-tree and B+ tree:

Basis of ComparisionB treeB+ tree
PointersAll internal and leaf nodes have data pointersOnly leaf nodes have data pointers
SearchSince all keys are not available at leaf, search often takes more time.All keys are at leaf nodes, hence search is faster and more accurate.
Redundant KeysNo duplicate of keys is maintained in the tree.Duplicate of keys are maintained and all nodes are present at the leaf.
InsertionInsertion takes more time and it is not predictable sometimes.Insertion is easier and the results are always the same.
DeletionDeletion of the internal node is very complex and the tree has to undergo a lot of transformations.Deletion of any node is easy because all node are found at leaf.
Leaf NodesLeaf nodes are not stored as structural linked list.Leaf nodes are stored as structural linked list.
AccessSequential access to nodes is not possibleSequential access is possible just like linked list
HeightFor a particular number nodes height is largerHeight is lesser than B tree for the same number of nodes
ApplicationB-Trees used in Databases, Search enginesB+ Trees used in Multilevel Indexing, Database indexing
Number of NodesNumber of nodes at any intermediary level ‘l’ is 2l.Each intermediary node can have n/2 to n children.
My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!