Tree structures in relational data stores

http://fungus.teststation.com/~jon/treehandling/TreeHandling.htm

Handy to read, as it lets you run queries over collections when tree relationships dont matter as much. IE cascading security or calculating totals.