| 一种金融系统专用ETL工具的研究与实现 |
| |
| 引用本文： | 屈志毅,张延堂,王戈.一种金融系统专用ETL工具的研究与实现[J].计算机工程,2008,34(20):80-81. |
| |
| 作者姓名： | 屈志毅 张延堂 王戈 |
| |
| 作者单位： | 兰州大学信息科学与工程技术学院,兰州,730000 |
| |
| 摘 要： | 实现了一种基于Spring框架的商业银行专用ETL程序。该程序利用Spring框架的控制反转技术，基于Ibatis的数据访问对象技术和Spring JDBC，以及Spring对Timer的支持，解决了ETL过程中的数据转换、数据载入、生命周期管理、任务调度等关键问题。该程序在IBM System x3850(8864I02)上运行，载入数据的平均速度达到每秒900条记录。
|
| 关 键 词： | ETL工具 Spring框架 数据转换 任务调度 |
| 修稿时间： | |
Study and Implementation of Special ETL Tool for Finance System |
| |
| QU Zhi-yi,ZHANG Yan-tang,WANG Ge.Study and Implementation of Special ETL Tool for Finance System[J].Computer Engineering,2008,34(20):80-81. |
| |
| Authors: | QU Zhi-yi ZHANG Yan-tang WANG Ge |
| |
| Affiliation: | (School of Information Science and Engineering Technology, Lanzhou University, Lanzhou 730000) |
| |
| Abstract: | A special Extraction-Transformation-Loading(ETL) program for financical banks based on Spring framework is researched and implemented. This program resolves the problems of data transformation, data loading, life cycle management and schedule of tasks in the ETL process by using the techniques of Inversion of Control(IoC), Data Access Object(DAO) based on Ibatis, Spring JDBC and the support to Timer of Spring framework. The average speed of loading records is 900/s, when runs on IBM System x3850(8864I02). |
| |
| Keywords: | Extraction-Transformation-Loading(ETL) tool Spring framework data transformation task schedule |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
| 点击此处可从《计算机工程》浏览原始摘要信息 |
|
点击此处可从《计算机工程》下载全文 |
