There are lots of ways in SQL to provide nested/heirarchical data, each with their own strengths and weaknesses. * Adjacency List Model * Path Enumeration Mod

There are lots of ways in SQL to provide nested/heirarchical data, each with their own strengths and weaknesses. * Adjacency List Model * Path Enumeration Model, also known as the Materialized Path * Closure Table Model (or Bridge Table) * Nested Set Model * Recursive CTEs