ANSI SQL Hierarchical Structured Data Report and Publishing Tool
SQLfX® is a simple to use extremely powerful standard ANSI SQL hierarchical structured data multi purpose SQL/XML query processor that can also be used to dynamically publish the result as a structured hierarchical XML Report. This full and accurate hierarchical processing of structured data for dynamic report publication is missing today.
SQLfX® can access and hierarchically combine any combination of flat, relational and hierarchical structured data assembling them dynamically and correctly into a virtual hierarchical structure. This heterogeneous virtual structure is then processed using our discovery of SQL’s full hierarchical processing capability to search, filter and summarize the virtual hierarchical data structure. The dynamically determined hierarchically accurate structured data result is then automatically formatted and published in structured XML based correctly on the resulting data structure optimally reflecting the data result’s structure.
The simple, flexible, and extremely powerful user controlled SQL SELECT list automatically controls the internal query operation and its output structure by dynamically including or excluding from the SELECT list of data items to be returned. The dynamically specified output items intrinsically controls the dynamic hierarchical processing required to produce the results consisting of the output data items requested based on the hierarchical structure defined in the query's data view. This allows the internal processing to change from query to query to match the desired output results while the global view remains the same. Advanced new any-to-any hierarchical structure transformations are possible in ANSI SQL to reuse structures by altering them and to further tailor the report structure dynamically.
XML structured data is extremely abundant and its hidden goldmine of global structured semantics can now be utilized. The multipath querying capability this tool enables, greatly and dynamically increases the value of the data used and the number of different queries possible many times over further increasing the data value.
What Makes this Product Unique
What is missing today from XML multipath structured data processing is that it needs to be hierarchically processed correctly (using a special LCA processing) to produce meaningful results. This is not being done today; our ANSI SQL XML hierarchical processor prototype is naturally performing this required LCA processing today in its interactive online prototype made available below. This capability today is known as Schema-free Query and XML Keyword Search which is still in academic research as part of the LCA research for XQuery. SQL’s inherent hierarchical processing also allows the previously unsolved relational/XML integration problem to be fully solved seamlessly at a lossless hierarchical processing level.
This full and correct structured data hierarchical processing is the next generation of XML support and it allows even more advanced hierarchical processing operations such as hierarchical structure data mashups and semantically driven any-to-any data structure transformations. To see and test all of these advanced XML capabilities try our online interactive live demo below.