Chapter 11. Hierarchical Encoding Schemes
A hierarchy is a useful concept for classifying data as well as retrieving them. The encoding schemes used to represent data are often hierarchical. Tree structures are a natural way to model encoding schemes that have a natural hierarchy. They organize data for searching and reporting along that natural hierarchy and make it very easy for a human being to understand. But what do you use for this natural organizational principle? Physical, temporal, or procedural options often exist, but many hierarchical encoding schemes are more circumstantial, traditional, and just plain arbitrary.
Keywords: ZIP codes, Melville Louis Kossuth Dewey, Dewey Decimal Classification system, shop categories, statistical ...

Get Joe Celko's Trees and Hierarchies in SQL for Smarties, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.