OLAP性能分析及优化

Analysis and Optimization on OLAP Capability

数据仓库存储大量历史数据,OLAP应用涉及到对大面积历史数据的复杂查询,查询优化是提高OLAP响应速度的关键。目前最有效的方法是增加综合数据存储及查询方式的优化,但存储空间的有限限制了综合数据的存储量。常规优化数据库的方法不能满足OLAP的要求,针对以上出现的问题分别从数据仓库存储优化、OLAP实现方式的选择等工作出发,基于OLAP性能优化的查询优化策略等多角度实现对OLAP响应速度及提高查询优化。对这个问题进行了深入的研究。

Data warehouse stores volumes of historical data, and OLAP applications involve complex queries on these data. Queries optimization is the key of improving the speed of OLAP response. At present the most effective way is to increase the storage of general data and the way of queries, but the limited spaces restrict the storage of general data. The normal regula- tions is excellent to turn the method of the database can＇t satisfy the OI.AP request,this text aims at the problem of the above emergence respectively from the data warehouse saving excellent turn,the OLAP realizes choice, work of the way sets out. According to the function of OLAP the excellent the search that turn is excellent to turn strategy,many the angle realizes to respond to the OLAP speed and increase the search is excellent to turn. This paper studies it deeply on this problem.