Everything you ever wanted to know about handling hierarchical data in SQL but didn't know who to ask.

books:


	• Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management ... Joe Celko Morgan Kaufmann, 2004 - 240 pages average customer review:based on 6 reviews view larger image
	for more information click here

Life saver

I bought this book awhile back and skimmed through it. The last month I have been trying to get a clients adjacency list database to run fast enough for reporting and used the nested set. I has been a great solution to this problem.
While I could have found it on the web, I wouldn't have known what I was looking for with out reading about it first.

Great read!

While a little advanced (... the title does say for smarties...) this is one of the few IT books I have ever bought which I read more than once. It's a great mix of brain baking concepts and memory jarring discussions of things you probably slept through your sophomore year. If you've been working with or teaching yourself SQL and are looking to move on to the next step, Celko's books are an excellent place to start.

Note to MySQL users - as of MySQL 5 you can create everything written in this book, although you will need to remove the ATOMIC keyword from the procedures.

for more information click here

Excellent for those who need it deeply

The implementations for trees in SQL described in this book are great.

However if you don't need to understand it really deep you just need to read Celko's article that you can easily find around the web.

Everything you ever wanted to know about handling hierarchical data in SQL but didn't know who to ask.

When I started looking into managing hierarchical data I found a lot of short articles that provided bits and pieces of the big picture, but nothing gave a good in-depth review of everything I needed to know to handle hierarchies.

One trend that began to develop was that the best information on the subject was coming from Joe Celko, a rather prolific author/speaker on all things SQL.

Joe Celko has a book in publication called SQL For Smarties, and this book had some basic information on handling hierarchies, which he followed up with Trees and Hierarchies in SQL for Smarties, a truly excellent book on the subject.

This book is not for the faint of heart, but it really is a must-read for those who are looking to handle hierarchies in SQL.

The book only addresses MySQL once, and while in that section it repeats Joe's opinion of MySQL not being a real database, users of MySQL 5 can rest assured that the stored procedure examples in the book work without modification (thanks to Joe and MySQL 5 both using the standard PL/PSM stored procedure syntax).

Overall this is an excellent book for those looking to implement hierarchical data in SQL.

for more information click here

reviews: page 1, 2

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 SQL:1999.

· 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.

for more information click here