본문 바로가기

SQL

SQL:2008 is the sixth revision of the ISO and ANSI standard for the SQL database query language.해 주세요.


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]

Contents

 [hide]

[edit]Summary

The SQL:2008 standard is split into several parts, covering the Framework, the Foundation, the Call-Level InterfacePersistent Stored ModulesManagement of External DataObject Language BindingsInformation and Definition SchemasRoutines and Types Using Java, and various "Related Specifications."

Additions to the Foundation include

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]

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

[edit]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]

[edit]References

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


http://en.wikipedia.org/wiki/SQL:2008

'SQL' 카테고리의 다른 글

SYS_CONNECT_BY_PATH  (0) 2011.07.15
ANSI Standards  (0) 2011.07.15
SQL-92 was the third revision of the SQL database query language  (0) 2011.07.15
CBO 의 최적화 절차 순서  (0) 2011.05.08
Cost Based Optimizer  (0) 2011.05.08