知识卡片

普通读书笔记卡 · 1905.c.1

维度描述事实属性

理解等级:高级

维度为事实提供可重复使用的描述属性,事实通过外键指向一个维度记录,多个事实可共用该记录。它使分析者能按人员、时间、类别等方向筛选和分组,而不用预先穷尽查询。维度的角色是描述活动,不能与记录活动本身的事实表混同。

这张卡片看不懂?

已有反馈 · 0 / 10 条

    还没有人提交反馈。

    在整书笔记中的位置

    原书出处 · 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