Perhaps the book Joe Celko's Trees and Hierarchies in SQL for Smarties by Joe Celko would be of interest.

From the back cover:

In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics... These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more.