Mon premier blog

Joe Celko's Trees and hierarchies in SQL for smarties Joe Celko
Publisher: Morgan-Kaufmann

I second the Ken Henderson recommendation. JSP Practical Guide for Programmers.pdf. Book: "Trees and Hierarchies in SQL for Smarties" by Joe Celko Adjacency List Model http://www.sqlsummit.com/AdjacencyList.htm. You might also consider books by Joe Celko: SQL for Smarties; Trees and Hierarchies in SQL for Smarties; SQL Puzzles and Answers. Joe Celko's Trees and Hierarchies in SQL for Smarties.pdf. Knowledge Representation and Reasoning.pdf. JSTL Practical Guide for JSP Programmers.pdf. Joe Celko has a section on nested sets etc in SQL for Smarties. Trees in SQL http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=1266295. Joe Celko's Trees And Hierarchies in SQL for Smarties Joe Celko | Morgan Kaufmann Publishers | ISBN: 1-55860-920-2 | 238 p. Read “Trees and Hierarchies in SQL for Smarties” by Joe Celko for a lot more information on these designs. RAR 1.38MB, unRARed PDF 2.65MB. Celko, Joe, "THINKING IN SETS Auxiliary, Temporal, and Virtual Tables in SQL", First Edition, CA, Morgan Kaufmann, 2008, ISBN 978-0-12-374137-0. He also has a whole book called Graphs, Trees and Hierarchies which may be worth a look (haven't read it myself). Mike Hillyer Managing Hierarchical Data in MySQL (I have used his sample data); Joe Celko's Trees and Hierarchies in SQL for Smarties - 2004; Alejandro Izaguirre Google groups. I usually prefer a design called Closure Table (aka “Adjacency Relation”) for storing tree-structured data.