|
Posted by 太平洋 on 2007-08-17 11:28 上午
|
BW星型模型的好处，BW310中描述：
• Advantages:
– The use of automatically generated INT4 keys I (SID keys, DIMID
keys) enables faster access to data than via long alpha-numeric keys.
– Thanks to the excavation of master data from the dimension tables
using the SID technique, the following modeling possibilities exist :
Historizing dimensions
Multi-lingual capability
Cross-BasisCube use of master data (→ “shared dimensions”)
– The query performance is improved here as aggregated key figures
can be stored in their own fact tables.
不太理解，那位达人指点下？
|
|