Overview
Direct Answer
A relational database is a structured data management system that organises information into interconnected tables where data is stored in rows (records) and columns (attributes), with relationships between tables defined through keys. This model enforces data integrity and enables complex queries across multiple tables using standardised query languages.
How It Works
Data is normalised into separate tables, each representing a distinct entity or concept, with primary keys uniquely identifying records and foreign keys establishing links between tables. Query engines interpret declarative SQL statements to retrieve, combine, and manipulate data across these interconnected structures, leveraging the defined relationships to satisfy requests without requiring users to specify access paths.
Why It Matters
Organisations depend on this architecture for transactional consistency, compliance with data integrity constraints, and the ability to scale to millions of records whilst maintaining performance. The standardised query language and well-defined schema reduce development time, minimise data anomalies, and provide a reliable foundation for business-critical applications in finance, healthcare, and logistics.
Common Applications
Enterprise resource planning systems, customer relationship management platforms, financial transaction processing, inventory management, and personnel record systems all rely on relational models. Healthcare providers use them to maintain patient records; financial institutions process payments and maintain account ledgers; e-commerce platforms track orders and inventory.
Key Considerations
Vertical scalability is straightforward, but horizontal distribution across servers requires careful partitioning strategy. Schema changes in production environments demand downtime planning, and the rigid structure, whilst ensuring consistency, can complicate storage of hierarchical or unstructured data.
Referenced By2 terms mention Relational Database
Other entries in the wiki whose definition references Relational Database — useful for understanding how this concept connects across Software Engineering and adjacent domains.
More in Software Engineering
Continuous Integration
Development PracticesA development practice where code changes are automatically built and tested when merged to a shared repository.
Behaviour-Driven Development
Development PracticesA development approach where application behaviour is described in a natural language format before implementation.
WebSocket
Paradigms & PatternsA communication protocol providing full-duplex communication channels over a single persistent TCP connection.
Package Manager
Paradigms & PatternsA tool that automates the process of installing, upgrading, configuring, and removing software packages.
Concurrency
ArchitectureThe ability of a system to handle multiple tasks simultaneously by interleaving their execution.
Integration Testing
Quality & TestingTesting the interaction between different software modules or components to verify they work together correctly.
Rate Limiting
ArchitectureA technique for controlling the number of requests a client can make to an API within a specified time period.
Git
Development PracticesA distributed version control system for tracking changes in source code during software development.