XML Gave Us Back Hierarchical Structures AND SQLfX® Gives Back Hierarchical Processing
ANSI SQL’s naturally hierarchical left outer join operation automatically and inherently makes SQL processors operate fully hierarchically. This really means performing nonlinear hierarchical processing, something that is not being performed today in the XML industry. Amazingly this nonlinear processing was used heavily before the advent of relational processing, and now it is relational processing that is bringing it back naturally. This is possible because nonlinear hierarchical processing is a subset of relational processing. This means that this nonlinear hierarchical processing is relationally sound mathematically. And since it has been modeled hierarchically in SQL by relationships which exactly follow hierarchical principles, it produces only hierarchically correct results. This level of correctness is missing in the XML industry today.
SQLfX® brings all of these nonlinear hierarchical capabilities and more back using standard ANSI SQL. While the standard ANSI SQL processor is operating fully hierarchically when naturally modeled hierarchically using the left outer join, the relational engine is not aware of this. SQLfX® automatically and transparently extends this powerful hierarchical processing to include native XML processing. It externalizes SQL's hierarchical results which includes automatically producing fully structured and hierarchically correct XML output along with many other hierarchically related capabilities. These are all covered further in this web site, but one thing is for certain, nonlinear hierarchical processing will be coming back. It is an evolutionary natural principledand naturally existing technology with many features and capabilities that far exceeds XML’s linear limited processing today. Nonlinear hierarchical processing is an open door to unlimited capabilities like the following currently supported ones in SQLfX®.
Currently Supported Advanced SQLfX® Capabilties:
1) Accurate hierarchical results (follows hierarchical principles) 2) Full multi-leg query support (unlimited nonlinear query support) 3) Single view capability (ease of use, no penalty for large views) 4) Nonprocedural access (process queries not otherwise practical) 5) Increases value of data in multi-leg queries (uses hierarchical semantics) 6) Powerful hierarchical access optimization (based on runtime query) 7) Automatic multi-leg query coordination (automatic "LCA Query" processing) 8) High level hierarchical structure processing (conceptually performed) 9) Advanced capabilities (like linking below the root of the lower structure) A) Powerful any-to-any polymorphic structure reshaping