知识卡片
仓库以转换换集中分析
数据仓库从多个操作库抽取数据,先转换成统一分析schema再加载,分析师在独立算力和存储上生成报表,避免重聚合干扰交易。代价是源领域变化要同步修改抽取转换逻辑,领域知识也要在开发、数据库和分析团队之间协调。专用分析模型隔离计算负载,却可能形成组织与技术瓶颈;不能只以数据集中就认定解决了分析需求。
这张卡片看不懂?
这张卡片已通过人工审查,不再接受失败反馈。
已有反馈 · 0 条
还没有人提交反馈。
在整书笔记中的位置
原书出处 · 1 处
- 管理分析数据 · 查看原书依据
Because the operational data resides in individual systems, the warehouse must build mechanisms to regularly extract the data, transform it, and place it in the warehouse. Designers either used built-in relational database mechanisms like replication or specialized tools to build translators from the original schema to the warehouse schema. Of course, any changes to operational systems schemas must be replicated in the transformed schema, making change coordination difficult.
参考来源
- 位置:《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再加载,分析师在独立算力和存储上生成报表,避免重聚合干扰交易。 其他条件结合本章同小节说明;不将模式目标当成已有运行保证。
- 原始内容:Because the operational data resides in individual systems, the warehouse must build mechanisms to regularly extract the data, transform it, and place it in the warehouse. Designers either used built-in relational database mechanisms like replication or specialized tools to build translators from the original schema to the warehouse schema. Of course, any changes to operational systems schemas must be replicated in the transformed schema, making change coordination difficult.