SQLfX® is a very unique and breakthrough middleware native XML enabler product (the first of its kind) currently downloadable from Advanced Data Access Technologies, Inc. for beta testing. It automatically turns your SQL processor into a next generation ANSI SQL nonlinear (multi-leg) hierarchical processor that transparently integrates native XML and relational data whether or not your processor supports native XML. Only standard well known ANSI SQL is necessary to support this advanced hierarchical processing and the SQL user does not even need to know that XML data is being processed. Under the covers, SQLfX® has enabled the underlying customer's SQL processor to integrate relational and XML data at a full nonlinear hierarchical level to achieve hierarchically correct and automatically formatted structured XML results.
Who is SQLfX®'s customer
SQLfX®'s is for SQL shops and standard SQL applications that want or need to input and/or output native XML. Our customers can be non technical users interested in standard SQL type capabilities and not unconventional features introduced with XML. They do not want modified SQL syntax and semantics, or procedural operations to accommodate XML support. Transparent operation would be the best solution. They would be interested in new and value added capabilities that can be introduced from XML transparently. They want an XML solution that could be adapted as easily and quickly as possible without disturbing the status quo. They need SQL to continue operating consistently and accurately producing correct and reliable results for critical applications. SQLfX® satisfies these requirements and even delivers relational and hierarchical accuracy.
Another customer need is the ease and power of accessing entire XML structures in a true nonprocedural query fashion requiring no navigation. This implies the capability to nonlinearly process XML structures that is not found in XML processors today using XPath navigation, but occurs naturally in SQLfX®. For example, filtering the entire hierarchical structure based on a single node value occurrence located anywhere in the data structure.SQLfX® also supports a valuable XML interactive support with its full dynamic operation also not reasonably possible in XML procedural query languages today. A decision support capability is possible from the multi-leg nonlinear hierarchical processing capability which eliminates linear single leg processing restrictions and dynamically adds additional value to the data. This offers an ad hoc nonprocedural nonlinear hierarchical SQL/XML processor supplement for XQuery.
SQL customer SQL/XML needs and requirements:
1) Need natural support for inputting and outputting native XML 2) Are not interested in unconventional XML capabilities 3) Do not want SQL syntax or semantics changed to accommodate XML 4) Transparent XML integration would be best solution 5) Interest in value added XML capabilities introduced transparently 6) XML solution that can be adapted easily and quickly W/O disturbing status quo 7) SQL needs to keep operating accurately and consistently for critical apps 8) Non technical users can have full access to powerful hierarchical operations
How SQLfX® is Different
Probably the most significant problem with SQL native XML integration today is that every SQL native XML solution provider is bending over backwards to integrate as many of the new XML capabilities into SQL as it can. This has made these SQL native XML integration solutions XML centric and procedural, and goes directly against SQL's nonprocedural operation. Much of these new XML capabilities deals with the dynamic and irregular structures that a semistructured language like XML was designed to handle. Semistructured data is necessary for a markup language and has very little in common with a database language. Nevertheless, XML is being used as a database definition language. In these cases, the XML data structure is naturally more fixed and is based on predictable hierarchical semantics. This is the area where SQLfX® is applying its transparent XML integration.
No single XML processor can handle all the capabilities that XML will allow. The more defined to a limited scope, the more powerful and nonprocedural the SQL data processing language can be for its defined area of XML coverage. An SQL native XML integration solution should remain SQL centric in its syntax and operation. XML should be adapted to SQL and not the other way around. ANSI SQL's inherent hierarchical processing makes this very possible while retaining XML's hierarchical operation. This allows SQL's full relational and hierarchical processing capabilities to be naturally applied to XML making this solution the most powerful and easiest to use while remaining inline with what the SQL user wants and needs.
SQLfX®'s native XML integration capabilities that are different:
1) XML fully and naturally integrated transparently into SQL 2) Mathematically and hierarchically sound processing and results 3) Naturally supports full multi-leg hierarchical processing 4) ANSI SQL centric operation is well known and trusted 5) Nonprocedural and navigationless XML processing 6) Automatic nonprocedural structured XML generation 7) Natural hierarchical SQL view support 8) Powerful dynamic hierarchical optimization 9) Conceptual hierarchical operations such as joining hierarchical structures 10) Structure aware, operates intelligently on active hierarchical structure
How SQLfX® is Better than Other SQL Native XML Solutions
All other SQL native XML integration solutions require complex procedural processing to format the structured XML. These XML centric procedures change the look and feel of SQL into a procedural XML formatting language. With little or no hierarchically principled processing occurring in the current processing, the XML hierarchical result can be easily flawed.
The SQLfX® solution performs all of its hierarchical processing automatically using standard ANSI SQL processing. This hierarchical processing occurs consistently from input, through processing, to output. It is a very high level of hierarchical processing backed by hierarchical processing principles that can automatically handle internally complex multi-leg hierarchical queries automatically. This enables SQLfX® to solve all the SQL native XML integration problems naturally. All other SQL native XML integration solutions are failing in all aspects.
SQLfX®'s better solution solves these current industry problems:
1) Non ANSI standard (goes against the standard) 2) Proprietary (vendor adds own specific solution) 3) Incompatible with each other (vendor solutions are very different) 4) Require their own specific training (for their own version of XML support) 5) Require complex procedural XML centric syntax (hard to use) 6) Does not integrate relational and XML data well (invalid hierarchical results)
Even with all the above out-of-the-box solutions, vendors still have not solved the SQL/XML integration problem. SQLfX® solves all of these problems with its transparent and natural generic hierarchical processing which also significantly increases the customers' ROI for SQL native XML projects. This is because the customers' SQL processor with its data in place is immediately ready to support XML.
SQLfX® solves above problems producing no additional customer:
1) Preparation (changing SQL processors) 2) Coding (requiring procedural coding) 3) Training (XML and vendor specific training) 4) Manpower (transparent XML support means no additional coders) 5) Time to market (with none of the above, there is no additional time) 6) Risk (with none of the above, there is significantly reduced risk) 7) Maintenance (no need, XML is supported transparently)
SQL shops and applications are not in need of supporting XML's unconventional semistructured capabilities at a cost of not being able to support XML integration transparently. XML utilities or SQL external functions can handle the semistructured requirements such as handling markup. SQL users are interested in supporting more fixed hierarchical XML data input and output in the easiest and most natural SQL way possible. SQLfX® makes this possible using the customers' already in place SQL processors. In addition, SQLfX® has solved the SQL/XML integration problem transparently by utilizing ANSI SQL's natural hierarchical processing. This also means that this solution remains ANSI SQL standard, does not require XML centric functions, and delivers correct hierarchical results automatically. This is the perfect solution for SQL and XML integration.
For annotated view of the SQLfX® Query process Click Here