Take a look at the new version of this page: [ beta version ]. Tell us what you think.

ABSTRACT

The XML support in relational databases and the SQL/XML language are still relatively new as compared to purely relational databases and traditional SQL. Today, most database users have a strong relational and SQL background. SQL/XML enables users to perform queries and updates across XML and relational data, but many struggle with writing SQL/XML statements or XQuery update expressions. One reason is the novelty of SQL/XML and of the XQuery expressions that must be included. Another problem is that the tree structure of the XML data may be unknown or difficult to understand for the user. Evolving XML Schemas as well as hybrid XML/relational schemas make it even harder to write SQL/XML statements. Also, legacy applications use SQL but may require access to XML data without costly code changes.

Motivated by these challenges, we developed a method to generate SQL/XML query and update statements automatically. The input is either a GUI or a regular SQL statement that uses logical data item names irrespective of their actual location in relational or XML columns in the database. The output is a SQL/XML statement that queries or updates relational and XML data as needed to carry out the original user statement. This relieves the user and simplifies schema evolution and integration. We have prototyped and tested the proposed method on top of DB2 9.5.

REFERENCES

• 1: Andrew Eisenberg , Jim Melton, Advancements in SQL/XML, ACM SIGMOD Record, v.33 n.3, September 2004 [doi>10.1145/1031570.1031588]
• 2: Escobar, F. J. C. et al. "XML Information Retrieval Using SQL2Xquery", Tecnologico de Monterrey - Campus cd. De Mexico. Departmento do Computacin, 2002.
• 3: Alan Halverson , Vanja Josifovski , Guy Lohman , Hamid Pirahesh , Mathias Mörschel, ROX: relational over XML, Proceedings of the Thirtieth international conference on Very large data bases, p.264-275, August 31-September 03, 2004, Toronto, Canada
• 4: IBM, DB2 pureXML at Douglas Holding AG, http://www.ibm.com/software/success/cssdb.nsf/CS/LWIS-6XCUYX, Jan 2007.
• 5: IBM, DB2 pureXML at New York State Tax, ftp://ftp.software.ibm.com/common/ssi/pm/ab/n/imc14008usen/IMC14008USEN.PDF, Jan 2008.
• 6: IBM, DB2 pureXML at UCLA Health System, http://www.ibm.com/software/success/cssdb.nsf/CS/LWIS-7PKLWW, Feb 2009.
• 7: IBM, DB2 pureXML Case Studies, http://www.ibm.com/developerworks/wikis/display/db2xml/DB2+pureXML+Case+Studies
• 8: Jahnkuhn, H. et al. "Query Transformation of SQL into XQuery Within Federated Environments", QLQP 2006, EDBT Workshop, LNCS 4254.
• 9: Sunil Jigyasu , Sujeet Banerjee , Vinayak Borkar , Michael Carey , Kanad Dixit , Anil Malkani , Sachin Thatte, SQL to XQuery Translation in the AquaLogic Data Services Platform, Proceedings of the 22nd International Conference on Data Engineering, p.97, April 03-07, 2006 [doi>10.1109/ICDE.2006.147]
• 10: Loeser, H., Nicola, M. and Fitzgerald, J. "Index Challenges in Native XML Database Systems ", BTW 2009.
• 11: Ravi Murthy , Zhen Hua Liu , Muralidhar Krishnaprasad , Sivasankaran Chandrasekar , Anh-Tuan Tran , Eric Sedlar , Daniela Florescu , Susan Kotsovolos , Nipun Agarwal , Vikas Arora , Viswanathan Krishnamurthy, Towards an enterprise XML architecture, Proceedings of the 2005 ACM SIGMOD international conference on Management of data, June 14-16, 2005, Baltimore, Maryland [doi>10.1145/1066157.1066300]
• 12: Nicola, M. and Kumar-Chatterjee, P. "DB2 pureXML Cookbook", IBM Press, ISBN 0138150478, 2009.
• 13: Michael Rys, XML and relational database management systems: inside Microsoft® SQL Server™ 2005, Proceedings of the 2005 ACM SIGMOD international conference on Management of data, June 14-16, 2005, Baltimore, Maryland [doi>10.1145/1066157.1066301]
• 14: The XQuery Update Facility, http://www.w3.org/TR/xquery-update-10/

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.3 Languages
          Subjects: Query languages

General Terms:
Algorithms, Design, Languages

Keywords:
generation, mapping, sql, sql/xml, translation, xquery