IBM®
Skip to main content
    Country/region [change]    Terms of use
 
 
 
    Home    Products    Services & solutions    Support & downloads    My account    

IBM Systems Journal
Celebrating 10 Years of XML   Volume 45, Number 2, 2006
Table of contents: HTMLPDF This article: HTMLPDF   Copyright info

Integration of SQL and XQuery in IBM DB2 - References

 by F. Özcan,
D. Chamberlin,
K. Kulkarni,
and J.-E. Michels
Cited references and notes

  1. ISO 8879:1986, International Organization for Standardization (ISO), Information Processing—Text and Office Systems—Standard Generalized Markup Language (SGML).
  2. ANSI/ISO/IEC 9075-2:2003, International Organization for Standardization (ISO), Information Technology—Database Languages—SQL—Part 2: Foundation (SQL/Foundation).
  3. Extensible Markup Language (XML) 1.0 (Third Edition), T. Bray, J. Paoli, C. M. Sperberg-McQueen, E. Maler, and F. Yergeau, Editors, W3C Recommendation (February 4, 2004), http://www.w3.org/TR/2004/REC-xml-20040204.
  4. XML Schema, The XML Schema Working Group, http://www.w3.org/XML/Schema.
  5. XML Path Language (XPath) Version 1.0, J. Clark and S. DeRose, W3C Recommendation (November 16, 1999), http://www.w3.org/TR/xpath.
  6. XSL Transformations (XSLT) 1.0, J. Clark, Editor, W3C Recommendation (November 16, 1999), http://www.w3.org/TR/xslt.
  7. World Wide Web Consortium, http://www.w3c.org.
  8. QL'98: The W3C Query Languages Workshop, Boston, MA (1998), http://www.w3.org/TandS/QL/QL98.
  9. D. Chamberlin, D. Draper, M. Fernández, M. Kay, J. Robie, M. Rys, J. Siméon, J. Tivy, and P. Wadler, XQuery from the Experts: A Guide to the W3C XML Query Language, H. Katz, Editor, Addison-Wesley, Boston, MA (2003).
  10. XQuery 1.0: An XML Query Language, S. Boag, D. Chamberlin, M. F. Fernández, D. Florescu, J. Robie, and J. Siméon, W3C Recommendation (November 3, 2005), http://www.w3.org/TR/xquery.
  11. W3C XML Query (XQuery), http://www.w3.org/XML/Query/.
  12. XQuery 1.0 and XPath 2.0 Data Model, M. F. Fernández, A. Malhotra, J. Marsh, M. Nagy, and N. Walsh, Editors, W3C Working Draft (November 3, 2005), http://www.w3.org/TR/xpath-datamodel/.
  13. Namespaces in XML, T. Bray, D. Hollander, and A. Layman, Editors, W3C Recommendation (January 14, 1999), W3C Recommendation, http://www.w3.org/TR/REC-xml-names/.
  14. ANSI/ISO/IEC 9075-14:2003, International Organization for Standardization (ISO), Information Technology—Database Language—SQL—Part 14: XML-Related Specifications (SQL/XML).
  15. ANSI/ISO/IEC 9075-14:2006, International Organization for Standardization (ISO). Information Technology—Database Language SQL—Part 14: XML-Related Specifications (SQL/XML); document expected to be published in mid 2006.
  16. XML Information Set (Second Edition), J. Cowan and R. Tobin, Editors, W3C Recommendation (February 4, 2004), http://www.w3.org/TR/xml-infoset/.
  17. XSLT 2.0 and XQuery 1.0 Serialization, S. Boag, M. Kay, J. Tong, N. Walsh, and H. Zongaro, Editors, WC3 Candidate Recommendation (November 3, 2005), http://www.w3.org/TR/xslt-xquery-serialization/.
  18. SQL/XML also provides an optional mechanism for passing an unnamed “context item” to an embedded XQuery expression; this mechanism is not currently supported by DB2.
  19. K. S. Beyer, R. J. Cochrane, V. Josifovski, J. Kleewein, G. Lapis, G. M. Lohman, B. Lyle, F. Özcan, H. Pirahesh, N. Seemann, T. C. Truong, B. van der Linden, B. Vickery, and C. Zhang, “System RX: One Part Relational, One Part XML,” Proceedings of the 24th ACM SIGMOD International Conference on Management of Data, Baltimore, MD (2005), pp. 347–358.
  20. K. S. Beyer, F. Özcan, S. Saiprasad, and B. van der Linden, “DB2/XML: Designing for Evolution,” Proceedings of the 24th ACM SIGMOD International Conference on Management of Data, Baltimore, MD (2005), pp. 948–952.
  21. M. Nicola and B. van der Linden, “Native XML Support in DB2 Universal Database,” 31st International Conference on Very Large Data Bases, Trondheim, Norway (2005), pp. 1164–1175.
  22. The db2-fn:sqlquery function does not provide any mechanism to pass parameters from XQuery to SQL.
  23. SQL/XML defines an XMLQuery option called RETURNING CONTENT, which implicitly adds a document node to the XML value before returning it. DB2 does not support this option because it causes unnecessary node construction. If a document node is desired, it can be generated easily by the embedded XQuery expression.
  24. Note the SQL use of the term schema is different from that in XML Schema. In SQL, a schema denotes a collection of tables, data types, and functions, which is roughly equivalent to an XML namespace.
  25. Even with static typing, it may not always be possible to distinguish between positional and Boolean predicates due to generic schema types, such as xs:anyType and optional elements.


    About IBM    Privacy    Contact