Nested intervals tree encoding in SQL
Vadim Tropashko · ACM SIGMOD Record · 2005
Nested Intervals generalize Nested Sets. They are immune to hierarchy reorganization problem. They allow answering ancestor path hierarchical queries algorithmically - without accessing the stored hierarchy relation.