联机分析多维存储结构的研究  

RESEARCH ON THE MULTIDIMENSIONAL STORAGE STRUCTURE OF ON-LINE ANALYTICAL PROCESSING

作　　者：李盛恩[1] 陆世潮[1] 

机构地区：[1]中国人民大学信息学院,北京100872

出　　处：《计算机应用与软件》2005年第9期55-56,117,共3页Computer Applications and Software

摘　　要：联机分析使用多维数组作为存储结构以加快查询响应时间。为了等同的对待每个维,适应稀疏数据,必须对多维数组进行划分。目前,有两种划分方法。本文分析了它们的优缺点,给出了一种统一的存储结构,实验结果表明,为了达到转换时间短和压缩比高的目的,要选择合适的划分向量和数据块体积。On-line analytical processing uses multidimensional array as storage structure to speed up response time. To treat every dimension equally and adapt to sparse data, it is necessary to partition multidimensional array. There are two types of partition methods. This paper analyzes merit and demerit of these methods and gives a unified storage structure. The results of experiment show it is important to select appropriate partition vector and size of a data block to obtain high compress ratio and to make translation from text file to multidimensional array rapidly.

关 键 词：数据仓库 联机分析 数据立方体 多维数组 存储结构 响应时间 转换时间 压缩比 数据块 查询 

分 类 号：TP311.12[自动化与计算机技术—计算机软件与理论] TP312[自动化与计算机技术—计算机科学与技术]