BYK商业银行数据仓库浅析商业银行数据仓库浅析商业银行数据仓库浅析第一版孟凡涛2012年12月目录2商业银行数据仓库浅析引言................................................................................................................................................51基本概念.................................................................................................................................61.1操作型系统............................................................................................................................61.2OLTP和OLAP..........................................................................................................................61.3数据源系统............................................................................................................................71.4数据仓库................................................................................................................................71.4.1面向主题........................................................................................................................71.4.2集成................................................................................................................................81.4.3非易失性........................................................................................................................91.4.4随时间变化..................................................................................................................101.5决策支持系统......................................................................................................................111.6维度和度量..........................................................................................................................112数据仓库的好处....................................................................................................................123数据仓库核心内容................................................................................................................143.1典型数据仓库架构图..........................................................................................................143.2数据模型..............................................................................................................................143.2.1模型设计思路..............................................................................................................153.2.2模型设计原则..............................................................................................................163.2.3模型主题划分..............................................................................................................163.2.4拉链表..........................................................................................................................193.2.5快照表..........................................................................................................................203.2.6流水表..........................................................................................................................203.3ODS层..................................................................................................................................203.3.1ODS定义..................................................................................................
