Joe Celko's Trees and Hierarchies in SQL for Smarties, 2nd Edition > 8.4 Path Enumeration Using Prime Number Products > 8.4.6 Decomposing a Path - Pg. : 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

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

8.1 Adjacency List with Self-References

8.2 Subordinate Adjacency List

8.3 Hybrid Models

8.4 Path Enumeration Using Prime Number Products

8.4.1 Find the Subordinates of a Node

8.4.2 Find the Superiors of a Node

8.4.3 Hierarchy with Levels

8.4.4 Insert New Employee under a Boss

8.4.5 Delete an Employee

8.4.6 Decomposing a Path

8.4.7 Helpful Functions

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