Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems) - Softcover

Celko, Joe

Softcover

ISBN 10: 1558609202 ISBN 13: 9781558609204

Publisher: Morgan Kaufmann, 2004

Synopsis

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.

About this title

About the Author

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.

From the Back Cover

"I want to say clearly that I think that the subject of this proposed book is one for which there will be considerable demand. I think that 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, ranging from enterprise-level application builders down to small business developers....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 Understanding the New SQL 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.

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.

Excerpt. © Reprinted by permission. All rights reserved.

Expert advice for smarties from the #1 SQL guru!

Edition details

• Publisher: Morgan Kaufmann
• Publication date: 2004
• Language: English
• ISBN 10: 1558609202
• ISBN 13: 9781558609204
• Binding: Paperback
• Edition number: 1
• Number of pages: 240