It seems that the current direction of SQL/XML integration by all SQL vendors is to fully support XML type processing at all costs. This cost is changing SQL into a procedural XML centric language. Our philosophy for XML support in SQL is to keep SQL operating in its pristine natural nonprocedural manner and to process XML in a transparent SQL fashion, not sacrificing SQL's standard operation for XML specific processing. By utilizing ANSI SQL's inherent hierarchical processing capability, it is possible to remain ANSI standard while transparently integrating XML at hierarchical processing levels that greatly exceed current SQL/XML solutions that are XML centric and procedural.
We also realize that a complete SQL/XML integration solution requires two related capabilities. Not only the integration of relational and XML data, but also the integration of SQL and XML system capabilities. Our solution integrates hierarchical and relational data at a hierarchical level losing no data quality and utilizing the hierarchical semantics in the XML data. Our SQL and XML system capabilities integration is accomplished by our transparent operation. It enables all capabilities of ANSI SQL to be applied to native XML data while also inherently supporting XML's native hierarchical processing capabilities such as node promotion, fragment processing, structure transformation, and the support of variable structures supported in ANSI SQL. This is accomplished by utilizing the common capability of hierarchical processing.
Current Product: SQLfX®
Our current product in Beta is SQLfX® (SQL for XML)a breakthrough SQL-based EII middleware product which solves all of the XML integration problem areas identified on our Home and Company page. It does this using a standard and familiar ANSI SQL front-end middleware that can interface hierarchically to combinations of incompatible data access and database products using a unified standard SQL mapped virtualization layer. This will offer the only seamless, complete, and acceptable SQL-based native XML integration solution available.
This new level of SQL/XML processing is possible because it operates naturally within SQL's ANSI standard definition while inherently performing full hierarchical processing necessary for a complete and seamless XML integration. This transparently elevates the processing of the underlying SQL-based databases to a true hierarchical XML level, preserving time, money, and data while increasing and extending the value of existing database software and the data under its control.
Our SQLfX® product is truly the next generation product in the SQL/XML integration middleware market with unique capabilities not available anywhere else. It is the first product of its kind built from the ground up with a standard ANSI SQL interface that uses standard SQL syntax and semantics to directly and dynamically model and process the data hierarchically.
This hierarchical processing is required and necessary for complete native XML integration. This includes the SQL updating of relational tables using selected data from live native XML documents. It can also remove serious relational processing performance and memory bottlenecks, and enables continuous hierarchical processing when using SQL in XML environments.
Our hierarchical processing is so complete it exceeds the inherent hierarchical processing of XML-based query products with its full nonprocedural multi-leg (nonlinear) hierarchical structure processing support. This gives it access to the XML operating environment and enables it to also compete successfully against XML-based products, and support a consistent operation across both environments.
SQLfX® will significantly raise the bar for SQL/XML integration middleware in both the XML and SQL operating environments.
Our SQLfX® product is a horizontal database access and integration product that can be used in any vertical application. Its purchaser or user has one or more database access products and needs a standardized SQL-based middleware product that can easily, seamlessly, efficiently , and completely integrate their multiple vendor databases containing relational, XML, and legacy data transparently, requiring no special or XML centric coding.
XML integration will be a common requirement in the industry with XML popping up everywhere, and our product will be the only one that can handle this difficult problem of native XML integration completely, seamlessly, efficiently, and easily. Not one of these attributes can be found in any current SQL-based XML integration product.
Our SQLfX® product contains leading edge nonlinear hierarchical data access and integration technologies. These technologies supply the means to seamlessly and transparently integrate relational, native XML, and legacy data while utilizing a standard, familiar, and proven SQL interface.
These characteristics produce an important competitive advantage because it removes the major obstacle faced by database products-- customer hesitancy and uncertainty of investing time, money, and valuable data in a product with an unfamiliar and unproven proprietary interface.
Another important competitive advantage is that our standard ANSI SQL interface can inherently process hierarchical data sources hierarchically. This full utilizes and preserves their powerful hierarchical semantics and increases the value of the customer's data. This is an important and necessary capability missing from all other SQL-based products, allowing the hierarchical processing to remain constant and seamless.
A third competitive advantage is that our breakthrough capabilities are protected by an enabling technology patent and disruptive technology which produces a breakthrough standard SQL-based hierarchical integration product that can not be duplicated or copied.
Vendor SQL-based XML Feature Comparison
Our Next Product
We will also apply our real-time SQL hierarchical processing technologyto the development of an innovative SQL/XML ETL product that greatlyimproves upon the current level of operation and standardization for these bulk load type products. This will tightly integrate and coordinate this product with our real-time SQL-based hierarchical query product which will have a significant beneficial synergistic effect. This product will share and utilize SQL data modeling views which preserves the hierarchical semantics in the XML data and elevates the processing to a full hierarchical processing level.
The current technology level of SQL/XML ETL products flatten and shred XML data, do not fully utilize the hierarchical XML data, and experience memory and processing inefficiencies caused by flattening the data. Our SQL/XML ETL product, like our real-time SQL-based XML native XML integration product, will not experience these problems and will work together in a unified fashion to produce a single homogeneous ANSI SQL backed solution.
Our SQL Native XML Integration Solution is ANSI Standard
Our solution is not another proprietary solution where we decided how it will operate and what new XML centric syntax will be added, nor is it another standardization attempt where external operations with their XML centric syntax are classified as new SQL standards. Both of these methods do not work because they can not seamlessly integrate relational and XML data.
Our solution does not add SQL syntax or define how the integration is to operate. It utilizes SQL's inherent hierarchical processing to seamlessly and completely integrate relational and XML data naturally using the ANSI SQL hierarchical semantics. So our seamless and complete solution remains ANSI SQL standard, mathematically accurate, and hierarchically precise.
Our solution is hierarchically processing centric which means it can be use for all data sources that are hierarchical or flat, not just XML. These can include legacy data. This means that specialized XML centric syntax is not needed for XML, and since SQL can perform hierarchical processing naturally, no additional hierarchical syntax is required, but does leave the door open for extended hierarchical processing that naturally utilizes the inherent hierarchical process in ANSI SQL.
Benefits of Transparent Native XML Support in SQL
Besides the advantages that no XML coding, debugging or training is necessary either for XML in general or for the product interface, it also means that that all of SQL's capabilities automatically operate on XML. XML data does not have to be handled separately by special XML centric functions. SQL's full and complete data processing capabilities are available to the XML data. Additionally, with our solution, standard SQL is operating hierarchically so that XML's transparent integration is operating hierarchically across all of SQL's capabilities. This also means that users and developers do not have be concerned with the data structure and navigation, even multi-leg queries are navigated automatically and transparently, and produce the correct hierarchical results based on the hierarchical semantics of the SQL query and data structure.
Our Solution Increases Data Value and Lowers Development Cost
Current SQL native XML integration is fraught with problems as mentioned in the competitive analysis above. This results in XML centric and proprietary solutions that usually require very complex procedural code to process XML. Our technology removes this problem making XML integration transparent which also keeps the processing nonprocedural and able to be specified intuitively and performed dynamically. This dynamic, ad hoc processing ability also directly helps in the analysis and design of the project as indicated in the chart below. The project savings using SQL with our transparent XML integration technology can reduce the overall development effort of XML-aware SQL by 60%. This does not take into consideration the savings in XML training, greatly increasedresource utilization, or the increased value and availability of XML data as described above.