The First Generation of Dedicated XML Structured Data Processing Increasing XML Structured Data Processing Capabilities While Making it Available to Nontechnical Users
Using structured data in XML was an afterthought. XML was designed for storing and processing markup. This does not allow XML structured data to be processed fully, properly, or accurately. What is needed is a dedicated XML structured data processor to take advantage of structured data’s specific characteristics and advantages. SQLfX® does this using ANSI SQL’s well known standard and friendly navigationless syntax and its recently discovered inherent hierarchical processing capability which transparently supports full multipath structured data processing not currently supported in XML processing. SQLfX® avoids today’s markup processing limitations of XML structured data and also utilizes XML structured data’s unique advantages that are not used or possible in markup processing. SQLfX® Solves Current XML Structured Data Processing Problems
Limited Hierarchical Processing and Structure Use
Industry’s current hierarchical processing’s single path limited processing can not utilize the hidden goldmine of semantic information in full multipath queries. Our discovery of inherent full multipath hierarchical processing in ANSI SQL allows for the automatic use of this goldmine of information by SQL. Being able to access and process your data using any combination of pathways greatly increases the value of your data which is also increased significantly by the expanding unlimited range of all possible queries. Requires XML Technical Knowledge to Use
Current XML hierarchical processing with its required user navigation requires use by technical users with XML knowledge and knowledge of the hierarchical structure being processed. This procedural user operation slows the development time. User navigation also limits the complexity of hierarchical processing that is possible to specify a query. ANSI SQL’s automatic navigationless hierarchal processing has no complexity limitations in the processing of complex multipath queries and can be specified easily by nontechnical users. Hierarchical Processing Accuracy Issues
There is no W3C standard or specification for hierarchical processing. Hierarchical processing is being left up to the separate vendors, developers and even the end users. ANSI SQL’s inherent multipath hierarchical processing is automatically following standard hierarchical principles which naturally produce correct results and can be trusted for critical applications. In order to have complete lossless hierarchical accuracy, relational and XML data have to be seamlessly integrated at a full hierarchical processing level preserving all of the hierarchical relationship semantic information required during hierarchical processing. Proprietary and Incompatible Solutions
Without a natural and complete relational/XML integration solution, inaccurate and proprietary solutions have had to be utilized by the separate vendors. These vendors have now branded their different proprietary nonstandard solutions. This has severely limited the success of SQL/XML data integration up until now. ANSI SQL’s inherent hierarchical processing can seamlessly integrate relational and XML data at a full hierarchical level. This preserves all of the hierarchical semantics which is used in performing advanced hierarchical operations automatically. These advanced hierarchical operations are naturally possible from the mapping of SQL and XML operations. Since ANSI SQL’s hierarchical processing is a subset of relational processing, many of these advanced operations are common to SQL and XML making them naturally generic and intuitive. For example, take hierarchical node promotion which is the slicing out unreferenced nodes in the hierarchical result. This same operation also occurs in relational processing; both are controlled by the SELECT operation. Ad Hoc Interactive Use is Not Practical
Current XML hierarchical processing requires user navigation. User navigation by its nature requires knowledge of the data structure by the user. This is not conducive to interactive processing. ANSI SQL’s inherent hierarchical processing supports automatic navigation of XML processing avoiding the navigation problem. Its multipath processing also means that the user is free to specify any query even if it involves multiple hierarchical pathways, eliminating single path restrictions. This makes ad hoc interactive processes very practical and significantly increases its usefulness with more powerful query processing. Current XML processors like XQuery require the processing logic and nesting structures to be tailored for each query. This is too time consuming for interactive processing. SQLfX® New XML Structured Data Capabilities Applications Hierarchical Query Output Display
Today there is no fast, easy and powerful way to query and hierarchically display XML structured data in an ad hoc fashion. XML documents are everywhere except they are hard to access. They require building an application even if it is being processed from XQuery which is really not a query language. SQLfX® makes this underutilized XML data immediately available. Using ANSI SQL, this display capability is easily performed navigationlessly initiated easily by nontechnical users. SQLfX unlike other XML processors is always aware of the structure being processed and can output the requested data in a multidimensional hierarchical display format that intuitivelyrepresents the hierarchical relationships to nontechnical users. This is also an excellent tool for helping to design and build new applications with.
Interactive Decision Support
Since ANSI SQL supports powerful hierarchical queries across multiple pathways, it can support decision support operations by being able to pose any query easily and it will be processed automatically and accurately regardless of the number of pathways involved. The number of different pathways used in a query is an indication that the query is complex involving a significant amount of inter-path semantics to solve. This complex query would not be possible if user navigation were required. With ANSI SQL navigationless processing, a nontechnical user can specify this query as simply as one that only uses a single pathway; the nontechnical user is unaware of this additional required processing. This demonstrates how multipath queries dynamically increase the use and value of the data. Automatic XML Publishing
With ANSI SQL’s dynamic hierarchical processing, the structure being processed can be built at run time by the dynamic joining of hierarchical structures. Since the result structure can be built dynamically, the output XML format must also be built dynamically. This makes it a perfect vehicle for fast, easy and flexible XML Publishing. Existing structures can be transformed and/or filtered for republishing. Multipath hierarchical structures require hierarchical structure filtering which ANSI SQL’s hierarchical processor does perform.
Hierarchical structures can be defined in standard SQL views using standard Left Outer Joins. Both logical relational and physical XML data structures can be modeled hierarchically in this way. These views can also be joined dynamically using a simple Left Outer Join. There is no limit to the number of views that can be joined into a larger combined hierarchical structure allowing for an unlimited number of structures with different semantics.
SQL’s powerful dynamic SELECT list controls what nodes of the hierarchical structure is output at runtime. If a node of the result structure as not data selected for output, the normal operation for hierarchical structures is to slice out the unreferenced node by a hierarchical process known as node promotion. So the SQL SELECT operation has a very flexible and powerful way of dynamically specifying and controlling the required processing and the most appropriate XML output format based on the structure and results. There are nonprocedural controls to override this standard dynamic processing. Such as turning off node promotion or using element mode formatting instead of attribute mode formatting. All of the Above
The above three ANSI SQL hierarchical query processing capabilities can be combined as needed to support any kind of immediate structured XML need.