Database
155 views
Referential Integrity
Quick Definition
Constraint ensuring table relationships remain consistent
Full Definition
Constraint ensuring relationships between tables remain consistent via foreign keys.
Examples
foreign keys, cascading deletes, orphan prevention
Related Terms
data-integrity
relational-database
More Database Terms
Schema Design
Defining database table structure and constraints
Write Ahead Log
Persistence mechanism writing changes to log before database
Replication
Copying data between servers for redundancy
Stored Procedure
Precompiled SQL stored in the database for execution
NoSQL
Non-relational databases with flexible data models and scaling
Sharding
Horizontal data partitioning across multiple instances