| 基于银行数据仓库的ETL系统的设计与实现 |
| |
| 引用本文： | 常艳莉,李一凡,赵怀慈.基于银行数据仓库的ETL系统的设计与实现[J].微计算机信息,2006,22(24):21-23. |
| |
| 作者姓名： | 常艳莉 李一凡 赵怀慈 |
| |
| 作者单位： | 1. 110016 辽宁 沈阳 中国科学院沈阳自动化研究所;100037 北京 中国科学院研究生院
2. 110016 辽宁 沈阳 中国科学院沈阳自动化研究所 |
| |
| 基金项目： | 中国科学院院长基金(A050414) |
| |
| 摘 要： | ETL技术是创建数据仓库的关键。本文以银行数据仓库项目为背景,设计实现了数据的ETL系统,该系统具有良好的人机交互方式。系统采用时钟触发机制实现了数据的自动抽取过程;使用配置文件增强了系统的灵活性;通过对日志的细化实现了系统的快速恢复;针对海量数据的特点,在数据载入过程中优化了系统性能,提高了系统的运行效率。
|
| 关 键 词： | 银行 海量数据 配置文件 日志 |
| 文章编号： | 1008-0570(2006)08-3-0021-03 |
| 修稿时间： | 2005年12月20 |
Design and Realization of ETL System for Banking Data Warehouse |
| |
| Chang Yanli,Li Yifan,Zhao Huaici.Design and Realization of ETL System for Banking Data Warehouse[J].Control & Automation,2006,22(24):21-23. |
| |
| Authors: | Chang Yanli Li Yifan Zhao Huaici |
| |
| Affiliation: | (Shenyang Institute of Automation,Chinese Academy of Sciences,Shenyang 110016,China)Chang,Yanli Li,Yifan Zhao,Huaici (Graduate School of the Chinese Academy of Sciences,Beijing 100037,China)Chang,Yanli |
| |
| Abstract: | Technology of ETL is the key to building data warehouse. An ETL system with friendly man- machine mode is designed and realized. An ETL system with friendly man- machine mode is designed and realized. With the mechanism of clock flip- flop, data can be extracted automatically. It makes the system more flexible by using configuration files. The subdivided log files could make fast recovering of the whole system when exception interruption happened. And, for the characters of massive data, the performance is optimized and the efficiency is enhanced especially on the process of data loading. |
| |
| Keywords: | Bank Massive data Configuration file Log file |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
