基于半导体生产管理的数据仓库技术

描述了计算机集成制造(CIM)系统的体系结构及主要功能，提出了一种改进现有数据库管理系统的新型数据仓库设计技术。通过把在线事务处理数据库(OLTP)选择性地增量备份到一个临时的缓存(Cache)数据库，把Cache数据库中的数据增量提取到操作数据存储(ODS)数据仓库中，客户端通过水晶报表服务器或微软OLAP服务器，可直接访问ODS数据库中面向主题集成的各种事实型数据。通过Cache数据库，避免了OLTP数据库与ODS数据库的直接链接，减小了ODS数据仓库数据组合与计算对OLTP数据库的性能影响，最大限度地提升了OLTP数据库的效率，满足了生产线对OLTP数据库的高性能要求。

Data Warehouse Technology Based on Semiconductor Production Management

The system configuration of computer integrated manufacture (CIM) system and its main functions are described. And a new technology for designing data warehouse is presented to improve the existing database management system. The data increment in cache database is extracted to the data warehouse for operating data storage (ODS) by optionally backing up the data library of on-line transaction processing (OLTP) to a temporary cache database. Various subject integration oriented fact-based data in ODS database can be accessed directly from customer-oriented terminals through the crystal report server or Microsoft OLAP server. With cache database, the direct link of OLTP database with ODS database is avoided, and the effect of data composition and calculation in ODS data warehouse on the performance of OLTP database is reduced, improving the efficiency of OLTP data base significantly.