 |
Joe Celko's Trees and Hierarchies in SQL for Smarties View Larger Image | Joe Celko
Morgan Kaufmann, Paperback, Published May 2004, 224 pages, ISBN 1558609202 | List Price: $40.95
Our Price: $28.95
You Save: $12.00 (29% Off)
| | | Availability: Out-Of-Stock |
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Joe Celko's SQL for Smarties: Advanced SQL Programming, 3rd Edition; Joe Celko, $41.50, 28% Off!
- Joe Celko's SQL Programming Style; Joe Celko, $25.50, 29% Off!
- Head First Design Patterns; Eric Freeman, et al, $26.95, 40% Off!
- The Best Software Writing I: Selected and Introduced by Joel Spolsky; Joel Spolsky, $15.95, 36% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
In a previous book, (SQL for Smarties, 2nd ed, MK, 1999) the author
wrote two chapters on programming techniques for representing trees and
hierarchies in SQL. Ever since then, he has answered constant personal
emails and/or postings on various database-related Internet newsgroups
on this topic. This isn't surprising. Trees and hierarchies are a
natural way to organize information and they appear everywhere in
computer science, from indexing structures (i.e. B-Tree indexing) to
encoding schemes (i.e. Dewey Decimal Classification system for
libraries) to hierarchical databases like IMS. Even XML and related
markup languages—which interact with databases--are based on tree
structures. Every SQL programmer is faced with the challenge of
creating these structures, which are not easy to master and have
far-reaching programmatic effects.
· Joe Celko is a best-selling author and SQL cult hero, whose first book (SQL
for Smarties) sold over 40,000 copies over two editions.
· This is the first developer's guide that addresses a topic that is universally
difficult for programmer's to master.
· This book is web-enhanced with downloadable SQL code, ready to use.
Table of Contents
Chapter 1 Graphs, Trees and Hierarchies • Chapter 2 Adjacency List Model
• Chapter 3 Path Enumeration Models • Chapter 4 Nested Set Model
of Hierarchies • Chapter 5 Frequent Insertion Trees • Chapter 6
The Linear Version of the Nested Sets model • Chapter 7 Binary Trees •
Chapter 8 Other Models for Trees • Chapter 9 Proprietary Extensions for
Trees • Chapter 10 Hierarchies in Data Modeling • Chapter 11 Hierarchical
Encoding Schemes • Chapter 12 Hierarchical Database Systems (IMS)
About the Author
Joe Celko is a noted consultant, lecturer, writer, and teacher whose
column in Intelligent Enterprise has won several Reader's Choice Awards. He
is well known for his ten years of service on the ANSI SQL standards committee,
his dependable help on the DBMS CompuServe Forum, and the war stories he tells
to provide real-world insights into SQL programming.
|
|
