B-tree - Best Case and Worst Case Heights

Best Case and Worst Case Heights

Let h be the height of the classic B-tree. Let n > 0 be the number of entries in the tree. Let m be the maximum number of children a node can have. Each node can have at most m−1 keys.

It can be shown (by induction for example) that a B-tree of height h with all its keys completely filled has keys. Hence, the best case height of a B-tree is:

Let d be the minimum number of children an internal (non-root) node can have. For an ordinary B-tree, d=⌈m/2⌉.

The worst case height of a B-tree is:

Comer (1979, p. 127) and Cormen et al. (year, pp. 383–384) give a slightly different expression for the worst case height (perhaps because the root node is considered to have height 0).

Read more about this topic:  B-tree

Famous quotes containing the words case, worst and/or heights:

    Consider the deference which is everywhere paid to a doctor’s opinion. Nothing more strikingly betrays the credulity of mankind than medicine. Quackery is a thing universal, and universally successful. In this case it becomes literally true that no imposition is too great for the credulity of men.
    Henry David Thoreau (1817–1862)

    A man’s worst difficulties begin when he is able to do as he likes.
    Thomas Henry Huxley (1825–95)

    Forgetting: that is a divine capacity. And whoever aspires to the heights and wants to fly must cast off much that is heavy and make himself light—I call it a divine capacity for lightness.
    Friedrich Nietzsche (1844–1900)