SQL:2003: Difference between revisions
Content deleted Content added
m →Summary: http→https for Google Books and Google News using AWB |
|||
| Line 12: | Line 12: | ||
* 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)|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= |
* [[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> |
||
==Documentation availability== |
==Documentation availability== |
||
Revision as of 06:39, 13 October 2016
SQL:2003 is the fifth revision of the SQL database query language. The latest revision of the standard is SQL:2011.
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:[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]
Documentation availability
The SQL standard is not freely available. SQL:2003 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.
- ISO/IEC 9075(1-4,9-11,13,14):2003 CD-ROM (352 CHF, or approximately 225 EUR, to order the CD)
- ISO/IEC 9075-1:2003 – Framework (SQL/Framework)
- ISO/IEC 9075-2:2003 – Foundation (SQL/Foundation)
- ISO/IEC 9075-3:2003 – Call-Level Interface (SQL/CLI)
- ISO/IEC 9075-4:2003 – Persistent Stored Modules (SQL/PSM)
- ISO/IEC 9075-9:2003 – Management of External Data (SQL/MED)
- ISO/IEC 9075-10:2003 – Object Language Bindings (SQL/OLB)
- ISO/IEC 9075-11:2003 – Information and Definition Schemas (SQL/Schemata)
- ISO/IEC 9075-13:2003 – SQL Routines and Types Using the Java Programming Language (SQL/JRT)
- ISO/IEC 9075-14:2003 – XML-Related Specifications (SQL/XML)
References
- ^ Eisenberg, Andrew; et al. (March 2004). "SQL:2003 Has Been Published". SIGMOD Record. 33 (1): 119. doi:10.1145/974121.974142. Archived from the original (pdf) on 2007-11-11. Retrieved 2007-08-14.
- ^ 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.
External links
- BNF Grammar for ISO/IEC 9075-1:2003 – SQL/Framework
- BNF Grammar for ISO/IEC 9075-2:2003 – SQL/Foundation