Material Insights · Understanding the Material World

Relational database: 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

FigureValueUnitYearSource
SQLite databases estimated in active use1000 billiondatabases2026[6]
Smartphones in active use, each holding hundreds of SQLite database files4billion smartphones2026[6]
Relational systems among the five most popular database systems in the DB-Engines ranking4systems2025[5]
Oracle's rank among the world's software companies2rank2000[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 IBM
  2. Databases Computer History Museum (Revolution exhibition)
  3. DB-Engines Ranking DB-Engines (solid IT), ranking table, May 2025 (the table the page showed when opened)
  4. Most Widely Deployed SQL Database Engine SQLite, 2026