I’m looking at ways to represent a hierarchical data structure (a la dmoz or Yahoo) in a relational database. I have some ideas, but I’m always looking for more.