Joe Celko's Trees and Hierarchies in SQL for Smarties, 2nd Edition > Chapter 2: Adjacency List Model - Pg. 26: Safari Books Online

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

Joe Celko's Trees and Hierarchies in SQL for Smarties, 2nd Edition

Joe Celko's Trees and Hierarchies in SQL for Smarties, 2nd Edition

Search

Contents

Table of Contents

Joe Celko's: Trees and Hierarchies in Sql for Smarties

Chapter 1: Graphs, Trees, and Hierarchies

Chapter 2: Adjacency List Model

2.1 The Simple Adjacency List Model

2.2 The Simple Adjacency List Model Is Not Normalized

2.3 Fixing the Adjacency List Model

2.4 Navigation in Adjacency List Model

2.5 Inserting Nodes in the Adjacency List Model

2.6 Deleting Nodes in the Adjacency List Model

2.7 Leveled Adjacency List Model

Chapter 3: Path Enumeration Models

Chapter 4: Nested Sets Model of Hierarchies

Chapter 5: Frequent Insertion Trees

Chapter 6: 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: Graphs in SQL

Chapter 13: Petri Nets

Chapter 14: State Transition Graphs

Chapter 15: Hierarchical Database Systems (IMS)

URL

Help

CHAPTER 2 Adjacency List Model