What is B-tree and explain the reasons for using it (DBMS)?

DBMSDatabaseBig Data Analytics

Let us first try to understand why we are using B-tree. Then, we will get a clarity on the definition of B-tree.

Reasons for using B-tree

The reasons for using B-tree are as follows −

  • When searching tables on disc, the cost of accessing the disk is high but it doesn’t bother about the amount of data transferred. So our aim is to minimize disc access.

  • We know that we cannot improve the height of trees. So, we wish to make the height of the tree as small as possible.

  • The solution for this is to use a B-tree, it has more branches and thus less height. As branching increases, depth decreases so does access time.

  • In a B-tree, one node can hold many elements or items.

Example

Assume that if we want to access one node of B tree, we need one disc read operation. A B tree of order 101 and height 3 can hold 1014-1 items approximately 100 million. So, any item can be accessed with max3 3 disc reads.

  • B tree are called balanced stored trees, since all the leaves are at the same level, it is also called a multi-way search tree, it is a form of multilevel indexing.

  • B tree grow towards root not towards leaf.

Definition of B-tree

Now let us try to understand the definition of B-tree, which is explained below −

Definition − A B-tree of order m is an m-way tree that means a node can have maxm m children.

Properties of B-tree

B-tree satisfies the following properties −

  • The number of keys in a node (non leaf node) is one less than the number of its children (and these keys partition the keys of children like a binary search tree).

  • The root has a minimum one key to maximum (m-1) keys. So, root has minimum two children to maximum m children.

  • Any node (non-leaf node) except the root has minm([m/2]-1) to maxm(m-1) keys. So, they have minm [ m/2 ] children to maxm m children.

  • All leaf nodes are on the same level.

Note − Non-leaf nodes are called internal nodes (nodes having child). Leaf nodes are called external nodes (nodes having no child).

Example

A B-tree of order 3 (i.e a node can have maxm 3 children) satisfy following properties −

  • The root has minimum one key to maximum 2 keys. So root has minimum two children to maximum 3 children.

  • Any node (non-leaf node) except the root has minm 1 to maxm 2 keys. So, they have minm 2 children to maxm 3 children.

Note − Duplicate key values are not allowed.

Given below is the diagram of a B-tree −

raja
Published on 08-Jul-2021 07:58:00
Advertisements