数据仓库的存储优化设计

随着数据仓库逐渐成为企业决策支持的重要技术手段,对数据仓库的存储能力与性能的优化问题日益成为人们重视与关注的焦点之一。该文在数据仓库的模型结构以及数据分析过程中所采用的一些算法进行分析的基础上,对数据仓库与OLAP的数据存储方式以及优化的方法进行了深入的讨论,并在此基础上提出了一个通过数据分割技术存储细节数据,利用分层的方式来存储聚合数据,通过提高系统的并行处理能力来改善数据仓库系查询访问的效率的存储设计优化方案。

The Optimization Design about Data Warehouse Storage

As one of the important techniques in DSS,the storage capability and the system performance of data ware-house(DW)are becoming one of the most important fields and make more and more people focus on it.This paper dis-cusses the structure model of DW and some algorithms in the process of data mining firstly,and presents some methods of data storage and optimization about the DW and OLAP.Furthermore,it sets forth one solution to optimize data stor-age,which utilize the fragment technique to storage the detail data and the hierarchical structure to storage the aggre-gation data,and promotes the parallel process capability for improvement the query efficiency.