SQL:2003: Difference between revisions

Revision as of 08:51, 15 January 2009

Latest revision as of 03:07, 20 July 2025

(47 intermediate revisions by 40 users not shown)

Line 1:

{{Short description|2003 edition of the SQL standard}}

{{dablink|This article is about '''SQL:2003''', a revision of the [[SQL]] standard. For more information about SQL, see the main [[SQL]] article.}}

{{SQL language revisions}}

'''SQL:2003''' is the fifth revision of the [[SQL]] [[database]] [[query language]]. The lateststandard revisionconsists of the9 standardparts which are described in detail in [[SQL#Interoperability and standardization|SQL]]. It was updated isby [[SQL:2006]].

==New features==

'''SQL:2003''' is the fifth revision of the [[SQL]] [[database]] [[query language]]. The latest revision of the standard is [[SQL:2006]].

The SQL:2003 standard makes minor modifications to all parts of [[SQL:1999]] (also known as SQL3), and officially introduces a few new features such as:<ref>{{cite journal|url=http://www.acm.org/sigmod/record/issues/0403/index.html#standards|last=Eisenberg|first=Andrew|coauthors=et al.|title=SQL:2003 Has Been Published|format=pdf|journal=SIGMOD Record|volume=33|issue=1|monthdate=March|year= 2004|accessdate=2007-08-14|doi=10.1145/974121.974142|pages=119119–126 |archiveurl = https://web.archive.org/web/20071111200042/http://www.acm.org/sigmod/record/issues/0403/index.html#standards <!-- Bot retrieved archive --> |archivedate = 2007-11-11|display-authors=etal|url-access=subscription}}</ref>

==Summary==

The SQL:2003 standard makes minor modifications to all parts of [[SQL:1999]] (also known as SQL3), and officially introduces a few new features such as:<ref>{{cite journal|url=http://www.acm.org/sigmod/record/issues/0403/index.html#standards|last=Eisenberg|first=Andrew|coauthors=et al.|title=SQL:2003 Has Been Published|format=pdf|journal=SIGMOD Record|volume=33|issue=1|month=March|year=2004|accessdate=2007-08-14|doi=10.1145/974121.974142|pages=119}}</ref>

* [[XML]]-related features ([[SQL/XML]])

* ''window[[Window function (SQL)|Window functions'']]

* the sequence generator, which allows standardized sequences

* two new column types: auto-generated values and identity-columns

* the new [[Merge (SQL)|MERGE]] statement

* extensions to the [[CreateData (SQL)Definition Language|CREATE TABLE]] statement, to allow "CREATE TABLE AS" and "CREATE TABLE LIKE"

* removal of the poorly- implemented "BIT" and "BIT VARYING" data types

* [[OLAP]] capabilities (initially added in [[SQL:1999]]) were extended with a [[Window function (SQL)|window function]].<ref name="JensenPedersen2010">{{cite book|author1=Christian S. Jensen|author2=Torben Bach Pedersen|author3=Christian Thomsen|title=Multidimensional Databases and Data Warehousing|url=https://books.google.com/books?id=7UJpcKbVcYkC&pg=PA26|year=2010|publisher=Morgan & Claypool Publishers|isbn=978-1-60845-537-9|page=26}}</ref>

For details see.<ref>[http://sigmodrecord.org/publications/sigmodRecord/0403/E.JimAndrew-standard.pdf SQL:2003 Has Been Published]</ref>

==Documentation availability==

The SQL standard is not freely available. SQL:2003but may be purchased from [http://www.iso.org/ ISO] or [http://webstore.ansi.org/ ANSI]. A late draft is available as a [http://www.wiscorp.com/sql_2003_standard.zip zip archive] {{Webarchive|url=https://web.archive.org/web/20160330011635/http://www.wiscorp.com/sql_2003_standard.zip |date=2016-03-30 }} from [http://www.wiscorp.com/ Whitemarsh Information Systems Corporation]. The zip archive contains a number of [[Portable Document Format|PDF]] files that define the parts of the SQL:2003 specification.

* ISO/IEC 9075(1-4,9-11,13,14):2003 CD-ROM (352 [[Swiss franc|CHF]], or approximately 225 [[Euro|EUR]], to order the CD)

** [http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34132 ISO/IEC 9075-1:2003] &ndash; Framework (SQL/Framework)

** [http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34133 ISO/IEC 9075-2:2003] &ndash; Foundation (SQL/Foundation)

** [http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34134 ISO/IEC 9075-3:2003] &ndash; Call-Level Interface (SQL/CLI)

** [http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34135 ISO/IEC 9075-4:2003] &ndash; Persistent Stored Modules (SQL/PSM)

** [http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34136 ISO/IEC 9075-9:2003] &ndash; Management of External Data (SQL/MED)

** [http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34137 ISO/IEC 9075-10:2003] &ndash; Object Language Bindings (SQL/OLB)

** [http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34917 ISO/IEC 9075-11:2003] &ndash; Information and Definition Schemas (SQL/Schemata)

** [http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=37102 ISO/IEC 9075-13:2003] &ndash; SQL Routines and Types Using the [[Java (programming language)|Java]] Programming Language (SQL/JRT)

** [http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=35341 ISO/IEC 9075-14:2003] &ndash; XML-Related Specifications (SQL/XML)

==DBMS compliance==

Since the SQL:2003 standard is relatively new, few [[DBMS]] implementations are able to claim full compliance with it yet. However, most vendors have partial compliance with the core SQL:2003 features, for example [[data dictionary]] functions, and sometimes have legacy, non-standard syntax equivalents that they had introduced prior to the SQL:2003 standard.

* [[Oracle database|Oracle]] <ref>{{cite web|url=http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/ap_standard_sql003.htm|title=Oracle Compliance To Core SQL:2003|publisher=Oracle|accessdate=2007-05-27}}</ref>

* [[PostgreSQL]] <ref>{{cite web|url=http://developer.postgresql.org/pgdocs/postgres/features.html|work=PostgreSQL 8.3devel Documentation|title=PostgreSQL: SQL Conformance|publisher=PostgreSQL.org|accessdate=2007-05-27}}</ref><ref>{{cite web|url=http://developer.postgresql.org/pgdocs/postgres/unsupported-features-sql-standard.html|work=PostgreSQL 8.3devel Documentation|title=PostgreSQL: Unsupported Features|publisher=PostgreSQL.org|accessdate=2007-05-27}}</ref><ref>{{cite web|url=http://developer.postgresql.org/pgdocs/postgres/features-sql-standard.html|work=PostgreSQL 8.3devel Documentation|title=PostgreSQL: Supported Features|publisher=PostgreSQL.org|accessdate=2007-05-27}}</ref>

* [[MySQL]] <ref>{{cite web|url=http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html|title=MySQL Documentation on Stored Procedures|publisher=MySQL|accessdate=2007-08-14|quote=MySQL follows the SQL:2003 syntax for stored routines, which is also used by IBM's DB2.}}</ref>

* [[Firebird (database server)]] <ref>{{cite web|url=http://www.firebirdsql.org/index.php?op=devel&sub=engine&id=SQL_conformance|title=SQL Standard Conformance|publisher=Dmitry Yemanov(Firebird Foundation)|accessdate=2006-02-11|quote=This document outlines how much Firebird conforms to the current SQL standard.}}</ref>

* [[JavaDB|Apache Derby]] <ref>{{cite web|url=http://wiki.apache.org/db-derby/SQLvsDerbyFeatures|title=Derby Features|publisher=Apache}}</ref>

* [[Ingres]]<ref>{{cite web|url=http://www.ingres.com/products/ingres-database.php|title=Ingres Database|publisher=Ingres}}</ref>

{{Expand list|date=August 2008}}

==References==

Line 41 ⟶ 23:

==External links==

* [httphttps://savagegithub.net.aucom/ronsavage/SQL/sql-2003-1.bnf.html BNF Grammar for ISO/IEC 9075-1:2003] &ndash; '''SQL/Framework'''

{{SQL}}

* [http://savage.net.au/SQL/sql-2003-2.bnf.html BNF Grammar for ISO/IEC 9075-2:2003] &ndash; SQL/Foundation

{{DEFAULTSORT:Sql:2003}}

[[Category:SQL| *]]

[[Category:Declarative programming languages]]

[[Category:Query languages]]

{{compu-lang-stub}}

{{database-stub}}

[[es:SQL:2003]]

[[ru:SQL:2003]]