# Relational database: Science

Source page: https://www.materialinsights.org/technologies/relational_database/tech-science/

#### Principles

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

- [Boolean logic](https://www.materialinsights.org/science/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

1. [The relational database](https://www.ibm.com/history/relational-database) IBM
2. [Codd almighty! Has it been half a century of SQL already?](https://www.theregister.com/2024/05/31/fifty_years_of_sql/) The Register, 2024
3. [George Boole](https://www.lindahall.org/about/news/scientist-of-the-day/george-boole/) Linda Hall Library, Scientist of the Day

## Other sections

- [Summary](https://www.materialinsights.org/technologies/relational_database/index.md)
- [Overview](https://www.materialinsights.org/technologies/relational_database/tech-overview/index.md)
- [Evolution](https://www.materialinsights.org/technologies/relational_database/tech-evolution/index.md)
- [Energy footprint](https://www.materialinsights.org/technologies/relational_database/tech-energy-footprint/index.md)
- [Industries](https://www.materialinsights.org/technologies/relational_database/tech-industries/index.md)
