Live briefing
Everything about SQL/XML
Database specification
SQL/XML or XML-Related Specifications is part 14 of the Structured Query Language (SQL) specification. In addition to the traditional predefined SQL data types like NUMERIC, CHAR, TIMESTAMP, ... it introduces the predefined data type XML together with constructors, several routines, functions, and XML-to-SQL data type mappings to support manipulation and storage of XML in a SQL database.SQL:2003-14 defines the basic datatype, mappings, predicates and functions. SQL:2006-14, SQL:2008-14 and SQL:2011-14 expands the older versions and approaches to XQuery. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: SQL/XMLA 5-minute orientation
- Skim a recent paper: Bipartite-Grammar–Aware Pretraining for XML-SQL Code UpdatingInfluential work since 2022
- Pick up a classic book: Querying XMLThe most-reprinted book on the subject
- Read the landmark paper: MeMo: a hybrid SQL/XML approach to metabolomic data management for functional genomicsCited 37 times
- Go sideways: XQuery API for JavaA closely related topic
- Go sideways: SQLA closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
MeMo: a hybrid SQL/XML approach to metabolomic data management for functional genomics
SQL/XML is making good progress
Advancements in SQL/XML
DB2 goes hybrid: Integrating native XML and XQuery with relational data and SQL
Storing XML (with XSD) in SQL databases: interplay of logical and physical designs
XML programming with SQL/XML and XQuery
Advantages of complex SQL types in storing XML documents
A distributed scientific data archive using the Web, XML and SQL/MED
🆕 Influential since 2022
📚 Books worth reading
Querying XMLJim Melton · 2006
Professional SQL Server 2005 XMLScott Klein · 2005
SQL Server 2000 XML DistilledKevin Williams · 2002
SQL Server 2000 yu XML zheng he ying yongZhaoyang Shen · 2001- 📕Advanced Oracle SQL programmingLaurent Schneider · 2008
XML and SQL Server 2000John Griffin · 2002
Pro SQL server 2008 XMLMichael Coles · 2008
Scripting XML and WMI for Microsoft SQL server 2000Tobias Martinsson · 2001
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- XQuery API for Java XQuery API for Java (XQJ) refers to the common Java API for the W3C XQuery 1.0 specification. The XQJ API enables Java programmers to execute XQuery against…
- SQL Structured Query Language (SQL) (pronounced /ˌɛsˌkjuˈɛl/ S-Q-L; or alternatively as /ˈsiːkwəl/ "sequel") is a domain-specific language used to manage data…
- SQL:2011 SQL:2011 or ISO/IEC 9075:2011 (under the general title "Information technology – Database languages – SQL") is the seventh revision of the ISO (1987) and…
- XML database An XML database is a data persistence software system that allows data to be specified, and stored, in XML format. This data can be queried, transformed…
- SQL/PSM SQL/PSM (SQL/Persistent Stored Modules) is an ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures…
- Database trigger A database trigger is procedural code that is automatically executed in response to specific events on a table or view in a database. Triggers are commonly…
- Hierarchical and recursive queries in SQL A hierarchical query is a type of SQL query that handles hierarchical model data. These are useful for working with databases of graph-structured data…
- XPath XPath (XML Path Language) is an expression language designed to support the query or transformation of XML documents. It was defined by the World Wide…