摘要
阐述ETL技术在某银行绩效考核系统中的设计与实现,在该系统中运用了改进的ETL架构,自行开发设计ETL工具,在ETL过程中通过增加中间文件服务器和临时数据库,把ETL的3个过程独立开来,达到提高数据抽取、转换和装载的效率,同时降低ETL代码编写的复杂度,减轻目标数据库的压力。
Presents the design and realization of bank achievement inspection system, applies the new ETL architecture and the self-developed ETL tool in this system. During ETL, adds the middle file server and temp database, so the three processes of ETL is independent respectively and the efficiency is improved and the difficulty is lowed.
出处
《现代计算机》
2007年第12期91-95,共5页
Modern Computer
