(2002-12-13) Hierarchy In Sql

Relational Modeling of Biological Data: Trees and Graphs SQL meets Graph Theory. Nested-set representation, which requires calculating sequence values for entries. Article doesn't cover keeping such values current during updates. Commercial Relational Data Base products that advertise native support for Hierarchical Data are often simply transparently building and managing these same representations. Now you know how to it yourself.