%0 Journal Article
%T A Fast Selection Method at Large Table of Data in Data Warehouse<br>数据仓库中大表数据的一种快速选择方法
%A WANG Yong
%A DAI Mu-Hong
%A <br>王勇
%A 戴牡红
%J 计算机系统应用
%D 2011
%I 
%X Traditional selecting optimization structures at large table in data warehouse can only either shorten the time of query processing, or reduce the storage and maintenance overhead. It can＇t achieve a combined effect at the same time. Based on the traditional optimization techniques, this paper proposes a new approach, namely, HP→BIs, by exploiting their similarities of horizontal partitioning and bitmap indexes. Experimental results show that with this approach, we can significantly shorten the time of query processing, reduce the storage and maintenance cost.
%K data warehouse
%K decision support system
%K bitmap indexes
%K horizontal partitioning
%K optimization<br>数据仓库
%K 决策支持系统
%K 位图索引
%K 水平分区
%K 性能优化
%U http://www.alljournals.cn/get_abstract_url.aspx?pcid=5B3AB970F71A803DEACDC0559115BFCF0A068CD97DD29835&cid=8240383F08CE46C8B05036380D75B607&jid=D4F6864C950C88FFCE5B6C948A639E39&aid=48687FEEF97E5861AC26793FFD1EC0C6&yid=9377ED8094509821&vid=A04140E723CB732E&iid=9CF7A0430CBB2DFD&sid=D9AE183D3F5C3C75&eid=FD4B826C6FB18FB5&journal_id=1003-3254&journal_name=计算机系统应用&referenced_num=0&reference_num=11