"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. It includes graph theory and programming techniques. Running examples throughout the book help illustrate and tie concepts together. Loads of code are available for download.
Joe Celko's Trees and Hierarchies in SQL for Smarties
and over 1.5 million other books are available for Amazon Kindle . Learn more
| |||||||||||||||
 Trade In this Item for up to £1.20
Trade in Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) for an Amazon.co.uk gift card of up to £1.20, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more
|
|
There is a newer edition of this item:
|
Book Description
Product details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, and more.
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.
About the Author
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. He has written over 900 columns in the computer trade and academic press, mostly dealing with data and databases. Joe has authored eight books on SQL for Morgan Kaufmann.
Inside This Book
(Learn More)
First Sentence
LET'S START WITH a little mathematical background. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index
LET'S START WITH a little mathematical background. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
2 of 2 people found the following review helpful
Format: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.
By MikeS
Format:Paperback|Amazon Verified Purchase
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
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
5 of 12 people found the following review helpful
By S. Rafiq
Format:Paperback|Amazon Verified Purchase
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.
You are much better researching trees in SQL on the web.
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
Customer Discussions
|
This product's forum
Search Customer Discussions
|
Related forums
|
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Theory
- Books > Computing & Internet > Databases > SQL
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Languages & Tools
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
