Trees and hierarchies in SQL for smarties

Joe Celko

226 pages, parution le 01/07/2004

Ajouter à une liste

Indisponible

Résumé

Trees and Hierarchies in SQL for Smarties 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 SQL1999.

L'auteur - Joe Celko

Joe Celko is a noted consultant, lecturer, teacher, and one of the most-read SQL authors in the world. He is well known for his ten years of service on the ANSI SQL standards committee, his dependable help on the DBMS CompuServe Forum, his column in Intelligent Enterprise (which won several Reader's Choice Awards), and the war stories he tells to provide real-world insights into SQL programming. His best-selling books include Joe Celko's SQL for Smarties: Advanced SQL Programming, Joe Celko's SQL Puzzles and Answers, and Joe Celko's Trees and Hierarchies in SQL for Smarties, all published by Morgan Kaufmann.

Sommaire

Graphs, trees, and hierarchies
Adjacency list model
Path enumeration models
Nested set model of hierarchies
Frequent insertion trees
The linear version of the nested sets model
Binary trees
Other models for trees
Proprietary extensions for trees
Hierarchies in data modeling
Hierarchical encoding schemes
Hierarchical database systems (IMS)

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Elsevier
Auteur(s)	Joe Celko
Parution	01/07/2004
Nb. de pages	226
Format	19 x 23,5
Couverture	Broché
Poids	510g
Intérieur	Noir et Blanc
EAN13	9781558609204
ISBN13	978-1-55860-920-4