知识卡片
数据粒度明确一行含义
粒度规定表的一条记录代表什么,例如每商品一行或每商品每日一行。组合前核对粒度可避免把不同层次直接连接造成重复计算;字段名字相同不能代替键与粒度验证。
这张卡片看不懂?
这张卡片已通过人工审查,不再接受失败反馈。
已有反馈 · 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.