Bill Inmon
Known as the “Father of the Data Warehouse” — coined the term and defined the four core properties of a data warehouse.
Last updated: 2026-04-12
Overview
Bill Inmon is widely credited as the originator of the data warehouse concept. He coined the term “data warehouse” and defined its four essential properties (subject-oriented, integrated, time-variant, non-volatile) in his 1990 book Building the Data Warehouse.
His approach is top-down: design a normalized (3NF) enterprise data warehouse first, then derive subject-area data marts from it. This ensures enterprise-wide consistency and a single version of truth before any user-facing reporting is built.
Key Contributions
- Coined “data warehouse” as a distinct architectural concept
- Four properties of a DWH: subject-oriented, integrated, time-variant, non-volatile — see data-warehouse
- Top-down methodology: Enterprise EDW in 3NF → data marts
- Corporate Information Factory (CIF): His broader architectural blueprint including ODS, EDW, data marts, and exploration warehouses
- Building the Data Warehouse (1990) — foundational book
Inmon vs. Kimball
| Inmon | Kimball | |
|---|---|---|
| Approach | Top-down (EDW first) | Bottom-up (data marts first) |
| Model | 3NF normalized | Dimensional (star schema) |
| Integration point | Central EDW | Conformed dimensions |
| Time to value | Slower | Faster |
| Best for | Large enterprises needing consistency | Agile, department-level BI |
See dimensional-modeling for deeper comparison.
Connections
- data-warehouse — concept he defined
- dimensional-modeling — contrasting methodology by Kimball
- ralph-kimball — counterpart and contrast in DWH methodology debate
Sources
- Dimensional Modeling — Joakim Dalby — added 2026-04-12