Another Word For It Patrick Durusau on Topic Maps and Semantic Diversity

March 5, 2012

Models for Hierarchical Data with SQL and PHP

Filed under: Adjacency List,Closure Table,Nested Sets,Path Enumeration — Patrick Durusau @ 7:53 pm

Models for Hierarchical Data with SQL and PHP by Bill Karwin.

From the description:

Tree-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.

May be of interest as a consumer of data stored using one of these designs or even using them more directly.

Powered by WordPress