Tag
referential-integrity
- 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
- Apr 7, 2026 Late-Arriving Dimensions and Inferred Members What happens when a fact references an entity the dimension has never seen, how inferred rows let the fact load proceed, and why the placeholder key is a debt with an interest rate. data engineering
- Feb 27, 2026 Inclusion Dependencies and the Undecidability That Follows Them How inclusion dependencies generalize foreign keys across arbitrary attribute sets, why their implication problem needs infinite chase sequences, and what breaks when they are combined with functional dependencies. databases