一种提高数据仓库查询效率的有效方法

• 论文 •

一种提高数据仓库查询效率的有效方法

郭峻峰，倪志伟，高雅卓，伍章俊,

1.合肥工业大学管理学院，安徽合肥230009；2.合肥工业大学过程优化与智能决策教育部重点实验室，安徽合肥230009

出版日期:2009-12-15 发布日期:2009-12-25

Efficient method for improving query efficiency in data warehouse

GUO Jun-feng,NI Zhi-wei, GAO Ya-zhuo,WU Zhang-jun

1.School of Management, Hefei University of Technology, Hefei 230009, China;2.Key Laboratory of Process Optimization & Intelligent Decision-making, Ministry of Education, Hefei University of Technology, Hefei 230009, China

Online:2009-12-15 Published:2009-12-25

摘要/Abstract

摘要： 为了提高数据仓库的查询性能和效率，基于数据仓库本身组织和联机分析处理查询的特点，结合倒排索引、连接索引和聚集表，提出一种新的综合索引模型2H3I，并给出相应的算法。该模型在保证常用查询性能较高基础上，也提升了非常用查询的效率。理论分析和实验结果表明,2H3I是可行和有效的。

关键词: 高频连接, 高频维, 倒排索引, 连接索引

Abstract: In order to improve enquiry performance and efficiency of data warehouse, a new integrated index model called 2H3I was proposed. Based on the structure characteristics of Data Warehouse and on-line analytical processing, this index model was set up with inverted index, joining index and aggregation table, and corresponding algorithm was also presented. The model promoted the query efficiency of frequently used queries and non-frequently used queries. The analytical and experimental results showed that 2H3I was effective.

Key words: high-frequency join, high-frequency dimension, inverted index, joining index, aggregation table

中图分类号:

TP311

郭峻峰,，倪志伟,，高雅卓,，伍章俊,. 一种提高数据仓库查询效率的有效方法[J]. .

GUO Jun-feng,,NI Zhi-wei,, GAO Ya-zhuo,,WU Zhang-jun,. Efficient method for improving query efficiency in data warehouse[J]. .