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

Book • Second Edition2012

Author:

Joe Celko

Joe Celko's Trees and Hierarchies in SQL for Smarties

A volume in The Morgan Kaufmann Series in Data Management Systems

Book • Second Edition2012

 

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

Author:

Joe Celko

About the book

Browse this book

Book description

The demand for SQL information and training continues to grow with the need for a database behind every website capable of offering web-based information queries. SQL is the de fac ... read full description

Browse content

Table of contents

Actions for selected chapters

Select all / Deselect all

  1. Full text access
  2. Book chapterNo access

    Chapter 1 - Graphs, Trees, and Hierarchies

    Pages 1-10

  3. Book chapterNo access

    Chapter 2 - Adjacency List Model

    Pages 11-33

  4. Book chapterNo access

    Chapter 3 - Path Enumeration Models

    Pages 35-47

  5. Book chapterNo access

    Chapter 4 - Nested Sets Model of Hierarchies

    Pages 49-109

  6. Book chapterNo access

    Chapter 5 - Frequent Insertion Trees

    Pages 111-147

  7. Book chapterNo access

    Chapter 6 - Linear Version of the Nested Sets Model

    Pages 149-155

  8. Book chapterNo access

    Chapter 7 - Binary Trees

    Pages 157-171

  9. Book chapterNo access

    Chapter 8 - Other Models for Trees

    Pages 173-186

  10. Book chapterNo access

    Chapter 9 - Proprietary Extensions for Trees

    Pages 187-194

  11. Book chapterNo access

    Chapter 10 - Hierarchies in Data Modeling

    Pages 195-210

  12. Book chapterNo access

    Chapter 11 - Hierarchical Encoding Schemes

    Pages 211-218

  13. Book chapterNo access

    Chapter 12 - Graphs in SQL

    Pages 219-238

  14. Book chapterNo access

    Chapter 13 - Petri Nets

    Pages 239-244

  15. Book chapterNo access

    Chapter 14 - State Transition Graphs

    Pages 245-254

  16. Book chapterNo access

    Chapter 15 - Hierarchical Database Systems (IMS)

    Pages 255-270

  17. Book chapterNo access

    Index

    Pages 271-277

About the book

Description

The demand for SQL information and training continues to grow with the need for a database behind every website capable of offering web-based information queries. SQL is the de facto standard for database retrieval, and if you need to access, update, or utilize data in a modern database management system, you will need SQL to do it. The Second Edition of Joe Celko's Trees and Hierarchies in SQL for Smarties covers two new sets of extensions over three entirely new chapters and expounds upon the changes that have occurred in SQL standards since the previous edition's publication. Benefit from mastering the challenging aspects of these database applications in SQL as taught by Joe Celko, one of the most-read SQL authors in the world.

The demand for SQL information and training continues to grow with the need for a database behind every website capable of offering web-based information queries. SQL is the de facto standard for database retrieval, and if you need to access, update, or utilize data in a modern database management system, you will need SQL to do it. The Second Edition of Joe Celko's Trees and Hierarchies in SQL for Smarties covers two new sets of extensions over three entirely new chapters and expounds upon the changes that have occurred in SQL standards since the previous edition's publication. Benefit from mastering the challenging aspects of these database applications in SQL as taught by Joe Celko, one of the most-read SQL authors in the world.

Key Features

  • Expert advice from a noted SQL authority and award-winning columnist who has given 10 years of service to the ANSI SQL standards committee
  • Teaches scores of advanced techniques that can be used with any product, in any SQL environment
  • Offers graph theory and programming techniques for working around deficiencies and gives insight into real-world challenges
  • Expert advice from a noted SQL authority and award-winning columnist who has given 10 years of service to the ANSI SQL standards committee
  • Teaches scores of advanced techniques that can be used with any product, in any SQL environment
  • Offers graph theory and programming techniques for working around deficiencies and gives insight into real-world challenges

Details

ISBN

978-0-12-387733-8

Language

English

Published

2012

Copyright

Copyright © 2012 Elsevier Inc. All rights reserved

Imprint

Morgan Kaufmann

Authors

Joe Celko