← 返回刚才阅读的位置

知识卡片

普通读书笔记卡 · 2275.as.6.f.3.c.1.b.1.b.2.b

数据粒度明确一行含义

理解等级:初级

粒度规定表的一条记录代表什么,例如每商品一行或每商品每日一行。组合前核对粒度可避免把不同层次直接连接造成重复计算;字段名字相同不能代替键与粒度验证。

这张卡片看不懂?

已有反馈 · 0 条

    还没有人提交反馈。

    在整书笔记中的位置

    原书出处 · 1 处

    • Turning Data into Value · 查看原书依据

      7 The grain of a relation defines what each row represents in the relation. In a table like products, the grain might be a single product, so every product is in its own row, with exactly one row per product. By ensuring that your grains are clear, you specify exactly what a table record contains. This gives users insight into what data can be combined.

    参考来源

    - 位置:《Data Management at Scale》第11章《Turning Data into Value》(来源项目 a19c7933-4eda-4176-aebd-30fe7e1ad292,源文件:extracted/Data Management at Scale/_epub-src/OEBPS/ch11.html) - 结论依据:原文对grain of a relation的解释、约束及上下文支持本卡;内容为中文归纳,不把架构建议当作所有组织的必然规律。 - 原始内容:7 The grain of a relation defines what each row represents in the relation. In a table like products, the grain might be a single product, so every product is in its own row, with exactly one row per product. By ensuring that your grains are clear, you specify exactly what a table record contains. This gives users insight into what data can be combined.