2013 IEEE 29th International Conference on Data Engineering (ICDE) (2006)
Apr. 3, 2006 to Apr. 7, 2006
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDE.2006.147
Sujeet Banerjee , Persistent Systems Pvt Ltd.
Sachin Thatte , BEA Systems, Inc.
Sunil Jigyasu , Persistent Systems Pvt Ltd.
Anil Malkani , BEA Systems, Inc.
Michael Carey , BEA Systems, Inc.
Vinayak Borkar , BEA Systems, Inc.
Kanad Dixit , Persistent Systems Pvt Ltd.
SQL has long been the standard language for retrieving and manipulating data in relational database systems. XML has become the standard format for data exchange, and XQuery is on its way to becoming the standard language for querying XML data. The BEA AquaLogic Data Services Platform provides a service-oriented, XML-based view of heterogeneous enterprise data sources and allows this view to be queried using XQuery. AquaLogic DSP includes a JDBC driver that connects the old (SQL) world with the new (XML) world via a SQL-to-XQuery translator. This paper outlines the issues related to creating such a driver and details the approach used to translate SQL queries into XQuery expressions. The paper also touches on performance considerations related to handling XML query results in a context where JDBC result sets are the desired output format.
Sujeet Banerjee, Sachin Thatte, Sunil Jigyasu, Anil Malkani, Michael Carey, Vinayak Borkar, Kanad Dixit, "SQL to XQuery Translation in the AquaLogic Data Services Platform", 2013 IEEE 29th International Conference on Data Engineering (ICDE), vol. 00, no. , pp. 97, 2006, doi:10.1109/ICDE.2006.147