Tag
foreign-keys
- Jun 11, 2026 Orphan Keys: Checking Referential Integrity Without Foreign Keys Warehouses rarely enforce foreign keys, so referential integrity becomes a scheduled anti-join; its cost, its two directions, and the time dimension that makes it ambiguous. data engineering
- Apr 16, 2026 Referential Integrity and the Semantics of Foreign Key Actions What a foreign key actually asserts, how each ON DELETE and ON UPDATE action resolves the violated constraint, and why MATCH SIMPLE accepts a partially null key. databases