The development of SQL language

1970:E.J Codd published the Theory of relational databases (relational database theory);

Based on the theory of Codd, 1974-79:IBM developed "Sequel" and renamed it "SQL".

1979:oracle released the commercial version of SQL

1981-84: There have been other commercial editions, from IBM (DB2), Data General (DG/SQL), relational Technology (INGRES), Sql/86:ansi and the first standard of ISO;

SQL/89: Added referential integrity (referential integrity); Sql/92 (aka SQL2): Accepted by the database management System (DBMS) manufacturer GF; 1997+: Become a Dynamic web Content) back-office support;

Sql/99:core level with the other 8 corresponding level, including recursive query, program and Process control, basic object support including OIDs;

SQL/2003: Contains XML-related content and automatically generates column values.

2005-9-30: "Data is the next generation inside ... SQL is the new

HTML "! Tim O ' eilly puts forward the Web 2.0 idea that the data will be the core and that SQL will become "new HTML";

SQL/2006: Defines the associated application of SQL with XML (including XQuery);

2006:sun will embed the SQL-based database management system in Java V6 2007:

SQL Server KATMI has enhanced its security on the basis of past SQL2005

Sex, mainly in: simple data encryption, foreign key management, enhanced review, improved database mirroring, plus

Stronger and more supportive.

The development of SQL language