%0 Journal Article
%T Cache-Based Aggregate Query Shipping: An Efficient Scheme of Distributed OLAP Query Processing
%A Hua-Ming Liao
%A Guo-Shun Pei
%A <br>Hua-Ming
%A Liao
%A and
%A Guo-Shun
%A Pei
%J 计算机科学技术学报
%D 2008
%I 
%X Our study introduces a novel distributed query plan refinement phase in an enhanced architecture of distributed query processing engine(DQPE) . Query plan refinement generates potentially efficient distributed query plan by reusable aggregate query shipping(RAQS) approach. The approach improves response time at the cost of pre-processing time. If the overheads could not be compensated by query results reusage,RAQS is no more favorable. Therefore a global cost estimation model is employed to get proper operators:RR Agg,R Agg,or R Scan. For the purpose of reusing results of queries with aggregate function in distributed query processing,a multi-level hybrid view caching(HVC) scheme is introduced. The scheme retains the advantages of partial match and aggregate query results caching. By our solution,evaluations with distributed TPC-H queries show significant improvement on average response time.
%K distributed system
%K query optimization
%K reusability
%K query shipping
%K hybrid view caching<br>
%U http://www.alljournals.cn/get_abstract_url.aspx?pcid=5B3AB970F71A803DEACDC0559115BFCF0A068CD97DD29835&cid=8240383F08CE46C8B05036380D75B607&jid=F57FEF5FAEE544283F43708D560ABF1B&aid=642499F2ADD504FC6043A16BECA8B020&yid=67289AFF6305E306&vid=EA389574707BDED3&iid=B31275AF3241DB2D&sid=FE2777263ADBA5FE&eid=BD77137A0285B6FF&journal_id=1000-9000&journal_name=计算机科学技术学报&referenced_num=0&reference_num=15