Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.
Joe Celko's Trees and Hierarchies in SQL for Smarties, and over 300,000 other books are available for Amazon Kindle – Amazon’s new wireless reading device. Learn more

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
41 used & new from $15.99
Have one to sell? Sell yours here
 
   
Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems)
 
 
Share your own customer images
Search inside this book
Start reading Joe Celko's Trees and Hierarchies in SQL for Smarties, on your Kindle in under a minute.

Don’t have a Kindle? Get yours here.
 
  

Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems) (Paperback)

by Joe Celko (Author) "LET'S START WITH a little mathematical background..." (more)
Key Phrases: adjacency list model, nested sets model, nested set model, Bob Badour Jan, Lennart Jonsson Jan, Steve Jan (more...)
3.5 out of 5 stars See all reviews (6 customer reviews)
List Price: $42.95
Price: $31.68 & this item ships for FREE with Super Saver Shipping. Details
You Save: $11.27 (26%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Upgrade this book for $7.79 more, and you can read, search, and annotate every page online. See details
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Tuesday, July 21? Choose One-Day Shipping at checkout. Details
25 new from $28.40 16 used from $15.99
Also Available in: List Price: Our Price: Other Offers:
Kindle Edition (Kindle Book) $28.51

Frequently Bought Together

Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems) + Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The Morgan Kaufmann Series in Data Management Systems) + Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems)
Price For All Three: $93.44

Show availability and shipping details

Customers Who Bought This Item Also Bought

Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems)

Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems)

by Joe Celko
2.7 out of 5 stars (7)  $23.36
Joe Celko's Analytics and OLAP in SQL (The Morgan Kaufmann Series in Data Management Systems)

Joe Celko's Analytics and OLAP in SQL (The Morgan Kaufmann Series in Data Management Systems)

by Joe Celko
4.0 out of 5 stars (3)  $34.27
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems)

Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems)

by Joe Celko
3.9 out of 5 stars (8)  $28.04
Joe Celko's SQL Puzzles and Answers, Second Edition, Second Edition (The Morgan Kaufmann Series in Data Management Systems)

Joe Celko's SQL Puzzles and Answers, Second Edition, Second Edition (The Morgan Kaufmann Series in Data Management Systems)

by Joe Celko
3.6 out of 5 stars (13)  $36.51
Joe Celko's Data and Databases: Concepts in Practice (The Morgan Kaufmann Series in Data Management Systems)

Joe Celko's Data and Databases: Concepts in Practice (The Morgan Kaufmann Series in Data Management Systems)

by Joe Celko
3.6 out of 5 stars (9)  $49.45
› Explore similar items

Editorial Reviews

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.

Book Description
Expert advice for smarties from the #1 SQL guru!

See all Editorial Reviews

Product Details

  • Paperback: 240 pages
  • Publisher: Morgan Kaufmann; 1 edition (May 21, 2004)
  • Language: English
  • ISBN-10: 1558609202
  • ISBN-13: 978-1558609204
  • Product Dimensions: 9.1 x 7.5 x 0.2 inches
  • Shipping Weight: 15.5 ounces (View shipping rates and policies)
  • Average Customer Review: 3.5 out of 5 stars See all reviews (6 customer reviews)
  • Amazon.com Sales Rank: #169,048 in Books (See Bestsellers in Books)

    •  Would you like to update product info or give feedback on images?
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Search Inside This Book:
Inside This Book (learn more)
First Sentence:
LET'S START WITH a little mathematical background. Read the first page
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
adjacency list model, nested sets model, nested set model, ret num, nonbinary trees, enumeration model, deleted node, parts explosion, hidden table, root segment, path string, primary key, entire subtree, compound key, deleting nodes
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Bob Badour Jan, Lennart Jonsson Jan, Steve Jan, United States, Converting Nested Sets Model, New York
New!
Books on Related Topics | Concordance | Text Stats
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Search Inside This Book:
Citations (learn more)
This book cites 10 books:
See all 10 books this book cites

Books on Related Topics (learn more)
 
 

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below.
(2)
(1)
(1)
(1)
(1)
(1)
See all 9 tags...

Your tags: Add your first tag
 
See most popular tags
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more
 

Customer Reviews

6 Reviews
5 star:
 (1)
4 star:
 (2)
3 star:
 (2)
2 star:
 (1)
1 star:    (0)
 
 
 
 
 
Average Customer Review
3.5 out of 5 stars (6 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
68 of 69 people found the following review helpful:
3.0 out of 5 stars Depth but not breadth, July 23, 2004
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 Comment (1) | Permalink | Was this review helpful to you? Yes No (Report this)



 
5 of 6 people found the following review helpful:
5.0 out of 5 stars Great read!, January 3, 2007
By Brian E. Mcelaney (Philladelphia, PA, USA) - See all my reviews
(REAL NAME)   
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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
8 of 11 people found the following review helpful:
4.0 out of 5 stars Everything you ever wanted to know about handling hierarchical data in SQL but didn't know who to ask., February 8, 2006
By Michael Hillyer (Alberta, Canada) - See all my reviews
(REAL NAME)   
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.
Comment Comment (1) | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
Ad
 
Most Recent Customer Reviews

3.0 out of 5 stars 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... Read more
Published 12 months ago by Diogo Vieira

2.0 out of 5 stars Joe Celko's Trees and Hierarchies in SQL for Smarties
It's not what I expected.

I'm doing alot of SQL programming now and there's also alot of self-joins and just simply alot of analytics in my new position using SQL. Read more
Published on March 29, 2007 by Jaime D. Perez

4.0 out of 5 stars 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... Read more
Published on January 6, 2006 by D8AXKV8

Only search this product's reviews


Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]


Active discussions in related forums
   

Product Information from the Amapedia Community

Beta (What's this?)

Look for Similar Items by Category

Let Toro Clear the Snow

Let Toro Clear the Snow
Rely on Toro for top-quality snow throwers and power shovels to make snow removal a breeze.

›Shop all Toro

  

Big Savings in Books

Bargain Books
Find great titles at fantastic prices in our Bargain Books Store.
 

Dive into Summer Reading

Summer Reading for Kids and Teens
Don't even think about hitting the beach without browsing the books in our Summer Reading Store. Discover bestsellers, paperback picks, beach reads, and more terrific titles all summer long.
 

Not as Cold as Ice

Shop for De-Icers and Salt Spreaders
Don't let ice bring you down this winter. Check out the de-icers and salt spreaders in the Home Improvement Store.

›Shop all snow removal products

  
Ad

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.
Continue shopping: Top Sellers
Free
Free by Chris Anderson
3.5 out of 5 stars (15)$0.00
 Paranoia
Paranoia by Joseph Finder
4.1 out of 5 stars (204)$0.00
 The Adventures of Sherlock Holmes
The Adventures of Sherlock Holmes by Arthur Conan, Sir, 1859-1930 Doyle
5.0 out of 5 stars (5)$0.00
 Glenn Beck's Common Sense
Glenn Beck's Common Sense by Glenn Beck
3.8 out of 5 stars (347)$6.59

amazon.com Amazon.com Home  |   Directory of All Stores
International Sites:  Canada  |  United Kingdom  |  Germany  |  Japan  |  France  |  China
Business Programs: Sell on Amazon  |  Build an eCommerce Site  |  Advertise With Us  |  Developer Services  |  Self-Publish with Us
Help  |  View Cart  |  Your Account  |  1-Click Settings  |  Join Associates  |  Join Advantage
Careers at Amazon  |  Investor Relations  |  Press Releases  |  Corporate Responsibility
Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates