- SQL/XML
The SQL/XML, or "XML-Related Specifications", extension to the
SQL standard is defined byISO /IEC 9075-14:2003. SQL/XML specifies SQL-based extensions for using XML in conjunction with SQL. TheXML data type is introduced, as well as several routines, functions, and XML-to-SQL data type mappings to support manipulation and storage of XML in a SQLdatabase .The SQL/XML specification includes functions to construct XML data. These functions allow the user to construct new XML elements or attributes with values e.g. from relational tables. Other functions such as XMLCONCAT or XMLAGG can be used to combine small XML fragments into larger ones. The list of available construction functions includes:
* XMLELEMENT
* XMLATTRIBUTES
* XMLFOREST
* XMLCONCAT
* XMLNAMESPACES
* XMLCOMMENT
* XMLPI
* XMLDOCUMENT
* XMLAGG
* etc.SQL/XML also defines functions which allow the user to embed
XQuery expressions inSQL statements. These functions include:* XMLQUERY
* XMLTABLEWhile XMLQUERY returns values of type XML, the function XMLTABLE can take XML data as input and produce a relational table as output.Predicates on XML data, such as search conditions, can be expressed with the XMLEXISTS predicate, typically in the WHERE clause of a SQL statement.
Further information and examples of the SQL/XML functions are provided in the external links below.
External links
* [http://www.sigmod.org/sigmod/record/issues/0409/11.JimMelton.pdf Advancements in SQL/XML] Andrew Eisenberg, Jim Melton; SIGMOD Record 33(3): 79-86 2004.
* [http://acm.org/sigmod/record/issues/0206/standard.pdf SQL/XML is Making Good Progress] Andrew Eisenberg, Jim Melton; SIGMOD Record 31(2): 101-108 2002.
* [http://sqlxml.org/ SQLXML.org]
* [http://sqlx.org/ SQLX.org]
Wikimedia Foundation. 2010.
