Joe Celko's Trees and Hierarchies in SQL for Smarties,

by Joe Celko

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. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more. This book covers SQL-92 and

· Includes graph theory and programming techniques.
· Running examples throughout the book help illustrate and tie concepts together.
· Loads of code, available for download from www.mkp.com.

Genres: Programming, Technology, Reference, Computer Science, Computers, Software, Technical

240 pages, Paperback

First published May 7, 2004

Reviews

[Joe Michalak · Rating 5 out of 5]

This book provides a great overview on graphs, trees, and hierarchies, and then several great examples of how to work with them in a Relational Database enviroment. A particular strength of the book is that it balances being a "Cookbook", providing useful code snippets to work with the structures, but also explaining the how and why of each of the snippets.

I am looking forward to using many of the methods in ongoing projects; as well as looking forward to researching some of the other topics (petri nets, state transition graphs) further.

[Patrick]

Excellent reference for nested sets

[Mike Clark · Rating 4 out of 5]

While I just scanned it for a project at work. I was very impressed with the structure and presentation. Very easy to understand and presented the material excellently.