Chapter 16

Bitemporal Data and the Inmon Data Warehouse

This chapter begins with a brief history of data warehousing. It then deconstructs Inmon’s famous definition of a data warehouse, discards certain parts, modifies other parts, adds bitemporality, and reconstructs a new definition. In it, I argue that an Inmon data warehouse, lacking bitemporality, cannot be both time-variant and nonvolatile.

Keywords

ambiguous-time table; as-was data about things; as-was states of things; enterprise data warehouse; federated data warehouse; integrated; nonvolatile; operational data store; physical instantiation; semantic integration; subject-oriented; time-variant; virtual data warehouse

A Brief History of the Data Warehouse

In the 70s and well into the 80s, ...

Get Bitemporal Data now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.