Event
Eine Abfragesprache für relationale Daten
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
Quellenhinweis: Konferenzbeitrag SIGFIDET 1974, bibliografische Angaben und Abstract.
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.