2.1.05. SQL

  • Structured Query Language
  • Success of relational databases
  • Developed for SystemR at IBM
  • ANSI standardised
  • SQL-1986 (SQL1), ongoing extension
  • SQL-1992 (SQL2), current version (Oracle 9i)
  • SQL-1999 (SQL3), regular expression matching, recursive queries
  • SQL-2003, XML features, auto-generated columns