Mon premier blog

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

Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in. A number of hierarchies and networks are most convenently modelled as binary trees. Description: Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioner's guide to mastering the two most challenging aspects of developing database applications in SQL. Amazon.com: Joe Celko's Trees and Hierarchies in SQL for Smarties. Description for Joe Celko s SQL for Smarties Fourth Edition Advanced SQL Programmg repost. Edit: I just found a book that is full of patterns for modeling the most common structures in relational databases: “SQL for Smarties – Advanced SQL Programming” by Joe Celko (who also wrote the article about the nested-set method for trees). The Morgan Kaufmann Series in Data Management. Storing hierarchical data in a relational database is not obvious. So what is the best way of representing them in SQL? Celko, Joe, "THINKING IN SETS Auxiliary, Temporal, and Virtual Tables in SQL", First Edition, CA, Morgan Kaufmann, 2008, ISBN 978-0-12-374137-0. Their suggestion is to model it with “pointers” to child-nodes which is incredibly inefficient to deal with in SQL, leads to recursive queries (unless proprietary SQL extensions are used) and you'll have to write loads of self-joins. There are a few techniques and I studied one that is called Netsted Sets and popularized by Joe Celko in his book Trees and Hierarchies in SQL for Smarties. Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems).