BI Dimensional Modeling, Data Mart Design 问题求教

sfy9

求教一个问题，做BI的人士请指点：

假定同一个DB server上有五个Data Mart （which contain data required for specific departments），每个都用到DimProduct，是把DimProduct存上5份么？
The scenario is
DM1 : DimProduct, Dim1, FactTable1
DM2:  DimProduct, Dim2, FactTable2
DM3 : DimProduct, Dima, FactTable3
DM4:  DimProduct, Dimb, FactTable4
DM5:  DimProduct, Dimc, FactTable5

存上5份的益处是便利建FK，放慢数据查问。但害处是占用存储空间，并且万一5份之间有inconsistent怎么办哪？

qq1002513 · 发表于 2021-5-18 00:01:05

Dim_product_view1,2,3,4,5

yelhao · 发表于 2021-5-18 00:05:25

不论你怎么设计
周日晚上9点还在任务
老板要加你人工了

bald · 发表于 2021-5-18 00:09:42

you cannot build a foreign key between a FactTable and a DimProductView.

Have u thought about this?

血刃 · 发表于 2021-5-18 00:12:07

整个做成view

fenjin1970 · 发表于 2021-5-18 00:15:03

foreign key only maintains data integrity but does not improve performance. As data integrity can be maintained in the ETL, you do not need a foreign key between a FactTable and a DimProductView.

华人澳洲中文论坛

热图推荐

BI Dimensional Modeling, Data Mart Design 问题求教

全部回复5

qq1002513 沙发

yelhao 板凳

bald 地板

血刃 5^#

fenjin1970 6^#

发表回复

sfy9
关注TA

图文推荐

华人澳洲中文论坛

热图推荐

BI Dimensional Modeling, Data Mart Design 问题 求教

全部回复5

qq1002513 沙发

yelhao 板凳

bald 地板

血刃 5#

fenjin1970 6#

发表回复

sfy9 关注TA

图文推荐

BI Dimensional Modeling, Data Mart Design 问题求教

血刃 5^#

fenjin1970 6^#

sfy9
关注TA