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
(text/plain)