知识卡片
关系完整性增加协调成本
关系完整性要求不同记录或存储中的对应关系成立,例如有余额的用户也必须有地址记录。若应用依赖这种不变量,更新相关数据就需要协调;放松关系可提高独立处理程度,却把缺失或不同步情况交给应用。不能仅凭SQL或NoSQL标签判断具体系统的事务能力。
这张卡片看不懂?
这张卡片的反馈已满 10 条,暂时无法继续提交。
已有反馈 · 0 / 10 条
还没有人提交反馈。
在整书笔记中的位置
原书出处 · 1 处
- Chapter 2. Important Distributed System Concepts · 查看原书依据
Relational integrity refers to the integrity or accuracy of data stored in multiple different rows or stores within a system. For example, your bank balance might be stored as a pair of (user-id, balance), and your address might be stored in a different store as (user-id, address)
参考来源
- 位置:《Designing Distributed Systems, 2nd Edition》第02章《Chapter 2. Important Distributed System Concepts》(来源项目 book-sources;源文件:extracted/Designing Distributed Systems, 2nd Edition/_epub-src/OEBPS/ch02.html)
- 结论依据:原文用余额与地址说明跨记录约束,并分析同步、性能与代码复杂度的交换。
- 原始内容:Relational integrity refers to the integrity or accuracy of data stored in multiple different rows or stores within a system. For example, your bank balance might be stored as a pair of (user-id, balance), and your address might be stored in a different store as (user-id, address)