A data structure such as a B-tree or sorted array is used for fast
searches of large sets of records, keyed by a single field. These data
structures support both equality queries, (e.g. find part #419), and
range queries, (e.g. find parts manufactured between September 15 and
September 20).
The choice of a data structure is dictated by the characteristics of the data set. Sorted arrays work well for static, memory-resident data sets. Balanced binary trees and skiplists work well for dynamic, memory-resident data sets. B-trees are best suited for large, dynamic disk-resident data sets.
|