摘 要: 本文基于国内某商业银行数据中心的新核心系统项目,首先介绍近年来数据仓库的国内外发展状况,其 次根据商业银行各业务系统的特点,分析出建设商业银行数据仓库的重大意义和存储规划。最后详细介绍了数据调度 ETL系统的开发与设计,从各个源系统中抽取数据到数据仓库的实现方法,对银行数据仓库的设计与实现有一定的参考 应用价值。 |
关键词: 数据仓库;ETL;商业银行;商业智能 |
中图分类号: TP311
文献标识码: A
|
基金项目: 安徽省自然科学基金项目(项目编号:1508085MF114). |
|
Design and Implementation of ETL in the Commercial Bank Data Warehouse System |
ZHOU Fei,LIU Mengna,ZHANG Hui,LI Zhigang,CAO Shuai
|
( School of Electronic and Information Engineering, Anhui Jianzhu University, Hefei 230601, China)
|
Abstract: Based on a new Data Warehouse project for a commercial bank's data center in China,the paper firstly introduces the development status of Data Warehouse in recent years.Secondly,according to the characteristics of commercial banks' business systems,it analyzes the storage plan of building a data warehouse system for the commercial bank.In the end,it describes in detail a dispatching system using Extract Transform and Load (ETL) system.The study provides a valid reference for the commercial banks to construct a Data Warehouse system in a complicated environment. |
Keywords: data warehouse;ETL;commercial bank;business intelligence |