Playing with Hierarchies: Implementing the Nested Set Model in MySQL
Hierarchical data structures, or tree structures, are common in many systems, from representing organizational charts to category structures in e-commerce applications. One way to model such structures in a relational database is by using the Nested Set Model. Unlike the adjacency list model, the nested set model allows efficient querying