Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems)
| Author | : | |
| Rating | : | 4.86 (676 Votes) |
| Asin | : | 1558609202 |
| Format Type | : | paperback |
| Number of Pages | : | 240 Pages |
| Publish Date | : | 2013-12-19 |
| Language | : | English |
DESCRIPTION:
Michael R. Blaha said Good book. Joe Celko wrote this book for advanced. Good book. Joe Celko wrote this book for advanced readers. I've read his SQL for Smarties previously and it was also excellent. Joe has interesting and thoughtful SQL techniques that are seldom mentioned in the literature.. This is for Smarties allright! I thought I knew my SQL, but this book showed me that I have a LOT to learn! SQL stands for Structured Query Language, and my use of the language has always been pretty much limited to "sentences". Select this, update that, delete something. I've even done a few simple procedures ("paragraphs"). And I've done some of the things described in this book trees and hierarchies in programming languages like PERL with occasional SQL statements.This book shows how to do those things strictly in SQL. It made me realize that SQL its. If you need this, I don't know of any alternative Frobisher Joe Celko writes well about SQL, and his earlier "SQL for Smarties" is a good book. This one expands what he's done with trees and heirarchies, and does so in a straightforward manner.There's a limited audience for this book, as many SQL developers just won't need to deal with these data types, or they'll deal with fixed, mixed-type trees (such as Customer->Account->Transactions) in which many of these techniques won't be needed.Also, some database systems (such as Oracle) have very powerful proprietary SQL dialects that wil
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. 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 mkp.. 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. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more
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. Mr. Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. Celko is author a series
This book should be of great interest to real-world application programmersI 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 demandthe topic is poorly understood in general and a good book on the subject will be helpful to the SQL community at large