Material Insights · Understanding the Material World

Relational database: Science

Principles

The science it rests on, with why each principle matters to it

Relies on
  • Boolean logic A query picks rows with conditions joined by AND, OR and NOT, the algebra of true and false that Boole published in 1854 [7].

as of 2026-11-11

Discoveries

The discoveries that made it possible: when, by whom and what was found

YearWhoWhat
1854George BooleAn Investigation of the Laws of Thought, the algebra of logic used in query conditions [7]
1970Edgar F. Codd, IBM San Jose Research LabThe relational model: data in linkable tables, any new table obtainable by one query [1]
1974Donald Chamberlin and Raymond Boyce, IBMSEQUEL, a structured English query language, later called SQL [4]

as of 2026-11-11

The science explained

The science behind it explained for a curious reader

Before Codd, a program had to follow stored pointers from record to record, like walking a fixed path through a maze. If the maze changed, the program broke. Codd's idea, published in 1970 [1], was to treat data as plain tables and questions as operations on tables. Picture two lists in a filing cabinet: one of customers with their numbers, one of orders each marked with a customer number. To find what everyone in Leeds ordered, you do not need to know where the cards are filed. You state the rule: rows where the town is Leeds, matched on customer number. That rule is logic, built from AND, OR and NOT, the algebra Boole set out in 1854 [7]. Because the question names what is wanted, not how to get it, the database is free to store and index the tables however it likes.

as of 2026-11-11

Sources

  1. The relational database IBM
  2. Codd almighty! Has it been half a century of SQL already? The Register, 2024
  3. George Boole Linda Hall Library, Scientist of the Day