|
 |
|
 |
 |
Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in...
|
by Joe Celko
Sales Rank: 223965
|
Discount: 34 %
$23.00
At Amazon
|
|
Paperback: 240 pages
Publisher: Morgan Kaufmann; 1 edition May 7, 2004
Language: English
ISBN-10: 1558609202
ISBN-13: 978-1558609204
Product Dimensions:
9.1 x 7.5 x 0.6 inches
Shipping Weight: 1.1 pounds
Product Review
"I want to say clearly that I think the subject of this proposed book is one for which there will be considerable demandthe 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 programmersI 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.
Book Description
Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioners 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.
Customer Reviews & Comments
I love and savor each of Celko?s books for their thoroughness, depth and surprises. However, with this book I am little disappointed because it showed his favorite solutions and omitted many common solutions that are better in various real-world situations. Most algorithms provided in the book are for overnight processing, not real-time update. Omitted is the most common way hierarchies are represented in Data Warehouses using a "hierarchy bridge table". See Kimball?s book "Data Warehouse Toolkit" for more detail (yet not enough detail to give a Celko-like exploration of the topic). The bridge table solution trades away storage space for greater speed by creating a record for every path enumeration. The book?s primary focus is on strict hierarchies. Not enough attention is given to convergent graphs and other arbitrary directed acyclic graphs, like bill of materials that reuse assemblies, where the nested sets model fails (p.164). Also missing is maintenance of historical versions of the hierarchy, often required by financial applications. Section 9.3 on the extremely powerful DB2 ?WITH? operator is too slim, especially since it is a SQL-99 standard and is now available with Microsoft SQL Server. If you work with hierarchies or acyclic graphs in DB2 or SQL Server take the time to learn how to use ?common subquery expressions?. By all means if you work with hierarchies you must buy this book. No doubt the Second revison of this book will blow us away.
Comment (1) | Permalink |
(Report this)
|
Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in...
Discount: 34 %
Available from Amazon
Price: $23.00
| |
|
|
|
|
