Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

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

4.5 out of 5 stars 17 customer reviews
ISBN-13: 978-0123877338
ISBN-10: 0123877334
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Trade in your item
Get a $3.95
Gift Card.
Have one to sell? Sell on Amazon
Rent On clicking this link, a new layer will be open
$12.51 On clicking this link, a new layer will be open
Buy used On clicking this link, a new layer will be open
$24.75 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$31.27 On clicking this link, a new layer will be open
More Buying Choices
27 New from $20.82 16 Used from $24.75
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Security
ITPro.TV Video Training
Take advantage of IT courses online anywhere, anytime with ITPro.TV. Learn more.
$31.27 FREE Shipping. Only 12 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • Joe Celko's Trees and Hierarchies in SQL for Smarties, Second Edition (The Morgan Kaufmann Series in Data Management Systems)
  • +
  • Joe Celko's SQL for Smarties, Fifth Edition: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems)
  • +
  • SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers)
Total price: $116.04
Buy the selected items together

Editorial Reviews

About the Author

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.

Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas.

He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.
NO_CONTENT_IN_FEATURE
The latest book club pick from Oprah
"The Underground Railroad" by Colson Whitehead is a magnificent novel chronicling a young slave's adventures as she makes a desperate bid for freedom in the antebellum South. See more

Product Details

  • Series: The Morgan Kaufmann Series in Data Management Systems
  • Paperback: 296 pages
  • Publisher: Morgan Kaufmann; 2 edition (February 3, 2012)
  • Language: English
  • ISBN-10: 0123877334
  • ISBN-13: 978-0123877338
  • Product Dimensions: 7.4 x 0.8 x 9.1 inches
  • Shipping Weight: 1 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (17 customer reviews)
  • Amazon Best Sellers Rank: #914,296 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

By Kurt G. Schumacher VINE VOICE on April 19, 2012
Format: Paperback Vine Customer Review of Free Product ( What's this? )
I thought I knew my SQL, but this book showed me that I have a LOT to learn! SQL stands for Structured Query Language, and my use of the language has always been pretty much limited to "sentences". Select this, update that, delete something. I've even done a few simple procedures ("paragraphs"). And I've done some of the things described in this book ... trees and hierarchies ... in programming languages like PERL with occasional SQL statements.

This book shows how to do those things strictly in SQL. It made me realize that SQL itself can really be a programming language. You can write pretty heavy-duty programs just with SQL. That made my brain hurt!

A lot of the material covered in the book is way more advanced than I can handle right now, and more than I really need. But I've found over and over again that if I say, "I'll never need that," it's only a matter of time until I do need it. And even if I don't need anything as advanced as this, I've already learned a lot about what SQL can do.

I'm going to look up Joe Celko's other SQL books. I need to make my brain hurt some more.
Comment 9 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Vine Customer Review of Free Product ( What's this? )
Joe Celko writes well about SQL, and his earlier "SQL for Smarties" is a good book. This one expands what he's done with trees and heirarchies, and does so in a straightforward manner.

There's a limited audience for this book, as many SQL developers just won't need to deal with these data types, or they'll deal with fixed, mixed-type trees (such as Customer->Account->Transactions) in which many of these techniques won't be needed.

Also, some database systems (such as Oracle) have very powerful proprietary SQL dialects that will do obviate the need for much of this - if you are willing to use a DBMS-specific solution. But this book is written in a dialect-agnostic way.

I think the nicest thing about this book is that I've seen really bad table designs created just to avoid having to deal with trees and hierarchies, and this wook should help people avoid that and yet still feel thay will be able to program effectively using those kinds of designs.
Comment 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Vine Customer Review of Free Product ( What's this? )
Well, I mean to speed up your software that has any attachment to databases and if there is any kind of hierarchy in your data structure that's slowing it down. And that's probably exactly what's slowing down your software at this point, so get this book for your developers and DBAs. If you have any kind of bill of materials, complex recipe, any kind of genealogy, multi-level-marketing information, organization chart, sales data, or anything even remotely like this, then this book will be extremely helpful.

This book covers a ton of different methods for better speed and data access of hierarchical databases. It covers graph theory, how to write recursive queries, how to change your data structure to better traverse hierarchies, and much more.

The only drawback is that you really have to be pretty smart to implement anything in this book.

**Full disclosure** I received a complimentary copy of this product, and then I liked it so much that I got two more for friends and coworkers.

Pros:
+Extremely useful
+Awesome book
+Covers a ton of theory, with a ton of application
+Uses standard SQL, so the samples here work on almost any database
+Even though it's complex and about a complex topic, it's very readable and accessible

Cons:
-You need to be pretty smart to implement much of this
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Vine Customer Review of Free Product ( What's this? )
I feel graphs and tree are the core set of data structures used in most of the applications today and historically we have always modeled such network type data in relational databases for storage & retrieval. Naturally, the relational database doesn't fit out of the box to meet all read/aggregated read requirements for such data sets and even seasoned developers struggle to find a good solution to the problem at hand with such data. Joe Celko has attacked this area and described it at length in this book.

The book has 15 chapters to discuss the problems and a few proposed solutions at length. I feel the chapters are simple, easy to read, to the point and are always illustrated with meaningful examples to educate & engage the readers. The book starts with an introduction to the data problems with graph, tree and hierarchies and then discusses common data models to store & read such data and the current problems with such solutions. Further down the line, it discusses about the common real world problems that many data engineers or architect face today and proposes solutions. Finally, there are discussions around graphs in SQL and some specific cases around this area, which are really nice.

I liked the way this book deals with such a specific topic and I liked various ideas proposed through the chapters. This book has a specific set of audience but has very good set of ideas that are very relevant in today's world of data engineering.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Good book. Joe Celko wrote this book for advanced readers. I've read his SQL for Smarties previously and it was also excellent. Joe has interesting and thoughtful SQL techniques that are seldom mentioned in the literature.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

Joe Celko's Trees and Hierarchies in SQL for Smarties, Second Edition (The Morgan Kaufmann Series in Data Management Systems)
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: Joe Celko's Trees and Hierarchies in SQL for Smarties, Second Edition (The Morgan Kaufmann Series in Data Management Systems)