Mon premier blog

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

Parts explosions present a classic IT problem. The job is done by a procedure which has been inspired by Joe Celko's book "Trees and Hierarchies in SQL for Smarties". Given how much attention my talk about storing a tree data structure in the db received, it's probably going to be interesting to many. Joe shows how it can be done using nested sets, with not an IDENTITY or GUID in sight. ISBN13: 9781558609204Condition: NewNotes: BUY WITH CONFIDENCE, Over one million books sold! Celko acknowledged his thin treatment by subsequently devoting an entire book to the subject: Joe Celko's Trees and Hierarchies in SQL for Smarties. Compare our books, prices and service to the. Joe Celko dedicates a short chapter to graphs in his "SQL for Smarties" book, but the topic is treated in a quite hasty way, which is surprising given his usual high standards. These databases describe how to make something by telling us two things: (1) what quantity of each parts we need and (2) how they fit together in a hierarchy of assemblies that make the final assembly. You need a stack table and a tree table. How can one calculate such things as weight or cost of assemblies in SQL?