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

Product Details

• Amazon Sales Rank: #372891 in Books
• Published on: 2004-06-01
• Original language: English
• Number of items: 1
• Binding: Paperback
• 240 pages

Review
"I want to say clearly that I think the subject of this proposed book is one for which there will be considerable demand...the topic is poorly understood in general and a good book on the subject will be helpful to the SQL community at large. This book should be of great interest to real-world application programmers...I think that this book would be used on a day-to-day basis (rather than languish on a shelf until some special problem arose)."
-Jim Melton, author of SQL:1999.

About the Author
Joe Celko is a noted consultant, lecturer, teacher, and one of the most-read SQL authors in the world. He is well known for his ten years of service on the ANSI SQL standards committee, his dependable help on assorted SQL newsgroups, his column in Intelligent Enterprise (which won several Reader's Choice Awards), and the war stories he tells to provide real-world insights into SQL programming. His best-selling books include Joe Celko's SQL for Smarties: Advanced SQL Programming, Joe Celko's SQL Puzzles and Answers, Joe Celko's Trees and Hierarchies in SQL for Smarties, and Joe Celko's SQL Style, all published by Morgan Kaufmann.

Customer Reviews

poor book
A poor book with many SQL errors. A confusing and arrogrant writing style. There is very little detail when you need it, Focuses too much on his nested sets representation. I doubt very many would use it given its complexity. I got absolutley nothing out of this book.

You are much better researching trees in SQL on the web.

Excellent Guide for the Pro
Being a computer science student I found it hard to understand the amount of theory behind Database Structures. This book provides very good guidance for solving non-trivial problems in storing complex data structures in a flat relational database. I found it very helpful and full of great ideas, which I have used in my web applications.