relational database
A database that stores data in tables and links rows in one table to rows in another through shared key values.
In more detail
Each kind of thing, such as customers or orders, gets its own table, and a column in one table holds the key of a row in another. The database checks those links, runs queries across them with joins, and groups changes into transactions. SQLite, PostgreSQL and MySQL are all relational databases.
Example
Amazon RDS runs relational engines as a managed service.Related terms
- SQL — The standard language for defining, querying and changing data in a relational database.
- transaction — A group of database changes that succeed or fail together, so the data is never left half-updated.
- Amazon RDS — Amazon Relational Database Service, which runs relational database engines such as PostgreSQL and MySQL as a managed service.
- NoSQL — Databases that do not use the relational table model, such as key-value and document stores, trading query freedom for predictable scale.
- primary key — The column, or columns, whose value uniquely identifies each row of a table and can never be NULL.
- database — A program that stores data in an organised way and answers questions about it, such as PostgreSQL.
- ORM — A library that lets code read and write database rows as ordinary objects, generating the SQL for you.
- table — A named set of rows that all have the same columns, where each row records one fact about one thing.
- foreign key — A column holding another table's primary key value, which the database guarantees points at a row that exists.
- join — Combining rows from two tables into one result by pairing rows according to a rule, usually matching keys.
- document database — A NoSQL database that stores each record as a flexible document, usually JSON, with its own nested structure.
- schema — A formal description of the structure of data: which fields or columns exist, their types and which are required.
Taught in
- Managed Relational Databases (RDS) — Cloud Infrastructure & Hyperscaler Architecture
- NoSQL and DynamoDB — Cloud Infrastructure & Hyperscaler Architecture
- When to Pick Which Database — Cloud Infrastructure & Hyperscaler Architecture
- Persistence With JPA And Hibernate — Modern Java: Virtual Threads & High-Throughput Services
- Why Tables And Relations Beat Files — PostgreSQL, Indexing & Relational Data Modeling
- What A Design Is For, And How To Run A Design Discussion — Scalable System Design & Distributed Architecture
- The Storage Decision: Relational Versus Document — Scalable System Design & Distributed Architecture
- The Storage Decision: Key Value, Search And Blob — Scalable System Design & Distributed Architecture
- Worked Design One: Ticket Booking, Correctness First — Scalable System Design & Distributed Architecture