Several years ago, when we were developing an application for a customer, as we designed the database schema we kept encountering the same problem: hierarchical data structures. Forty percent of our data types were hierarchical (e.g., product structure, customers, geographical territories, sales organization structure, folders). Because of the hierarchical data structures, we experienced "table creep": We needed so many tables that we couldn't fit them all on our drawing board. Our solution was ...