Joe Celko's Trees and hierarchies in SQL for smarties

Wow, you have to work hard to keep up with this very advanced book. It's sitting on my shelf as an essential reference book.

I have some prior Joe Celko books which have been my 'goto' books for SQL challenges. This one, in comparison to my other books, delves deeper and more technically into the specific areas of Trees and Hierarchies.

I feel graphs and tree are the core set of data structures used in most of the applications today and historically we have always modeled such network type data in relational databases for storage & retrieval. Naturally, the relational database doesn't fit out of the box to meet all read/aggregated read requirements for such data sets and even seasoned developers struggle to find a good solution to the problem at hand with such data.