SQL:2008

This article is about SQL:2008, a revision of the SQL standard. For background information about the SQL query language, see SQL.

SQL:2008 is the sixth revision of the ISO and ANSI standard for the SQL database query language. It was formally adopted in July 2008.^[1]

Summary

The SQL:2008 standard is split into several parts, covering the Framework, the Foundation, the Call-Level Interface, Persistent Stored Modules, Management of External Data, Object Language Bindings, Information and Definition Schemas, Routines and Types Using Java, and various "Related Specifications."

Additions to the Foundation include

enhanced MERGE and DIAGNOSTIC statements,
the TRUNCATE TABLE statement,
comma-separated WHEN clauses in a CASE expression,
INSTEAD OF database triggers
partitioned JOIN tables,
support for various XQuery regular expression/pattern-matching features, and
enhancements to derived column names.^[1]

The Related Specifications for XML defines ways in which SQL can be used in conjunction with XML, including importing and storing XML data in an SQL database, manipulating it within the database and publishing both XML and conventional SQL-data in XML form.^[2]

Documentation

The SQL standard is not freely available. The whole standard may be purchased from the ISO as ISO/IEC 9075(1-4,9-11,13,14):2008. The standard consists of the following parts:

ISO/IEC 9075-1:2008 Framework (SQL/Framework)
ISO/IEC 9075-2:2008 Foundation (SQL/Foundation)
ISO/IEC 9075-3:2008 Call-Level Interface (SQL/CLI)
ISO/IEC 9075-4:2008 Persistent Stored Modules (SQL/PSM)
ISO/IEC 9075-9:2008 Management of External Data (SQL/MED)
ISO/IEC 9075-10:2008 Object Language Bindings (SQL/OLB)
ISO/IEC 9075-11:2008 Information and Definition Schemas (SQL/Schemata)
ISO/IEC 9075-13:2008 SQL Routines and Types Using the Java TM Programming Language (SQL/JRT)
ISO/IEC 9075-14:2008 XML-Related Specifications (SQL/XML)

Claims of conformance

The minimum level of conformance to SQL:2008 that a product can claim is called "Core SQL:2008" and is limited to definitions specified in two parts of the standard: the Foundation and the Information and Definition Schemas.^[3]

References

1 2 SQL:2008 now an approved ISO International Standard, a July 29th, 2008 blog post from a Sybase blog
↑ International Organization for Standardization: "ISO/IEC 9075-14:2008"
↑ Oracle Compliance To Core SQL:2008 from Oracle Corporation

External links

Freely downloadable drafts of this standard

SQL

Versions	SQL-86 SQL-89 SQL-92 SQL:1999 SQL:2003 SQL:2006 SQL:2008 SQL:2011

Keywords	As Case Create Delete From Having Insert Join Merge Null Order by Prepare Select Truncate Union Update Where With

Related	Edgar Codd Relational database

ISO/IEC SQL parts	Framework Foundation Call-Level Interface Persistent Stored Modules Management of External Data Object Language Bindings Information and Definition Schemas SQL Routines and Types for the Java Programming Language XML-Related Specifications

This article is issued from Wikipedia - version of the 6/30/2014. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.