摘要： 以某生产制造型企业信息化工作为背景,针对企业信息化的一个瓶颈——异构数据集成问题,研究了一种低成本的数据移植方法,设计了一种新的专用ETL数据抽取工具,提出了企业最终建立数据仓库的关键技术。并通过从MySQL数据库向Oracle数据库移植数据为实例,成功验证了这种方法和工具的有效性。
关键词:
异构数据流,
数据移植,
数据仓库,
Oracle数据库,
ETL,
PDM系统
Abstract: Based on the application of the information system of a manufacturing enterprise and the bottleneck problem of the enterprise information, this thesis discusses an effective method, a low cost approach of data transplant, about integrating process of heterogeneous data sources.A new special ETL tool is designed which is a key technique to the establishment of the enterprise data warehouse. The method is illustrated by the example of the data transplant between MySQL database and Oracle database. The effectiveness of the method and the tool are verified in terms of the integration of heterogeneous data flows for enterprises.
中图分类号:
于宝琴,王太勇,郭晓军,何改云,汪文津. 基于Oracle的企业异构数据流整合[J]. , 2004, 30(24): 51-.
YU Baoqin1, WANG Taiyong1, GUO Xiaojun1, HE Gaiyun1, WANG Wenjin1 2. Oracle -based Integration of Heterogeneous Data Flows for Enterprises[J]. , 2004, 30(24): 51-.