Description |
1 online resource (xii, 224 pages) : illustrations |
|
text txt rdacontent |
|
computer c rdamedia |
|
online resource cr rdacarrier |
|
text file |
Series |
Celko, Joe.
SQL for smarties.
|
Bibliography |
Includes bibliographical references (pages 215-216). |
Note |
Print version record. |
Contents |
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). |
Summary |
Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioners 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. |
Note |
Copyright: Elsevier Science & Technology 2004 |
Subject |
SQL (Computer program language)
|
|
Trees (Graph theory)
|
|
SQL (Langage de programmation)
|
|
Arbres (Théorie des graphes)
|
|
COMPUTERS -- Programming Languages -- C#
|
|
COMPUTERS -- Programming Languages -- Java.
|
|
COMPUTERS -- Programming Languages -- Pascal.
|
|
SQL (Computer program language)
|
|
Trees (Graph theory)
|
|
SQL (Computer program language)
|
|
Trees (Graph theory)
|
Added Title |
Trees and hierarchies in SQL for smarties |
Other Form: |
Print version: Celko, Joe. Joe Celko's Trees and hierarchies in SQL for smarties. Amsterdam ; Boston : Morgan Kaufmann, ©2004 1558609202 (DLC) 2004006193 (OCoLC)54775162 |
ISBN |
1417537078 (electronic bk.) |
|
9781417537075 (electronic bk.) |
|
1592782426 (electronic bk.) |
|
9781592782420 (electronic bk.) |
|
9780080491691 (electronic bk.) |
|
0080491693 (electronic bk.) |
|
9781558609204 |
|
1558609202 |
Standard No. |
B9781558609204X50004 |
|
9781558609204 |
|
(WaSeSS)ssj0000075776 |
|
AU@ 000051330404 |
|
AU@ 000051860785 |
|
AU@ 000067092944 |
|
CHBIS 005829822 |
|
CHNEW 001004712 |
|
CHVBK 168367068 |
|
DEBBG BV042307356 |
|
DEBBG BV043072446 |
|
DEBSZ 355438348 |
|
DEBSZ 405314728 |
|
DEBSZ 422372803 |
|
DEBSZ 430286309 |
|
DEBSZ 43418425X |
|
DKDLA 820120-katalog:9910110521105765 |
|
GBVCP 801178843 |
|
HEBIS 291508987 |
|
NZ1 12435727 |
|
UKMGB 017581798 |
|