Joe Celko's Trees and Hierarchies in SQL for Smarties, and over 900,000 other books are available for Amazon Kindle . Learn more


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime free trial required. Sign up when you check out. Learn more
More Buying Choices
Have one to sell? Sell yours here
or
Get a £5.85 Amazon.co.uk Gift Card
Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems)
 
 
Start reading Joe Celko's Trees and Hierarchies in SQL for Smarties, on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) [Paperback]

Joe Celko
3.7 out of 5 stars  See all reviews (3 customer reviews)
RRP: £28.99
Price: £25.51 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £3.48 (12%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.
Only 5 left in stock--order soon (more on the way).
Want guaranteed delivery by Saturday, February 11? Choose Express delivery at checkout. See Details

Formats

Amazon Price New from Used from
Kindle Edition £19.13  
Paperback £25.51  
Amazon.co.uk Trade-In Store
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Amazon.co.uk Trade-In Store for more details.
There is a newer edition of this item:
Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems)
£23.79
Available for pre-order

Frequently Bought Together

Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) + Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems) + Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems)
Price For All Three: £73.54

Show availability and delivery details

Buy the selected items together


Product details

  • Paperback: 240 pages
  • Publisher: Morgan Kaufmann (1 Jun 2004)
  • Language English
  • ISBN-10: 1558609202
  • ISBN-13: 978-1558609204
  • Product Dimensions: 23.1 x 18.3 x 1.5 cm
  • Average Customer Review: 3.7 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: 483,958 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Joe Celko
Discover books, learn about writers, and more.

Visit Amazon's Joe Celko Page

Product Description

Review

"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.

Product Description

Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioner's guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more. This book covers SQL-92 and SQL:1999.

· Includes graph theory and programming techniques.
· Running examples throughout the book help illustrate and tie concepts together.
· Loads of code, available for download from www.mkp.com.

Inside This Book (Learn More)
First Sentence
LET'S START WITH a little mathematical background. Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Tag this product

 (What's this?)
Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items.
Your tags: Add your first tag
 

What Other Items Do Customers Buy After Viewing This Item?


 

Customer Reviews

3 Reviews
5 star:
 (2)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:
 (1)
 
 
 
 
 
Average Customer Review
3.7 out of 5 stars (3 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

2 of 2 people found the following review helpful:
5.0 out of 5 stars Excellent Guide for the Pro, 24 Oct 2009
By 
Alexei Koulikov "Clops" (Vienna, Austria) - See all my reviews
(REAL NAME)   
This review is from: Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) (Paperback)
Being a computer science student I found it hard to understand the amount of theory behind Database Structures. This book provides very good guidance for solving non-trivial problems in storing complex data structures in a flat relational database. I found it very helpful and full of great ideas, which I have used in my web applications.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars Comprehensive explaination of how to use trees, 22 Jan 2012
This review is from: Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) (Paperback)
I had a project that used a tree structure to represent data and found this book invaluble in learning how to use nested sets.
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
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5 of 12 people found the following review helpful:
1.0 out of 5 stars poor book, 19 May 2007
By 
S. Rafiq "Its all good" (Blackburn, UK) - See all my reviews
(REAL NAME)   
This review is from: Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) (Paperback)
A poor book with many SQL errors. A confusing and arrogrant writing style. There is very little detail when you need it, Focuses too much on his nested sets representation. I doubt very many would use it given its complexity. I got absolutley nothing out of this book.

You are much better researching trees in SQL on the web.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
Would you like to see more reviews about this item?
 Go to Amazon.com to see all 6 reviews  3.5 out of 5 stars 
Were these reviews helpful?   Let us know
 
 
Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Listmania!

Create a Listmania! list

Look for similar items by category


Look for similar items by subject


Feedback


Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges