
3
1
The Basics of Data Warehouse Data
Modeling
This chapter begins Part I of this book, focusing on data warehouse data
model tuning techniques. This first chapter describes how to build data
warehouse data models and how to relate data warehouse entities to each
other. There are various methodologies and approaches, which are essen-
tially very simple. Tuning data warehouse entities is directly related to four
things: (1) time—how far back does your data go, (2) granularity—how
much detail should you keep, (3) denormalizing—including duplication in
entity structures, (4) using special Oracle Database logical structures and
techniques, such as materialized ...