# Relational database: Overview

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

#### What it does

The job the technology does for people, in a short paragraph

A relational database keeps an organisation's records, such as accounts, orders and bookings, in linked tables and answers questions about them. Edgar Codd proposed the model in 1970 ^[1], and Oracle V2 brought it to market in 1979 ^[2]. It now underpins banking, card payments and travel reservations ^[1], and SQLite alone is thought to run in over a trillion databases ^[6].

as of 2026-11-11

#### How it works

The working principle in plain words, step by step

Data is split into tables. Each row is one record, such as a customer, and each column one fact about it. Every row has a key, a value that identifies it, and other tables refer to that key to link records: an order row holds the customer's number. A user writes a query in SQL saying what is wanted, for example all orders over a sum from customers in one city. The database, not the user, decides how to fetch it: it can combine tables and return an entirely new table from one query ^[1]. An optimiser picks the fastest route, using indexes, which work like the index of a book. Changes are grouped into transactions that complete fully or not at all, so a transfer never leaves money half moved.

as of 2026-11-11

#### Key figures

The handful of numbers that size it up, each with its unit, year and source

| Figure | Value | Unit | Year | Source |
|---|---|---|---|---|
| SQLite databases estimated in active use | 1000 billion | databases | 2026 | ^[6] |
| Smartphones in active use, each holding hundreds of SQLite database files | 4 | billion smartphones | 2026 | ^[6] |
| Relational systems among the five most popular database systems in the DB-Engines ranking | 4 | systems | 2025 | ^[5] |
| Oracle's rank among the world's software companies | 2 | rank | 2000 | ^[2] |

as of 2026-11-11. The SQLite estimates are the project's own; the page states no data year, and 2026 is the year it was last updated, not the year of the data [6]. The DB-Engines ranking is for May 2025 and scores popularity, not sales [5].

#### Where it is used

The main places and products the technology is found in

- Bank accounts and credit card records
- Travel reservations
- Company accounts, stock and order systems
- Websites and online shops
- Apps on smartphones, which keep local data in SQLite

as of 2026-11-11

#### Scale today

How much of it there is now: units in use, made each year and who uses it

**Installed**
: Over one trillion SQLite databases estimated in active use ^[6]

**Unit**
: databases

**Year**
: 2026

**Note**
: No count of all relational databases exists; SQLite's own estimate, on a page last updated in 2026, rests on more than 4.0 billion smartphones each holding hundreds of database files ^[6].

as of 2026-11-11

#### Sources

1. [The relational database](https://www.ibm.com/history/relational-database) IBM
2. [Databases](https://www.computerhistory.org/revolution/memory-storage/8/265) Computer History Museum (Revolution exhibition)
3. [DB-Engines Ranking](https://db-engines.com/en/ranking/) DB-Engines (solid IT), ranking table, May 2025 (the table the page showed when opened)
4. [Most Widely Deployed SQL Database Engine](https://sqlite.org/mostdeployed.html) SQLite, 2026

## Other sections

- [Summary](https://www.materialinsights.org/technologies/relational_database/index.md)
- [Science](https://www.materialinsights.org/technologies/relational_database/tech-science/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)
