Joe Celko's Trees and Hierarchies in SQL for Smarties

Download or read book Joe Celko's Trees and Hierarchies in SQL for Smarties written by Joe Celko and published by Elsevier. This book was released on 2004-06-01 with total page 241 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.