Joe Celko's Trees and hierarchies in SQL for smarties
Title:
Joe Celko's Trees and hierarchies in SQL for smarties
Author:
Celko, Joe.
ISBN:
9781558609204
Personal Author:
Publication Information:
Amsterdam ; Boston : Morgan Kaufmann, c2004.
Physical Description:
xii, 224 p. : ill. ; 24 cm.
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).
Abstract:
Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioners 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.
Genre:
Added Corporate Author:
Electronic Access:
ScienceDirect An electronic book accessible through the World Wide Web; click for informationTable of contents http://www.loc.gov/catdir/toc/els051/2004006193.html
Publisher description http://www.loc.gov/catdir/description/els051/2004006193.html