- 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: 23 customer reviews
- Amazon Best Sellers Rank: #910,570 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, Second Edition (The Morgan Kaufmann Series in Data Management Systems) 2nd Edition
Use the Amazon App to scan ISBNs and compare prices.
Frequently bought together
Customers who bought this item also bought
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.
Top customer reviews
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.
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.
Most recent customer reviews
I've seen stuff being done in SQL I never thought of doing myself nor did I think possible, then again I'm no SQL...Read more
Joe Celko is my favorite writer when it comes to SQL.Read more