知识卡片
星型雪花的查询取舍
星型模型让事实表直接关联各维度;雪花模型把维度再规范化为更细层次。后者减少维度存储、便于维护,但查询事实时需要更多连接和计算。两者都服务分析,差异在维度展开程度,应按存储维护与查询成本取舍,而非把规范化程度当唯一质量标准。
这张卡片看不懂?
这张卡片的反馈已满 10 条,暂时无法继续提交。
已有反馈 · 0 / 10 条
还没有人提交反馈。
在整书笔记中的位置
原书出处 · 1 处
- 数据网格 · 查看原书依据
Another predominant analytical model is the snowflake schema. The snowflake schema is based on the same building blocks: facts and dimensions. However, in the snowflake schema, the dimensions are multilevel: each dimension is further normalized into more fine-grained dimensions, as shown in Figure 16-6. As a result of the additional normalization, the snowflake schema will
参考来源
- 位置:《Learning Domain-Driven Design》第16章《数据网格》(来源项目:a19c7933-4eda-4176-aebd-30fe7e1ad292;源文件:extracted/Learning Domain-Driven Design/_epub-src/OEBPS/ch16.html)
- 结论依据:原文解释星型的多对一关系和雪花多层维度,并明确存储维护与连接计算的交换。
- 原始内容:Another predominant analytical model is the snowflake schema. The snowflake schema is based on the same building blocks: facts and dimensions. However, in the snowflake schema, the dimensions are multilevel: each dimension is further normalized into more fine-grained dimensions, as shown in Figure 16-6. As a result of the additional normalization, the snowflake schema will