设备物资管理数据仓库的数据采集策略

Data Acquisition Strategy of Equipment and Materials Management on Data Warehouse

数据采集是数据仓库信息集成的基础,也是整个数据仓库构建的核心。提出了设备物资管理数据仓库的整体架构,并利用Oracle存储过程和触发器来实现数据仓库的数据采集,建立了设备物资管理数据仓库的解决方案,使得设备物资管理效率提高,为企业的生产运行追求了最佳成本。

Data acquisition is not only the basis of information integration, but also the entire core of building a data warehouse. The over- all structure of equipment and materials management system on data warehouse was proposed in the paper, by using Oracle＇s procedures and triggers to achieve the data acquisition of data warehouse, the data warehouse solution of equipment and materials management is established, which improved the efficiency of equipment and materials management in the best pursuit of enterprise