Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) Paperback – 1 Jun 2004
|New from||Used from|
- Choose from over 13,000 locations across the UK
- Prime members get unlimited deliveries at no additional cost
- Find your preferred location and add it to your address book
- Dispatch to this address when you check out
There is a newer edition of this item:
Customers who bought this item also bought
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.
Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?
"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.
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
I had previously used recursion to generate the trees but nested sets and SQL is so efficient a tree with many elements generates in next to no time.
Definitely worth the money
You are much better researching trees in SQL on the web.
Most helpful customer reviews on Amazon.com
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
Look for similar items by category
- Books > Computing & Internet > Databases > Applications
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > SQL
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Languages & Tools