New Paper On: ANSI SQL Dynamic XML Hierarchical Processing

ANSI SQL Transparent XML Structured DataMultipath Hierarchical Processing with Dynamic Output

This is a new extensive paper describing and demonstrating new capabilities possible with ANSI SQL transparent XML multipath hierarchical processing that supports dynamic structured data processing and its dynamic structured XML output. This article is located on Slide Share. Its URL is:

http://www.slideshare.net/mmdavid/ansi-sql-transparent-xml-structured-data-multipath-hierarchical-processing-with-dynamic-output-2360420

This 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 naturally occurring Lowest Common Ancestor (LCA) processing in SQL which is occurring 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.

All of these capabilities described in the paper have been implemented and tested with our ANSI SQL Transparent XML Hierarchical Processor prototype available for interactive testing at www.adatinc.com/prototype.html and the results are used in the examples in the paper. The examples have been annotated with internal hierarchical processing diagrams to visually map the hierarchical processing occurring. This same navigationless hierarchical processing was commonplace more than three decades ago when hierarchical databases were popular. This proves that this multipath hierarchical data processing technology is not new and untested.

Regards,

/Mike

Michael M David
Advanced Data Access Technologies, Inc.