Joe Celko's Trees and Hierarchies in SQL for Smarties

Other | June 1, 2004

byJoe Celko, Joe Celko

not yet rated|write a review
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.

Pricing and Purchase Info

$40.09 online
$52.00 list price (save 22%)
In stock online
Ships free on orders over $25

From the Publisher

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

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.

other books by Joe Celko

Joe Celko's SQL Puzzles and Answers
Joe Celko's SQL Puzzles and Answers

Paperback|Sep 21 2006

$79.68 online$93.95list price(save 15%)
Joe Celko's SQL Programming Style
Joe Celko's SQL Programming Style

Kobo ebook|May 19 2005

$37.79 online$49.00list price(save 22%)
Joe Celko's Complete Guide to NoSQL: What Every SQL Professional Needs to Know about Non-Relational…
Joe Celko's Complete Guide to NoSQL: What Every SQL Pro...

Kobo ebook|Oct 7 2013

$38.49 online$50.00list price(save 23%)
see all books by Joe Celko
Format:OtherDimensions:240 pages, 1 × 1 × 1 inPublished:June 1, 2004Publisher:Morgan KaufmannLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:0080491693

ISBN - 13:9780080491691

Customer Reviews of Joe Celko's Trees and Hierarchies in SQL for Smarties

Reviews

Extra Content

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)