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

数据仓库中位图连接索引的自动选择
引用本文:赵厚宝,苏勇.数据仓库中位图连接索引的自动选择[J].江南学院学报,2007,6(6):864-868.
作者姓名:赵厚宝  苏勇
作者单位:江苏科技大学电子信息学院,江苏镇江212003
摘    要:文中提出了一种基于数据仓库和位图连接索引的查询方法.该方法采用高效频集挖掘的数据挖掘技术,建立了一种自动索引选择框架,目的是解决数据仓库的自动管理.实验结果表明,该方法不仅在减少查询响应时间和数据仓库维护成本方面取得明显效果,而且对于其他的索引优化技术也提供了参考.

关 键 词:数据仓库  位图连接索引  频繁项集
文章编号:1671-7147(2007)06-0864-05
收稿时间:2007-05-04
修稿时间:2007-06-29

Automatic Selection of Bitmap Join Indexes in Data Warehouses
ZHAO Hou-bao, SU Yong.Automatic Selection of Bitmap Join Indexes in Data Warehouses[J].Journal of Jiangnan College,2007,6(6):864-868.
Authors:ZHAO Hou-bao  SU Yong
Abstract:The queries defined on data warehouses are complex and use several join operations that induce expensive computational cost. To improve response time, data warehouse administrators generally use indexing techniques such as star join indexes or bitmap join indexes. Our solution lies in the field of data warehouse auto-administration. In this framework, the paper proposes an automatic index selection strategy. The paper also explores a data mining technique, more precisely frequent itemset mining, to determine a set of candidate indexes from a given workload. Furthermore, the paper also proposes several cost models to allow to create an index configuration composed by the indexes providing the best profit. These models evaluate the cost of accessing data using bitmap join indexes, the cost of updating, and storing these indexes.
Keywords:data warehouses  bitmap join indexes  frequent itemset
本文献已被 维普 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

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