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
| Year | Who | What |
|---|---|---|
| 1854 | George Boole | An Investigation of the Laws of Thought, the algebra of logic used in query conditions [7] |
| 1970 | Edgar F. Codd, IBM San Jose Research Lab | The relational model: data in linkable tables, any new table obtainable by one query [1] |
| 1974 | Donald Chamberlin and Raymond Boyce, IBM | SEQUEL, 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
- The relational database IBM
- Codd almighty! Has it been half a century of SQL already? The Register, 2024
- George Boole Linda Hall Library, Scientist of the Day