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
March 27, 2014
Highcharts heatmap with canvas – JSFiddle
November 4, 2016