Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) 2nd Edition
Use the Amazon App to scan ISBNs and compare prices.
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.
Frequently bought together
About the Author
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.
- Publisher : Morgan Kaufmann; 2nd edition (February 3, 2012)
- Language : English
- Paperback : 296 pages
- ISBN-10 : 0123877334
- ISBN-13 : 978-0123877338
- Item Weight : 15.9 ounces
- Dimensions : 7.4 x 0.8 x 9.1 inches
- Best Sellers Rank: #1,006,760 in Books (See Top 100 in Books)
- Customer Reviews:
Top reviews from the United States
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.
Top reviews from other countries
I read the first few sections of the book, solved the problem and haven't looked back since.
This book is my go-to reference on the subject!
So 'verschwendet' der Autor viele Seiten mit Codeauszügen, bei denen oft wichtige Teile fehlen, da der Autor davon ausgeht die seien offensichtlich, für mich waren sie das nicht immer und ich habe unnötig viel Zeit verbracht es mir zusammenzureimen.
Bis auf diesen Punkt ein gutes Buch.