Parallel Modeling Of The Data Warehouse, Olap Interface Design, Data Extraction And Data Maintenance

Data Warehouse is a new focus of information technology. It stores integrated and historical data which supports query process and decision- making analysis. A lot of research work has been done at home and abroad. Many corporations have developed their data warehouse products, such as the MetaCube of INFORMIX corporation, Discover and Express of ORACLE corporation. But, these products are based on the relational database management system and there are many restrictions in supporting decision- making analysis. So, A parallel data warehouse management system(PDWMS) based on parallel computing environment has been developed by our group. It has adopted a multi-dimensional data model, supporting all kinds of complicated operations and decision-making analysis. The focus of this paper is on how to create prototype, design OLAP interface, extract data and maintain data for parallel data warehouse (PDW). In this dissertation, we propose the following algorithms and methods: creating prototype algorithm for PDW, a kind of new OLAP interface designing method, extracting data from many data source algorithm and maintaining data algorithm for PDW. These algorithms and methods have been used in PDW. It has been shown that they are effective and efficient.