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