# B-Tree Example In Data Structure/ What is B Tree explain with an example?/ How are B trees used in the database?

Hello Friends, In this blog post I am going to let you know about the B-Tree in Data Structure. B-Tree of order n is a balanced multiway search tree of order n, In which each nonroot node contains at least (n-1)/2 keys.

Inside this blog post, I am going to let you know about What is B Tree explain with example? How are B trees used in the database? What are the properties of the B tree? What is the B tree structure in SQL Server?

### What is B Tree explain with example?

A B tree is a tree data structure that stores data and allows to search, insert,s, and deletion in the database. Unlike the self-balancing binary search tree B, the tree is used to read and write the large block of data. The most common use of the B tree is in the database and file system.

### How are B trees used in the database?

If a database uses the binary search then a record can be identified by just indexing and sequential search by searching through every element using the traversal in the leaf node. But in the case where no indexing performs in the database then to find a record in the database, we have to traverse each record in the database. The database reads each of the records to find a particular record. Each node in the B tree and B+ tree is kept inside the pages.

### What are the properties of the B tree?

**As per Knuth’s definition, a B-tree of order n is a tree which satisfies the following properties:**

- Every node has at most n children.
- Every non-leaf node (except root) has at least ⌈n/2⌉ child nodes.
- The root has at least two children if it is not a leaf node.
- A non-leaf node with k children contains k − 1 key.

### What is the B tree structure in SQL Server?

A B tree structure provides a fast way of searching the records row and tables based on the index key to the SQL server. It finds out the required value directly without scanning all the underlying table rows.

Note that the slash denotes integer division so that a B-Tree of order 12 contains at least 5 keys in each non-root nod, as does a B-Tree or order 11).

A B-Tree or order n is also called an n-(n-1) tree or an (n-1)-n tree. This means that each node in the tree has (n-1) maximum keys and n sons. The reason for using this second technique is,……….

that it creates balanced trees so that the maximum number of nodes accessed to find any particular key is kept small,…….

and another reason is that all nodes(except for the root) in a tree created by this technique are at least half full, so that very little storage space is wasted,…..

some terminology different in B-Tree. Such as order and degree are differently defined by different authors.

Order:

Order of a B-Tree defined as the minimum number of keys in a nonroot node(that is (n-1)/2)

Degree:

The degree of a B-Tree is the maximum number of sons(i,e.,n). Still other authors use ‘order’ to mean the maximum number of keys in a node.

### What is B Tree explain with example?

Example of B-Tree:

We have to insert the following keys into B-tree of order 5 step by step:

**1,7,6,2,11,4,8,13,10,5,19,9,18,24,3,12,14,20,21,16**

Now we start inserting the given data into a B-Tree of order 5 (that means the maximum number of keys = 4). The whole process is given below.

So, at last, we get our final B-Tree.

**Difference Between Tree And Binary Tree In Hindi. General tree और binary tree में अंतर हिंदी में |**

## Conclusion:

Within this blog post we have learned about What is B Tree explain with an example, How are B trees used in the database, What are the properties of B tree, What is a B tree structure in SQL Server.

In the case of any queries, you can write to us at [email protected] we will get back to you ASAP.

Hope! you would have enjoyed this post about B-Tree in data structure.

Please feel free to give your important feedbacks in the comment section below.

Have a great time! Sayonara!