Thursday Apr 24, 2008

Database SQL standards

The SQL standards are unlike most other standards -- virtually no database vendor could claim full conformance of the latest standards. Often innovations and new extensions happen even before the standards are in place. Also it is common for vendors not to implement certain features depending on the returns Vs other factors.

National Institute of Standards and Technology (NIST) used to develop SQL conformance tests. NIST stopped developing SQL conformance tests since 1996. You can download the conformance test for SQL-92 from their SQL Test Suite Download page

Currently there is no international body which has developed conformance test for the latest standards SQL:1999 and SQL:2003. Neverthless, it pays to understand the history and high level understanding of the spec, if you are in the business of developing database or writing non-trivial database applications.

Here is the latest SQL:2008 draft standard if you like to take a look.

Here are some more interesting links :

About

thavaa

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today