BI Dimensional Modeling, Data Mart Design 问题 请教

兰宝宝

请教一个问题，做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怎么办哪？

wonderdream

Dim_product_view1,2,3,4,5

AmandaX

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

兰宝宝

wonderdream 发表于 2013-5-20 09:10
Dim_product_view1,2,3,4,5

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

Have u thought about this?

stevenbian

全部做成view

老衲

兰宝宝 发表于 2013-5-20 12:02
you cannot build a foreign key between a FactTable and a DimProductView.

Have u thought about thi ...

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.