Just posted Phil Waclawski's presentation on Using Hierarchical Data in 
MySQL, Trees vs Nests that he gave to the Phoenix Linux Users Group on 
April 13th

https://youtu.be/bWtPCARl0U0
https://youtu.be/RswtHsz4v-0

Real world data is often made of hierarchical relationships, or "trees".
Representing that data in a Relational Database starts to get 
complicated as soon as you have more than two levels in your "Tree".
There are many strategies for handling such data, and I will cover 
examples of at least two of them (adjacency list and nested sets) and 
possibly more.

If you have access to a mysql instance, you can create the test tables 
and follow along, or get the code later.

Brian Cluff

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss