SQL with XML extensions (SQL/XML)

Retrieve data as part of SQL database queries

SQL/XML is a series of XML-related modules for the SQL database query language. Learn how this standard began, and read about the specifications that it covers.

Contributors:  ISO

25 April 2007 (First published 06 February 2007)

SQL/XML is a series of XML-related modules for the SQL database query language. Learn how this standard began, and read about the specifications that it covers.

SQL with XML extensions (SQL/XML) is a new section of the SQL standard covering a whole raft of XML-related extensions to SQL. It is in iterative development and was the subject of Part 14 of SQL 2003 [ISO International Standard ISO/IEC 9075-14:2003], which has since been withdrawn as work continues on SQL/XML/XQuery integration. SQL/XML was originally developed by the "SQLX Informal Group of Companies," with leadership from IBM® and Oracle, and then in committee at the American National Standards Institute (ANSI), which is the standards organization in which SQL is maintained. The scope of SQL/XML encompasses (quoted from Andrew Eisenberg and Jim Melton):

  • Specifications for the representation of SQL data (specifically, rows and tables of rows, as well as views and query results) in XML form, and vice versa.
  • Specifications associated with mapping SQL schemata to and from XML schemata. This may include performing the mapping between existing arbitrary XML and SQL schemata.
  • Specifications for the representation of SQL Schemas in XML.
  • Specifications for the representation of SQL actions (insert, update, delete).
  • Specifications for messaging for XML when used with SQL.

SQL/XML is developed to be complementary to XQuery.

Resources

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=XML
ArticleID=193485
SummaryTitle=SQL with XML extensions (SQL/XML)
publish-date=04252007