New Video: Phil Waclawski-Using Hierarchical Data in MySQL, Trees vs Nests
Brian Cluff
brian at snaptek.com
Tue Aug 22 07:37:33 MST 2017
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
More information about the PLUG-discuss
mailing list