知识卡片

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

物化视图预计算读取

理解等级:初级

物化视图存储预计算查询结果,以额外存储与刷新工作换取读取效率。它与CQRS共享为读取维护单独表示的思想,但可能仍与源表位于同一数据库;不能因此假定已经获得独立故障边界。

这张卡片看不懂?

已有反馈 · 0 / 10 条

    还没有人提交反馈。

    在整书笔记中的位置

    原书出处 · 1 处

    • Data Product Management · 查看原书依据

      CQRS has a strong relationship with materialized views.2 A materialized view inside a database is a physical copy of the data that is constantly updated by the underlying tables. Materialized views are often used for performance optimizations. Instead of querying the data from underlying tables, the query is executed against the precomputed and optimized subset that lives inside the materialized view. This segregation of the

    参考来源

    - 位置:《Data Management at Scale》第04章《Data Product Management》(来源项目 a19c7933-4eda-4176-aebd-30fe7e1ad292,源文件:extracted/Data Management at Scale/_epub-src/OEBPS/ch04.html) - 结论依据:原文对precomputed and optimized subset的解释、约束及上下文支持本卡;内容为中文归纳,不把架构建议当作所有组织的必然规律。 - 原始内容:CQRS has a strong relationship with materialized views.2 A materialized view inside a database is a physical copy of the data that is constantly updated by the underlying tables. Materialized views are often used for performance optimizations. Instead of querying the data from underlying tables, the query is executed against the precomputed and optimized subset that lives inside the materialized view. This segregation of the