| ETL技术在复杂数据迁移项目中的应用 |
| |
| 引用本文： | 宋鹏,;廉继红.ETL技术在复杂数据迁移项目中的应用[J].西北纺织工学院学报,2008(4):493-497. |
| |
| 作者姓名： | 宋鹏 ;廉继红 |
| |
| 作者单位： | [1]西安工程大学电子信息学院,陕西西安710048 |
| |
| 摘 要： | 针对数据迁移中ETL技术的实现问题，指出可以通过构造输入数据库和中间数据库，利用Datastage工具和PL／SQL程序相结合的方式进行数据迁移．给出了Datastage工具的应用策略和PL／SQL程序实现ETL过程的具体流程．实践表明该方案数据迁移速度较快，能够较好地完成海量数据的迁移任务．
|
| 关 键 词： | 数据迁移 ETL PL/SQL Datastage |
Application of ETL technology in complex data migration projects |
| |
| Affiliation: | SONG Peng ,LIAN Ji-hong (School of Electronics and Information, Xi＇an Polytechnic University, Xi＇an 710048,China) |
| |
| Abstract: | The solutions are put forward for the implementation of ETL in the data migration. That is to construct the input database and middle database, and to transfer the Data with the Datastage and the program of PL/SQL. The application strategy of the datastage and the specific process of the program of PL/SQL are presented. The practice shows that the speed of data migration is fast and the task of massive data migration can be finished successfully. |
| |
| Keywords: | data migration ETL（Extract Transform Load） PL/SQL Datastage |
| 本文献已被 维普 等数据库收录！ |
