Relational Database
Quick Definition
Database storing data in structured tables with relationships
Full Definition
A database storing data in structured tables with rows and columns related through keys.
Examples
MySQL, PostgreSQL, Oracle, SQL Server
Related Terms
sql
acid
normalization
More Database Terms
Foreign Key
Field referencing primary key to establish table relationships
Denormalization
Intentionally adding redundancy to improve reads
CAP Theorem
Theorem on Consistency, Availability, Partition tolerance trade-offs
Isolation Level
Degree of visibility between concurrent transactions
Document Database
NoSQL database storing data as flexible JSON-like documents
Concurrency Control
Managing simultaneous data access while maintaining consistency