moinsen / Software historyDE ↗
← 1970

Event

Ein relationales Modell für Datenbanken

Context and research status
  • Kennung: 1970-codd-relationales-modell
  • Zeitraum: 1970
  • Datumsgenauigkeit: Jahr / year
  • Art: historische Entwicklung / historical development
  • Kategorien: Sprachen und Techniken, Ereignisse
  • Akteure und Rollen: Edgar F. Codd: Autor; IBM Research: Forschung
  • Region: USA

Edgar F. Codd published a paper in June 1970 on a relational model for large shared databases. It describes data through relations and aims to make programs less dependent on physical data organization. Original paper Source

Codd illustrates the problem with data on parts, suppliers and projects: a program tailored to one tree structure can fail when that structure changes. One example relation describes shipments by part, supplier, project and quantity. The paper presents the model but explicitly does not discuss its implementation. Example and limits

Sources

IS/1 in Peterlee und später System R erprobten relationale Ansätze praktisch; SEQUEL beschrieb eine Abfragesprache. / IS/1 at Peterlee and later System R tested relational approaches in practice; SEQUEL described a query language.

Offen

Weitere frühe Implementierungen und den Weg zu SQL-Standards getrennt recherchieren. / Research other early implementations and the path to SQL standards separately.