银行数据仓库建设方案文件XX银行EDW/数据仓库项目方案1银行数据仓库建设方案文件目录第一章系统总体架构..............................................................................31.1总体架构设计概述.........................................................................31.1.1总体架构的设计框架..............................................................31.1.2总体架构的设计原则..............................................................41.1.3总体架构的设计特点..............................................................41.2EDW执行架构.................................................................................51.2.1执行架构概述.........................................................................51.2.2执行架构设计原则..................................................................51.2.3执行架构框架.........................................................................61.3EDW逻辑架构.............................................................................131.3.1逻辑架构框架......................................................................131.3.2数据处理流程......................................................................191.4EDW运维架构.............................................................................201.4.1运维架构概述......................................................................201.4.2运维架构的逻辑框架...........................................................211.5EDW数据架构.............................................................................261.5.1数据架构设计原则..............................................................261.5.2数据架构分层设计..............................................................281.6EDW应用架构.............................................................................301.6.1应用架构设计原则..............................................................301.6.2数据服务.............................................................................311.6.3应用服务.............................................................................32第二章ETL体系建设...........................................................................332.1ETL架构概述.............................................................................332银行数据仓库建设方案文件2.2ETL设计方案.............................................................................352.3ETL关键设计环节......................................................................352.3.1接口层设计策略..................................................................352.3.2StagingArea设计策略.......................................................352.3.3数据加载策略......................................................................362.3.4增量ETL设计策略...............................................................362.3.5异常处理.............................................................................382.3.6作业调度和监控..................................................................392.3.7元数据管理.........................................................................392.3.8ETL模块设计.......................................................................392.3.9ETL流程设计.......................................................................422.3.10动态资源分配...............