Educatifu
Open menu

The relational database

Edgar Codd proposes organising data as simple related tables queried by logic rather than physical layout — the model behind virtually every business database since.

1970Software

In 1970, Edgar "Ted" Codd, a researcher at IBM, published A Relational Model of Data for Large Shared Data Banks. It proposed a deceptively simple idea: store data in tables of rows and columns, and describe the relationships between them with mathematics rather than with the tangled pointers and file layouts databases used at the time.

Why it mattered

The key move was separating what the data means from how it is stored. A programmer could ask for information — "all customers in Paris who ordered last month" — without knowing anything about where the bytes physically lived. The database engine figured out how to fetch it.

This is the foundation of SQL and of relational systems like PostgreSQL, MySQL, Oracle and SQL Server that still run the world's banks, shops and governments decades later. By turning data management into a problem of clean logic and tables, Codd's model made large, reliable, shared databases practical — and earned him the Turing Award. Even today's "NoSQL" and cloud databases are, in large part, a conversation with the ideas he set down in that paper.

Sources

  1. [1]Relational model — Wikipediaen.wikipedia.org
  2. [2]Edgar F. Codd — Wikipediaen.wikipedia.org

← Back to the timeline

Bring us the problem, not a perfect specification

Tell us what needs to change, who it affects and any important deadline. We will review the context and reply with useful next questions.

  1. 01Share contextDescribe the workflow, constraint or risk.
  2. 02Clarify togetherWe identify missing facts and useful options.
  3. 03Choose a startAgree a focused assessment or delivery step.
Start a conversation