- Series: The Morgan Kaufmann Series in Data Management Systems
- Paperback: 240 pages
- Publisher: Morgan Kaufmann; 1 edition (May 21, 2004)
- Language: English
- ISBN-10: 1558609202
- ISBN-13: 978-1558609204
- Product Dimensions: 7.5 x 0.5 x 9.2 inches
- Shipping Weight: 1.1 pounds
- Average Customer Review: 21 customer reviews
- Amazon Best Sellers Rank: #2,248,237 in Books (See Top 100 in Books)
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.
To get the free app, enter your mobile phone number.
Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
There is a newer edition of this item:
Customers who viewed this item also viewed
Customers who bought this item also bought
"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.
Expert advice for smarties from the #1 SQL guru!
Try the Kindle edition and experience these great reading features:
Showing 1-8 of 21 reviews
There was a problem filtering reviews right now. Please try again later.
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.
+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
-You need to be pretty smart to implement much of this
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.
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.