首页 | 本学科首页   官方微博 | 高级检索  
     

一种提高数据仓库查询效率的有效方法
引用本文:郭峻峰,倪志伟,高雅卓,伍章俊.一种提高数据仓库查询效率的有效方法[J].计算机集成制造系统,2009,15(12).
作者姓名:郭峻峰  倪志伟  高雅卓  伍章俊
作者单位:合肥工业大学,管理学院,安徽,合肥,230009;合肥工业大学,过程优化与智能决策教育部重点实验室,安徽,合肥,230009
基金项目:国家863计划资助项目,国家自然科学基金资助项目(70871033).Foundation items:Project supported bythe National High-Tech. R&D program
摘    要:为了提高数据仓库的查询性能和效率,基于数据仓库本身组织和联机分析处理查询的特点,结合倒排索引、连接索引和聚集表,提出一种新的综合索引模型2H3I,并给出相应的算法.该模型在保证常用查询性能较高基础上,也提升了非常用查询的效率.理论分析和实验结果表明,2H3I是可行和有效的.

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

Efficient method for improving query efficiency in data warehouse
GUO Jun-feng,NI Zhi-wei,GAO Ya-zhuo,WU Zhang-jun.Efficient method for improving query efficiency in data warehouse[J].Computer Integrated Manufacturing Systems,2009,15(12).
Authors:GUO Jun-feng  NI Zhi-wei  GAO Ya-zhuo  WU Zhang-jun
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.
Keywords:high-frequency join  high-frequency dimension  inverted index  joining index  aggregation table
本文献已被 万方数据 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号