The Ubiquitous B-Tree
Douglas Comer · Purdue University · 1979
- What it is
- The survey that made the B-tree the default on-disk index — a shallow, high-fan-out tree that keeps data sorted and keeps lookups, range scans, and inserts all logarithmic, tuned to the reality that disks read in blocks.
- The lesson
- Nearly every relational database and file system indexes with a B-tree (really a B+ tree) for one reason: it minimizes disk seeks by matching node size to the storage block. Know this and you know why read-optimized stores are shaped the way they are.
- The interview edge
- The other half of the “B-tree vs LSM” fork every storage question eventually reaches. If you can say when a B-tree’s read-optimized, in-place-update design wins, you’re defending a datastore choice instead of guessing.