My first Publication Agile-Data-Warehouse-Design-eBook

Contents Periodic Snapshot .................................................................................................................... 229 ! Accumulating Snapshots.......................................................................................................... 231 ! F ACT T ABLE G RANULARITY ............................................................................................................... 233 ! M ODELING E VOLVING E VENTS ........................................................................................................... 233 ! Evolving Event Measures......................................................................................................... 237 ! Event Counts......................................................................................................................... 237 ! State Counts ......................................................................................................................... 237 ! Durations............................................................................................................................... 238 ! Additional Process Performance Measures .......................................................................... 238 ! Event Timelines........................................................................................................................ 238 ! Using Timelines for Documentation ...................................................................................... 240 ! Using Timelines for Business Intelligence............................................................................. 240 ! Developing Accumulating Snapshots....................................................................................... 241 ! F ACT T YPES ..................................................................................................................................... 242 ! Fully Additive Facts .................................................................................................................. 243 ! Non-Additive Facts................................................................................................................... 243 ! Semi-Additive Facts ................................................................................................................. 244 ! Averaging Issues................................................................................................................... 244 ! Counting Issues .................................................................................................................... 245 ! Heterogeneous Facts Pattern .................................................................................................. 246 ! Factless Fact Pattern ............................................................................................................... 248 ! F ACT T ABLE O PTIMIZATION ............................................................................................................... 249 ! Downsizing............................................................................................................................... 249 ! Indexing.................................................................................................................................... 250 ! Partitioning ............................................................................................................................... 251 ! Aggregation.............................................................................................................................. 252 ! Lost Dimension Aggregate Pattern ....................................................................................... 252 ! Shrunken Dimension Aggregate Pattern............................................................................... 253 ! Collapsed Dimension Aggregate Pattern .............................................................................. 254 ! Aggregation Guidelines......................................................................................................... 254 ! Drill-Across Query Pattern ....................................................................................................... 255 ! Derived Fact Table Patterns .................................................................................................... 258 ! S UMMARY ........................................................................................................................................ 260 ! CHAPTER 9 WHY AND HOW: DESIGN PATTERNS FOR CAUSE AND EFFECT ................................................ 261 ! W HY D IMENSIONS ............................................................................................................................. 262 ! Internal Why Dimensions ......................................................................................................... 262 ! Unstructured Why Dimensions................................................................................................. 263 ! External Why Dimensions ........................................................................................................ 264 ! M ULTI -V ALUED D IMENSIONS ............................................................................................................. 265 ! Weighting Factor Pattern ......................................................................................................... 265 ! Modeling Multi-Valued Groups................................................................................................. 267 ! Multi-Valued Bridge Pattern ..................................................................................................... 268 ! Optional Bridge Pattern............................................................................................................ 270 ! Pivoted Dimension Pattern....................................................................................................... 273 ! H OW D IMENSIONS ............................................................................................................................ 276 ! Too Many Degenerate Dimensions?........................................................................................ 277 ! Creating How Dimensions........................................................................................................ 277 ! Range Band Dimension Pattern............................................................................................... 278 ! XV

My first Publication Agile-Data-Warehouse-Design-eBook | Page 14