edited by
15,326 views
42 votes
42 votes

A $B^+$ - tree of order $d$ is a tree in which each internal node has between $d$ and $2 d$ key values. An internal node with $M$ key values has $M + 1$ children. The root (if it is an internal node) has between $1$ and $2d$ key values. The distance of a node from the root is the length of the path from the root to the node. All leaves are at the same distance from the root. The height of the tree is the distance of a leaf from the root.

  1. What is the total number of key values in the internal nodes of a $B^+$-tree with $l$ leaves ($l\geq 2$)?

  2. What is the maximum number of internal nodes in a $B^+$ - tree of order $4$ with $52$ leaves?

  3. What is the minimum number of leaves in a $B^+$-tree of order $d$ and height $h(h\geq 1)$?

edited by

5 Answers

0 votes
0 votes
part(B)

Here order d=4 so the minimum number of keys per  node=4 as per question.Now applying the result from part a i.e total number of keys in internal nodes is l-1 if the number of leaves is l.

Here total number of keys in the internal nodes=52-1=51

Now maximum number of internal nodes possible will be ceil(51/4)=13

Related questions

3.3k
views
1 answers
13 votes
go_editor asked Feb 8, 2018
3,329 views
Consider the following relational database schema:EMP (eno name, age)PROJ (pno name)INVOLVED (eno, pno)EMP contains information about employees. PROJ about projects and i...
12.1k
views
2 answers
30 votes
Kathleen asked Sep 29, 2014
12,070 views
For a database relation $R(a, b, c, d)$, where the domains $a, b, c, d$ include only atomic values, only the following functional dependencies and those that can be infer...
6.4k
views
3 answers
12 votes
go_editor asked Oct 15, 2015
6,386 views
Consider the following relational database schema:EMP (eno name, age)PROJ (pno name)INVOLVED (eno, pno)EMP contains information about employees. PROJ about projects and i...
7.8k
views
4 answers
42 votes
go_editor asked Oct 14, 2015
7,821 views
An operating system handles requests to resources as follows.A process (which asks for some resources, uses them for some time and then exits the system) is assigned a un...