Models for hierarchical dataTree-like data relationships are common, but working with trees in SQL usually requires awkward recursive queries. This talk describes alternative solutions in SQL, including: - Adjacency List - Path Enumeration - Nested Sets - Closure Table Code examples will show using these designs in PHP, and offer guidelines for choosing one design over another.
