Chapter 18

Bitemporal Data and the Kimball Data Warehouse

This chapter begins with a comparison of the ontologies of the Inmon and Kimball data warehouse architectures, and of the somewhat different semantics that each supports. It then provides a semantic description of Kimball’s star schemas and of the major components of those star schemas. The major part of this chapter presents a case study in which a bitemporal dimension is used in a star schema. The final section of this chapter points out the shortcomings of slowly-changing dimensions compared to bitemporal dimensions.

Keywords

bridge table; business process; dimension table; durable identifier; event table; fact table; flattened hierarchy; mini-dimension; natural key; object; operational ...

Get Bitemporal Data now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.