| 基于Oracle的企业异构数据流整合 |
| |
| 引用本文： | 于宝琴,王太勇,郭晓军,何改云,汪文津. 基于Oracle的企业异构数据流整合[J]. 计算机工程, 2004, 30(24): 47-48,51 |
| |
| 作者姓名： | 于宝琴 王太勇 郭晓军 何改云 汪文津 |
| |
| 作者单位： | 天津大学机械学院,天津,300072;天津财经大学信息系,天津,300222;天津大学机械学院,天津,300072 |
| |
| 基金项目： | 国家自然科学基金资助项目(50175081) |
| |
| 摘 要： | 以某生产制造型企业信息化工作为背景，针对企业信息化的一个瓶颈——异构数据集成问题，研究了一种低成本的数据移植方法，设计了一种新的专用ETL数据抽取工具，提出了企业最终建立数据仓库的关键技术。并通过从MySQL数据库向Oracle数据库移植数据为实例，成功验证了这种方法和工具的有效性。
|
| 关 键 词： | 异构数据流 数据移植 数据仓库 Oracl数据库 ETL PDM系统 |
| 文章编号： | 1000-3428(2004)24-0047-02 |
Oracle -based Integration of Heterogeneous Data Flows for Enterprises |
| |
| YU Baoqin,WANG Taiyong,GUO Xiaojun,HE Gaiyun,WANG Wenjin. Oracle -based Integration of Heterogeneous Data Flows for Enterprises[J]. Computer Engineering, 2004, 30(24): 47-48,51 |
| |
| Authors: | YU Baoqin WANG Taiyong GUO Xiaojun HE Gaiyun WANG Wenjin |
| |
| Affiliation: | YU Baoqin1,WANG Taiyong1,GUO Xiaojun1,HE Gaiyun1,WANG Wenjin1 2 |
| |
| 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. |
| |
| Keywords: | Heterogeneous data flows Data transplant Data warehouse Oracle database ETL PDM system |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
