Dimensional Data Warehousing with MySQL: A Tutorial

2017-07-07 02:10:07

sales analysis, 263

scheduled task, 117

scheduling, 117

semi-additive measure, 43

single-path hierarchy, 221, 229

Slowly Changing Dimension, 25, 26,41

variants, 25

Slowly Changing Dimension Type 1, 26

Slowly Changing Dimension Type 2, 33

snapshot, 197, 200

snowflake structure, 10

source extraction, 65

specific query, 51, 55, 57

staging table, 27, 28, 29, 33, 35, 37

star schema, 7, 9,10,12, 24

subset dimension, 155

surrogate key, 9,11,12, 13, 19, 21, 24, 51, 91, 163, 305, 323, 324

generating, 12

naming, 11

Категории