[ XPath Part 6 ]

Fast, reliable data access for ODBC, JDBC, ADO.NET and XML

WSSC 2008: An event dedicated to SOA and Web Services Security

Need an expert for Java, XML and Web Services projects?

Got SOX compliance?

Business Intelligence with R&R ReportWorks

IBM eserver xSeries 306m 8849 - P4 3.4 GHz

Memory

PROLIANT BL20P G3 XEON 3.6G 2P

		XPath Navigation Limits SQL/XML Databases (Part 5)
TechNotes Logic in DB Beyond Java Data Access SOX SQL/XML Restructuring Trees Open Source BizIntel MySQL Drivers ODBC JDBC OLE DB .NET Podcast SQL:2003 MS SQL 2005 XML DBs XQuery Webcast XQuery SQL:2003 MS SQL 2005		<<Prev 1 2 3 4 5 6 7 8 9 Next >> Conclusion The XML processing industry has yet to advance beyond linear hierarchical database processing which is surprising since the nonlinear hierarchical processing advantages shown in this article are extremely beneficial and were in use three decades ago. Even XQuery designed from the ground up to process XML structures requires procedural navigation keeping its processing limited to linear processing for the most part. The main problem today preventing more advanced internally complex capabilities is the exclusive use in the database industry of procedural navigation being used which is not necessary most of the time for database processing. In fact, more complex, advanced, and accurate hierarchical processing is only reasonably possible with a nonprocedural navigation-less processing solution. Such a solution is both simpler to implement and more powerful in its processing as well as being hierarchically accurate. Fast, reliable data access for ODBC, JDBC, ADO.NET and XML These capabilities significantly increase the processing power of XML database processing and may take time for users and the industry to fully appreciate all the benefits. But even more important than these new capabilities, nonprocedural navigation-less processing also supplies the following important attributes currently missing today in XML database processing and are key to its success and faster adoption. These attributes are: easier to use, faster to specify, and more accurate. This enables non database professionals to quickly produce valuable trusted information and increase their ROI. Appendix: Example Nonprocedural Navigation-less Hierarchical XML Processor My company’s research into native XML nonprocedural navigation-less hierarchical access has resulted in the development of our SQLfX® beta product. It uses standard ANSI SQL to perform nonprocedural navigation-less hierarchical native XML and SQL database processing as mentioned previously. It demonstrates ease of use with dynamic hierarchically optimized global views and proves that navigation-less, multi-leg, and advanced nonprocedural hierarchical processing is possible today using standard ANSI SQL-92 syntax and semantics. A progression of three examples leading to the dynamic hierarchical joining of a relational and an XML hierarchical structure is demonstrated below using actual SQLfX® examples. The first example creates an SQL hierarchical logical global view using existing relational tables. The second example creates an SQL hierarchical physical global view from the elements of an XML document. The third example hierarchically and dynamically joins the data from the two heterogeneous hierarchical views using a single ANSI SQL join operation. It then hierarchically filters the combined hierarchical structure with a simple WHERE clause to automatically produce a valid and accurate formatted hierarchical XML result. << Prev 1 2 3 4 5 6 7 8 9 Next >> Database Server Watch  SQL Summit Home Page    Articles    © 2008, Ken North Computing LLC, All rights reserved.