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.
bridge table; business process; dimension table; durable identifier; event table; fact table; flattened hierarchy; mini-dimension; natural key; object; operational ...