The Distributed SQL Blog

Thoughts on distributed databases, open source and cloud native

Relational Data Modeling with Foreign Keys in a Distributed SQL Database

Primary and foreign key constraints are as essential to a relational database as are tables and columns—without these, you cannot implement a design that conforms to the relational model. Their implementation is a technical challenge. For example, when child rows are inserted, their parent rows must be efficiently restricted; and when parent rows are deleted, multi-table transactions are needed. Nevertheless,

Read More