This blog is dedicated to hierarchical data processing, and ANSI SQL’s inherent ability to transparently and navigationlessly process multipath (nonlinear) hierarchical queries at a full hierarchical processing level. It covers all aspects of this new ability from hierarchical structure and processing principles to ANSI SQL’s transparent and navigationless extended advanced hierarchical XML processing and how and why this is possible. This new material is based on our extensive research and experience building the first ANSI SQL transparent XML hierarchical processor.