-
fact table
-
measures
-
measures for sales fact table
- Topic
- 也叫business facts
- dimension table
-
sample
-
a sample for the sales fact table
- Topic
-
Star Schema
- multi-dimension database
- most common model for OLAP
-
snowflake(雪花型)
- 一般不用,节省的是维度表的空间,不值
-
fact constellations(星座)
- 由一组星型模型构成
- 多事实表共享纬度表
-
sample
- Topic
-
DMQL
- define cube
- define dimension