The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition

Index

Symbols

3NF (third normal form) models ch1¶21

ERDs (entity-relationship diagrams) ch1¶22

normalized 3NF structures ch1¶23

4-step dimensional design process ch2¶11, ch3¶5

A

abnormal scenario indicators ch8¶97

abstract generic dimensions ch2¶249

geographic location dimension ch11¶52

accessibility goals ch1¶303

accidents (insurance case study), factless fact tables ch16¶77

accounting case study ch7¶3

budgeting ch7¶36

fact tables, consolidated ch7¶80

G/L (general ledger) ch7¶7

chart of accounts ch7¶9

currencies ch7¶20

financial statements ch7¶34

fiscal calendar, multiple ch7¶31

hierarchies ch7¶59

journal entries ch7¶24

period close ch7¶16

periodic snapshot ch7¶9

year-to-date facts ch7¶22

hierarchies

fixed depth ch7¶53

modifying, ragged ch7¶70

ragged, alternative modeling approaches ch7¶74

ragged, bridge table approach ch7¶78

ragged, modifying ch7¶70

ragged, shared ownership ch7¶67

ragged, time varying ch7¶68

ragged, variable depth ch7¶58

variable depth ch7¶62

OLAP and ch7¶86

accumulating grain fact tables ch1¶40

accumulating snapshots ch2¶53, ch4¶30, ch6¶89

claims (insurance case study) ch16¶65

complex workflows ch16¶101

timespan accumulating snapshot ch16¶78

ETL systems ch19¶132

fact tables ch4¶41, ch13¶201

complementary fact tables ch4¶33

milestones ch4¶42

OLAP cubes ch4¶45

updates ch4¶44

healthcare case study ch14¶16

policy (insurance case study) ch16¶40

type 2 dimensions and ch6¶96

activity-based costing measures ch6¶60

additive facts ch1¶35, ch2¶38

add mini dimension and ...