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
| 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
- The relational database IBM
- Databases Computer History Museum (Revolution exhibition)
- DB-Engines Ranking DB-Engines (solid IT), ranking table, May 2025 (the table the page showed when opened)
- Most Widely Deployed SQL Database Engine SQLite, 2026