%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
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
%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