Stockertim Dictionary · Technology
Database
In short
An organised collection of data stored electronically so that it can be searched, updated and analysed quickly, managed by software that controls access and keeps records consistent.
- Beginner
- Technology
- Checked
In detail
A database is more than a file full of information. It is managed by a database management system that decides how data is stored on disk, lets many users read and write at the same time without corrupting records, enforces rules such as every account must have an owner, and makes backups and recovery possible. Programs talk to it by sending queries, requests to find, add, change or delete data.
The most common type is the relational database, which keeps data in tables of rows and columns. A customers table and an accounts table can be linked by a shared identifier, and a query language called SQL combines them, for example to list every customer with a balance above a certain amount. Non-relational databases store data as documents, key-value pairs, graphs or time series, trading some of the strict structure for speed or flexibility at very large scale.
Almost every financial service depends on databases. A bank's core ledger, a broker's record of client holdings, an exchange's order book history and a regulator's register of authorised firms are all databases. Because they hold valuable and personal information they are a prime target for attackers, so access is restricted, sensitive fields are encrypted, changes are logged and copies are kept elsewhere so that service can be restored after a failure.
Worked example
A broker's database holds 200,000 client records and a query filters those with holdings worth over ₦1 million.
- If 6% of clients meet the condition: 200,000 × 6% = 12,000 records returned
The query returns 12,000 matching clients in a fraction of a second, without anyone scanning the records by hand.
In practice
Analysts query databases to pull price histories and fundamentals; developers design tables and indexes so that apps load quickly; compliance teams rely on accurate, time-stamped records to answer regulators. Firms test that backups can actually be restored, not just that they exist.
Watch out
- A spreadsheet is not a database: it lacks the controls on simultaneous editing, consistency and access that databases provide.
- Deleting a record from an app may not remove it from backups or logs; data protection rules can apply to all copies.
Learn it properly
- Summarising with SQL: GROUP BY, COUNT, SUM and AVG15 min lesson Free course: Data skills: SQL and Python basics
- Link analysis and open-source research15 min lesson Free course: Financial crime: investigation, forensics and compliance
- SQL basics: SELECT, WHERE and ORDER BY15 min lesson Free course: Data skills: SQL and Python basics
- What is blockchain?15 min lesson Free course: Crypto & digital assets: Beginner
- How data is organised: tables, rows, columns and keys15 min lesson Free course: Data skills: SQL and Python basics
Official sources
- Database (glossary) · NIST Computer Security Resource Center
Facts last checked on 1 November 2026.
Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.