Data Warehouse

Business users want data that drives decisions. They want to know what happened, why it happened, and what to do about it — without learning a data model, mastering dimensional thinking, or writing and debugging SQL. That is the gap a good analyst closes. Analysts use both domain and technical knowledge to pull insights out of an organization’s data warehouse. LLMs offer a different path: connect the model to the warehouse via an MCP server, and the user gets answers without needing the analyst’s technical knowledge. ...

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. ...