基于Oracle的企业异构数据流整合

Oracle -based Integration of Heterogeneous Data Flows for Enterprises

以某生产制造型企业信息化工作为背景,针对企业信息化的一个瓶颈——异构数据集成问题,研究了一种低成本的数据移植方法,设计了一种新的专用ETL数据抽取工具,提出了企业最终建立数据仓库的关键技术。并通过从MySQL数据库向Oracle数据库移植数据为实例,成功验证了这种方法和工具的有效性。

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.