Trees and hierarchical data in SQL

From #mysql Freenode

Here are some links to good articles on trees and hierarchical data in relational databases

Sitepoint article Storing Hierarchical Data in a Database By Gijs Van Tulder (http://www.sitepoint.com/article/hierarchical-data-database)

Trees in SQL by Jan kneschke (http://jan.kneschke.de/projects/mysql/sp/)

vbmysql.com article Managing Hierarchical Data in MySQL by Mike Hillyer (http://www.vbmysql.com/articles/database-design/managing-hierarchical-data-in-mysql/)

Mysql.com article Managing Hierarchical Data in MySQL by Mike Hillyer (http://dev.mysql.com/tech-resources/articles/hierarchical-data.html)

[edit]

Some Articles by Vadim Tropashko

Trees in SQL: Nested Sets and Materialized Path (http://www.dbazine.com/oracle/or-articles/tropashko4)

Nested intervals tree encoding with continued fractions (http://arxiv.org/pdf/cs.DB/0402051v1.pdf)

he has more on his blog (http://vadimtropashko.wordpress.com/)

and a book

Tropashko SQL Design Patterns: The Expert Guide to SQL Programming

Retrieved from "http://hashmysql.org/index.php?title=Trees_and_hierarchical_data_in_SQL"