
Joe Celko's Trees and Hierarchies in SQL for Smarties
Joe Celko(Author)
Morgan Kaufmann (Publisher)
Published on 1. June 2004
Book
Paperback/Softback
240 pages
978-1-55860-920-4 (ISBN)
Article exhausted; check for reprint
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.
Reviews / Votes
"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.More details
Series
Language
English
Place of publication
San Francisco
United States
Publishing group
Elsevier Science & Technology
Target group
Professional and scholarly
database application developers
Dimensions
Height: 235 mm
Width: 191 mm
Weight
490 gr
ISBN-13
978-1-55860-920-4 (9781558609204)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions

Book
02/2012
2nd Edition
Morgan Kaufmann
€42.00
Shipment within 15-20 days
Person
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.
Content
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)