一种改进的数据仓库模型

An improved data warehouse structure model

数据仓库被看作是海量数据仓储,准确及时反映源数据库的改变对数据仓库查询响应的正确性至关重要。文章提出一种改进的数据仓库体系结构,在数据仓库中添加一个辅助结构作为接收和存储更新数据的暂存库,直到数据仓库获得空闲周期,加入新的数据和更新必要的视图;通过试验模拟2种数据仓库结构,验证了新的模型在设计和性能上的优越性。

As the data warehouse is a repository for vast amounts of diverse information, correct and prompt response to the changes in the source databases（SDBs） is critical to the correctness of the query responses given by the warehouse. In this paper, an improved data warehouse structure model is presented in which an auxiliary structure is added to the warehouse to accept the updates and store them until the data warehouse has available cycle time to incorporate the new data and update the necessary views. Finally, two data warehouse environments are simulated, and the results of simulation prove the superiority of the improved model in design and performance.