Maybe not that obscure, but Joe Celko’s Nested Set Model gave me exactly what I needed when I learned of it: fast queries on seldom-changing hierarchical database records.

Updates are heavy, but the reads are incredibly light.

https://en.wikipedia.org/wiki/Nested_set_model