|
|
This extensive paper introduces a number of problems with ANSI SQL's standard integration of native XML structured data that are preventing the full use of this technology and puts forth an advanced ANSI SQL working solution. The solution to these problems is based on ANSI SQL’s dynamic inherent multipath nonlinear hierarchical processing capability. This paper explains how this previously unrealized multipath processing capability requires an inherently occurring Lowest Common Ancestor (LCA) processing in SQL which occurs naturally in ANSI SQL today and is currently being academically researched for use by XQuery.
The automatic utilization of this powerful LCA processing by ANSI SQL completely solves multipath structured data hierarchical integration and processing problems seamlessly and naturally at a transparent full hierarchical processing level. This also enables advanced structured data processing capabilities with correct XML results that can also support on-demand structured data XML output and report publishing. These advanced dynamic structure operations are supported by the use of a powerful structure-aware capability made possible from meta information naturally available from ANSI SQL's automatic hierarchical processing operation.
Tags: Schema-Free Query, XML Keyword Search, Twig Queries, Nearest Common Ancestor.
|