skip to main content
10.1145/1645953.1646104acmconferencesArticle/Chapter ViewAbstractPublication PagescikmConference Proceedingsconference-collections
research-article

Generating SQL/XML query and update statements

Published: 02 November 2009 Publication History

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]
Eisenberg, A. and Melton, J. "Advancements in SQL/XML", ACM SIGMOD Record, 33 (2), 79--86, 2004.
[2]
Escobar, F. J. C. et al. "XML Information Retrieval Using SQL2Xquery", Tecnologico de Monterrey - Campus cd. De Mexico. Departmento do Computacin, 2002.
[3]
Halverson, A. et al. "ROX: Relational over XML". Internat. Conference on Very Large Data Bases, 264--275, 2004.
[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]
Jigyasu, S. et al. "SQL to XQuery Translation in the AquaLogic Data Service Platform", ICDE 2006.
[10]
Loeser, H., Nicola, M. and Fitzgerald, J. "Index Challenges in Native XML Database Systems ", BTW 2009.
[11]
Murthy, R. et al. "Towards an enterprise XML architecture", SIGMOD Conference, p. 953--957, 2005.
[12]
Nicola, M. and Kumar-Chatterjee, P. "DB2 pureXML Cookbook", IBM Press, ISBN 0138150478, 2009.
[13]
Rys, M. "XML and Relational Database Management Systems: Inside Microsoft SQL Server", SIGMOD 2005.
[14]
The XQuery Update Facility, http://www.w3.org/TR/xquery-update-10/

Cited By

View all
  • (2018)S2CXInformation Systems10.1016/j.is.2015.09.01156:C(198-213)Online publication date: 30-Dec-2018
  • (2013)Join queries translation from SQL to XPath2013 IEEE International Conference ON Emerging Trends in Computing, Communication and Nanotechnology (ICECCN)10.1109/ICE-CCN.2013.6528521(364-349)Online publication date: Mar-2013
  • (2012)Generalizing and Improving SQL/XML Query EvaluationProceedings of the 2012 Eighth International Conference on Signal Image Technology and Internet Based Systems10.1109/SITIS.2012.72(441-449)Online publication date: 25-Nov-2012
  • Show More Cited By

Index Terms

  1. Generating SQL/XML query and update statements

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    CIKM '09: Proceedings of the 18th ACM conference on Information and knowledge management
    November 2009
    2162 pages
    ISBN:9781605585123
    DOI:10.1145/1645953
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 02 November 2009

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. generation
    2. mapping
    3. sql
    4. sql/xml
    5. translation
    6. xquery

    Qualifiers

    • Research-article

    Conference

    CIKM '09
    Sponsor:

    Acceptance Rates

    Overall Acceptance Rate 1,861 of 8,427 submissions, 22%

    Upcoming Conference

    CIKM '25

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)5
    • Downloads (Last 6 weeks)0
    Reflects downloads up to 18 Feb 2025

    Other Metrics

    Citations

    Cited By

    View all
    • (2018)S2CXInformation Systems10.1016/j.is.2015.09.01156:C(198-213)Online publication date: 30-Dec-2018
    • (2013)Join queries translation from SQL to XPath2013 IEEE International Conference ON Emerging Trends in Computing, Communication and Nanotechnology (ICECCN)10.1109/ICE-CCN.2013.6528521(364-349)Online publication date: Mar-2013
    • (2012)Generalizing and Improving SQL/XML Query EvaluationProceedings of the 2012 Eighth International Conference on Signal Image Technology and Internet Based Systems10.1109/SITIS.2012.72(441-449)Online publication date: 25-Nov-2012
    • (2011)A query language for selecting, harmonizing, and aggregating heterogeneous XML dataInternational Journal of Web Information Systems10.1108/174400811111256627:1(62-99)Online publication date: 5-Apr-2011
    • (2011)A Systematic Management Method of ISO Information Security Standards for Information Security Engineering EnvironmentsInformatics Engineering and Information Science10.1007/978-3-642-25327-0_32(370-384)Online publication date: 2011
    • (2010)Lessons learned from DB2 pureXML applicationsProceedings of the 7th international XML database conference on Database and XML technologies10.5555/1888011.1888022(88-102)Online publication date: 17-Sep-2010
    • (2010)Lessons Learned from DB2 pureXML Applications: A Practitioner’s PerspectiveDatabase and XML Technologies10.1007/978-3-642-15684-7_8(88-102)Online publication date: 2010

    View Options

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Figures

    Tables

    Media

    Share

    Share

    Share this Publication link

    Share on social media