02107cam a2200277 a 4500 1/40122 100621s2004 ne 001 0 eng 9781558609204 1558609202 42870 OPELS eng OPELS OKU OCLCQ OCLCF GR-PeUP Celko, Joe. Joe Celko's Trees and hierarchies in SQL for smarties [electronic resource] / Joe Celko. Trees and hierarchies in SQL for smarties Amsterdam ; Boston : Morgan Kaufmann, c2004. 1 online resource (xii, 224 p.) : ill. Includes bibliographical references (p. [215]-216). Graphs, trees, and hierarchies -- Adjacency list model -- Path enumeration models -- Nested set model of hierarchies -- Frequent insertion trees -- The linear version of the nested sets model -- Binary trees -- Other models for trees -- Proprietary extensions for trees -- Hierarchies in data modeling -- Hierarchical encoding schemes -- Hierarchical database systems (IMS). 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. SQL (Computer program language). Trees (Graph theory) Electronic books. INST UNIPILB EBOOKS 20100621 00b42870 00b42870 ONLINE 0 ScienceDirect http://www.sciencedirect.com/science/book/9781558609204 /webopac/covers/02/42870_9781558609204.jpg /webopac/covers/02/42870_1558609202.jpg