SQL databases are not designed for hierarchical data since the data is stored in flat relational tables with no built in parent-child relationship methods (Oracle does have the connect_by function to help). XML databases on the other hand are built for hierarchical data.
So with SQL databases we have a problem that requires a solution. Thanks to the SQL gurus out there we have three models to resolve this issue. In this post I will point you to these resources.
