moinsen / Software historyDE ↗
← 1974

Event

Eine Abfragesprache für relationale Daten

Context and research status
  • Kennung: 1974-sequel-datenbank
  • Zeitraum: 1974
  • Datumsgenauigkeit: Jahr / year
  • Art: historische Entwicklung / historical development
  • Kategorien: Sprachen und Techniken, Ereignisse
  • Akteure und Rollen: Donald Chamberlin und Raymond Boyce: Autoren
  • Region: USA

In 1974 Donald Chamberlin and Raymond Boyce presented SEQUEL, a language for querying relational databases. Their original paper describes, among other things, the combination SELECT, FROM and WHERE. Original paper Source

One example in the paper asks for employees’ names in the toy department: SELECT NAME FROM EMP WHERE DEPT = 'TOY'. It illustrates specifying desired data and a condition. The authors contrasted this readable form with their earlier, more mathematical SQUARE notation. Original example

For historical comparison, the draft eliminated duplicate results by default in ordinary queries; queries using mathematical aggregate functions had a different default. Similar syntax therefore does not mean identical behavior in later SQL versions. Original paper

Sources

Das Forschungsprojekt System R erprobte eine frühe Teilmenge der Sprache. / The System R research project tested an early subset of the language.

Offen

Später folgten der amerikanische SQL-Standard 1986 und die erste ISO-Ausgabe 1987. Weitere Änderungen der Sprachversionen bleiben zu untersuchen. / The 1986 American SQL standard and first ISO edition in 1987 followed later. Further changes between language versions remain to be researched.