Theoretical Foundations of the Warehouse Ontology

The warehouse layer ontology assigns each layer a single correctness guarantee. The idea is not new — it extends work that already exists at smaller scales. Codd’s Relational Integrity Constraints Codd’s relational integrity constraints showed that correctness within a single database is not monolithic but stratified: domain constraints (each value in range), entity integrity (each row identifiable), and referential integrity (cross-table relationships consistent) form a hierarchy where each level presupposes the one below it. ...

March 30, 2026 · 2 min · Andrew Stryker