Cover for Joe Celko's Trees and Hierarchies in SQL for Smarties

Joe Celko's Trees and Hierarchies in SQL for Smarties

A volume in The Morgan Kaufmann Series in Data Management Systems

Book2004

Author:

Joe Celko

Joe Celko's Trees and Hierarchies in SQL for Smarties

A volume in The Morgan Kaufmann Series in Data Management Systems

Book2004

 

Cover for Joe Celko's Trees and Hierarchies in SQL for Smarties

Author:

Joe Celko

About the book

Browse this book

Book 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 ... read full description

Browse content

Table of contents

Actions for selected chapters

Select all / Deselect all

  1. Full text access
  2. Book chapterNo access

    Introduction

    Pages 1-2

  3. Book chapterAbstract only

    Chapter 1 - Graphs, Trees, and Hierarchies

    Pages 3-15

  4. Book chapterAbstract only

    Chapter 2 - Adjacency List Model

    Pages 17-34

  5. Book chapterAbstract only

    Chapter 3 - Path Enumeration Models

    Pages 35-43

  6. Book chapterAbstract only

    Chapter 4 - Nested Set Model of Hierarchies

    Pages 45-99

  7. Book chapterAbstract only

    Chapter 5 - Frequent Insertion Trees

    Pages 101-135

  8. Book chapterAbstract only

    Chapter 6 - The Linear Version of the Nested Sets Model

    Pages 137-141

  9. Book chapterAbstract only

    Chapter 7 - Binary Trees

    Pages 143-156

  10. Book chapterAbstract only

    Chapter 8 - Other Models for Trees

    Pages 157-168

  11. Book chapterAbstract only

    Chapter 9 - Proprietary Extensions for Trees

    Pages 169-174

  12. Book chapterAbstract only

    Chapter 10 - Hierarchies in Data Modeling

    Pages 175-189

  13. Book chapterAbstract only

    Chapter 11 - Hierarchical Encoding Schemes

    Pages 191-197

  14. Book chapterAbstract only

    Chapter 12 - Hierarchical Database Systems (IMS)

    Pages 199-213

  15. Book chapterNo access

    Appendix - Readings and Resources

    Pages 215-216

  16. Book chapterNo access

    Index

    Pages 217-224

  17. Book chapterNo access

    About the Author

    Page 225

About the book

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.

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.

Key Features

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

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

Details

ISBN

978-1-55860-920-4

Language

English

Published

2004

Copyright

Copyright © 2004 Elsevier Inc. All rights reserved

Imprint

Morgan Kaufmann

Authors

Joe Celko