知识卡片

普通读书笔记卡 · 5368.a

星型模型分开事实与维度

理解等级:中级

星型schema把可量化的事实与描述事实的维度分开。工单的维修时长、时薪、距离属于事实;人员专长、姓名、门店位置属于维度。它刻意反规范化,减少复杂连接、便于聚合及多维查询,适合分析而非照搬交易模型。便利来自为分析重新组织数据,同时也增加另一套schema及其维护复杂度。

这张卡片看不懂?

已有反馈 · 0 / 10 条

    还没有人提交反馈。

    在整书笔记中的位置

    原书出处 · 1 处

    • 管理分析数据 · 查看原书依据

      The Star Schema pattern was popular with data marts and warehouses. It separates the data semantics into facts, which hold the organization’s quantifiable data, and dimensions; hence they are also known as dimensional models, which include descriptive attributes of the fact data.

    参考来源

    - 位置:《Software Architecture The Hard Parts Modern Trade-Off Analyses for Distributed Architectures (Neal Ford, Mark Richards, Pramod Sadalage etc.)》第14章《Chapter 14. Managing Analytical Data》(来源项目:book-sources;源文件:extracted/Software Architecture The Hard Parts Modern Trade-Off Analyses for Distributed Architectures (Neal Ford, Mark Richards, Pramod Sadalage etc.)/_epub-src/OEBPS/ch14.xhtml) - 结论依据:原文的定义、示例或失败路径支持以下归纳:星型schema把可量化的事实与描述事实的维度分开。 其他条件结合本章同小节说明;不将模式目标当成已有运行保证。 - 原始内容:The Star Schema pattern was popular with data marts and warehouses. It separates the data semantics into facts, which hold the organization’s quantifiable data, and dimensions; hence they are also known as dimensional models, which include descriptive attributes of the fact data.