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

Efficient method for improving query efficiency in data warehouse

作　　者：郭峻峰[1,2] 倪志伟[1,2] 高雅卓[1,2] 伍章俊[1,2] 

机构地区：[1]合肥工业大学管理学院,安徽合肥230009 [2]合肥工业大学过程优化与智能决策教育部重点实验室,安徽合肥230009

出　　处：《计算机集成制造系统》2009年第12期2451-2457,共7页Computer Integrated Manufacturing Systems

基　　金：国家863计划资助项目(2007AA04Z116);国家自然科学基金资助项目(70871033)~~

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

关 键 词：高频连接 高频维 倒排索引 连接索引 聚集表 

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