摘要: 针对企业信息化建设过程中需要集成数据孤岛的问题,采用建设共享数据仓库的思想,利用完成ETL功能的DTS组件从遗留信息系统中整合数据,加载到一个集中的数据仓库中,满足当前对数据存储、查询、统计、分析等的一系列要求,并在该平台上实现全企业的资源规划。给出利用DTS组件集成分布式数据库系统的方案及其总体结构,以及在B/S模式下调度DTS包的部分关键实现代码。
关键词:
数据仓库,
ETL功能,
DTS组件
Abstract: Aiming at the data island in the management information system, this paper introduces the principle of share data warehouse, integrates the data from information system using DTS to complete the function of ETL, and loads these data into an integrated data warehouse, satisfying the requirements of data storage, query, statistic etc. It realizes whole Enterprise Resource Planning(ERP). It gives a method to call the DTS package under B/S scheme and the whole structure of the scheme and part of key code.
Key words:
data warehouse,
ETL function,
DTS component
中图分类号:
邱云飞;邵良杉;那宝贵. 基于DTS组件的分布式数据库系统集成[J]. 计算机工程, 2008, 34(9): 112-113,.
QIU Yun-fei; SHAO Liang-shan; NA Bao-gui. Integration of Distributed Database Based on DTS Component[J]. Computer Engineering, 2008, 34(9): 112-113,.