知识卡片
维度描述事实属性
维度为事实提供可重复使用的描述属性,事实通过外键指向一个维度记录,多个事实可共用该记录。它使分析者能按人员、时间、类别等方向筛选和分组,而不用预先穷尽查询。维度的角色是描述活动,不能与记录活动本身的事实表混同。
这张卡片看不懂?
这张卡片已通过人工审查,不再接受失败反馈。
已有反馈 · 0 条
还没有人提交反馈。
在整书笔记中的位置
原书出处 · 1 处
- 数据网格 · 查看原书依据
Another essential building block of an analytical model is a dimension. If a fact represents a business process or action (a verb), a dimension describes the fact (an adjective). The dimensions are designed to describe the facts’ attributes and are referenced as a foreign key from a fact table to a dimension table. The attributes
参考来源
- 位置:《Learning Domain-Driven Design》第16章《数据网格》(来源项目:a19c7933-4eda-4176-aebd-30fe7e1ad292;源文件:extracted/Learning Domain-Driven Design/_epub-src/OEBPS/ch16.html)
- 结论依据:原文以动词和形容词类比事实与维度,说明外键、多对一与灵活查询目的。
- 原始内容:Another essential building block of an analytical model is a dimension. If a fact represents a business process or action (a verb), a dimension describes the fact (an adjective). The dimensions are designed to describe the facts’ attributes and are referenced as a foreign key from a fact table to a dimension table. The attributes