A friend was asking about managing hierarchies. I suggested this as a read.
http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/
Managing Hierarchical Data in MySQL | Mike Hillyer's Personal Webspace
Related Articles
September 29, 2012
Mental Floss: 5 Historical Attempts to Ban Coffee
September 11, 2013