A lot of things presented in this article reminded me of the same things that were in Joe Celko's “Trees and Hierarchies in SQL” book https://www.oreilly.com/library/view/joe-celkos-trees/978155...