Jump to content

SQL:2003: Difference between revisions

From Wikipedia, the free encyclopedia
Browse history interactively
← Previous edit
Content deleted Content added
VisualWikitext
Tijfo098 (talk | contribs)
16,966 edits
m v2.05b - Bot T20 CW#61 - Fix errors for CW project (Reference before punctuation)
 
(26 intermediate revisions by 22 users not shown)
Line 1: 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:2003''' is the fifth revision of the [[SQL]] [[database]] [[query language]]. The standard consists of 9 parts which are described in detail in [[SQL#Interoperability and standardization|SQL]]. It was updated by [[SQL:2006]].


==New features==
⚫
'''SQL:2003''' is the fifth revision of the [[SQL]] [[database]] [[query language]]. The latest revision of the standard is [[SQL:2011]].
⚫
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|title=SQL:2003 Has Been Published|format=pdf|journal=SIGMOD Record|volume=33|issue=1|date=March 2004|accessdate=2007-08-14|doi=10.1145/974121.974142|pages=119–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}}</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 |archiveurl = http://web.archive.org/web/20071111200042/http://www.acm.org/sigmod/record/issues/0403/index.html#standards <!-- Bot retrieved archive --> |archivedate = 2007-11-11}}</ref>
* [[XML]]-related features ([[SQL/XML]])
* [[XML]]-related features ([[SQL/XML]])
* [[Window function (SQL)|Window functions]]
* [[Window function (SQL)|Window functions]]
Line 12: Line 11:
* extensions to the [[Data Definition Language|CREATE TABLE]] statement, to allow "CREATE TABLE AS" and "CREATE TABLE LIKE"
* extensions to the [[Data 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
* 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)|windowing function]].<ref name="JensenPedersen2010">{{cite book|author1=Christian S. Jensen|author2=Torben Bach Pedersen|author3=Christian Thomsen|title=Multidimensional Databases and Data Warehousing|url=http://books.google.com/books?id=7UJpcKbVcYkC&pg=PA26|year=2010|publisher=Morgan & Claypool Publishers|isbn=978-1-60845-537-9|page=26}}</ref>
* [[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==
==Documentation availability==
The SQL standard is not freely available. SQL:2003 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] 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.
The SQL standard is not freely available but 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] 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/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=34132 ISO/IEC 9075-1:2003] &ndash; Framework (SQL/Framework)
** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=34133 ISO/IEC 9075-2:2003] &ndash; Foundation (SQL/Foundation)
** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=34134 ISO/IEC 9075-3:2003] &ndash; Call-Level Interface (SQL/CLI)
** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=34135 ISO/IEC 9075-4:2003] &ndash; Persistent Stored Modules (SQL/PSM)
** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=34136 ISO/IEC 9075-9:2003] &ndash; Management of External Data (SQL/MED)
** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=34137 ISO/IEC 9075-10:2003] &ndash; Object Language Bindings (SQL/OLB)
** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=34917 ISO/IEC 9075-11:2003] &ndash; Information and Definition Schemas (SQL/Schemata)
** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?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/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=35341 ISO/IEC 9075-14:2003] &ndash; XML-Related Specifications (SQL/XML)


==References==
==References==
Line 31: Line 22:


==External links==
==External links==
* [http://savage.net.au/SQL/sql-2003-1.bnf.html BNF Grammar for ISO/IEC 9075-1:2003] &ndash; '''SQL/Framework'''
* [https://github.com/ronsavage/SQL BNF Grammar for ISO/IEC 9075:2003] &ndash; SQL/Framework
* [http://savage.net.au/SQL/sql-2003-2.bnf.html BNF Grammar for ISO/IEC 9075-2:2003] &ndash; SQL/Foundation
{{SQL}}
{{SQL}}

{{DEFAULTSORT:Sql:2003}}
{{DEFAULTSORT:Sql:2003}}
[[Category:SQL| ]]
[[Category:SQL|*]]
[[Category:Declarative programming languages]]
[[Category:Declarative programming languages]]
[[Category:Query languages]]
[[Category:Query languages]]


{{compu-lang-stub}}
{{database-stub}}

[[es:SQL:2003]]
[[ru:SQL:2003]]

Latest revision as of 05:29, 9 November 2024

SQL:2003 is the fifth revision of the SQL database query language. The standard consists of 9 parts which are described in detail in SQL. It was updated by SQL:2006.

New features

[edit]

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:[1]

  • XML-related features (SQL/XML)
  • Window functions
  • the sequence generator, which allows standardized sequences
  • two new column types: auto-generated values and identity-columns
  • the new MERGE statement
  • extensions to the 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.[2]

For details see.[3]

Documentation availability

[edit]

The SQL standard is not freely available but may be purchased from ISO or ANSI. A late draft is available as a zip archive from Whitemarsh Information Systems Corporation. The zip archive contains a number of PDF files that define the parts of the SQL:2003 specification.

References

[edit]
  1. ^ Eisenberg, Andrew; et al. (March 2004). "SQL:2003 Has Been Published". SIGMOD Record. 33 (1): 119–126. doi:10.1145/974121.974142. Archived from the original (pdf) on 2007-11-11. Retrieved 2007-08-14.
  2. ^ Christian S. Jensen; Torben Bach Pedersen; Christian Thomsen (2010). Multidimensional Databases and Data Warehousing. Morgan & Claypool Publishers. p. 26. ISBN 978-1-60845-537-9.
  3. ^ SQL:2003 Has Been Published
[edit]
Retrieved from "https://en.wikipedia.org/enwiki/w/index.php?title=SQL:2003&oldid=1256293112"