Joe Celko's Trees and Hierarchies in SQL for Smarties

Author:   Joe Celko (Independent Consultant, Austin, Texas)
Publisher:   Elsevier Science & Technology
ISBN:  

9781558609204


Pages:   240
Publication Date:   01 June 2004
Replaced By:   9780123877338
Format:   Paperback
Availability:   In Print   Availability explained
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

Our Price $118.67 Quantity:  
Add to Cart

Share |

Joe Celko's Trees and Hierarchies in SQL for Smarties


Add your own review!

Overview

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.

Full Product Details

Author:   Joe Celko (Independent Consultant, Austin, Texas)
Publisher:   Elsevier Science & Technology
Imprint:   Morgan Kaufmann Publishers In
Dimensions:   Width: 19.10cm , Height: 1.20cm , Length: 23.50cm
Weight:   0.480kg
ISBN:  

9781558609204


ISBN 10:   1558609202
Pages:   240
Publication Date:   01 June 2004
Audience:   Professional and scholarly ,  Professional & Vocational
Replaced By:   9780123877338
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   In Print   Availability explained
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

Table of Contents

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)

Reviews

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


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.


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


Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions
Latest Reading Guide

MRG2025CC

 

Shopping Cart
Your cart is empty
Shopping cart
Mailing List