CustomerCentrix

Occasionally, I come across an article that really strikes me as a new concept. Although as I suspected, it is not really new, using a nested model was new to me as described in this article.

I didn't know what it was called, but I have been using the "Adjacency List Model" for tree structures in SQL for decades. The tradeoffs that I see are that the nested model seems easier for the basic queries, but much more expensive for inserts and deletes because every other node must be adjusted.

Good reading along with the credits at the bottom for Joe Celko's book Trees and Hierarchies in SQL for Smarties.