Cache-Based Aggregate Query Shipping: An Efficient Scheme of Distributed OLAP Query Processing
文献类型：期刊论文
| 作者 | Liao, Hua-Ming; Pei, Guo-Shun |
| 刊名 | JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY
 |
| 出版日期 | 2008-11-01 |
| 卷号 | 23期号:6页码:905-915 |
| 关键词 | distributed system query optimization reusability query shipping hybrid view caching |
| ISSN号 | 1000-9000 |
| DOI | 10.1007/s11390-008-9190-3 |
| 英文摘要 | 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. |
| 资助项目 | National Basic Research 973 Program of China[2005CB321807] ; National High Technology Rresearch and Development 863 Program of China[2006AA01A106] ; National High Technology Rresearch and Development 863 Program of China[2006AA04Z158] |
| WOS研究方向 | Computer Science |
| 语种 | 英语 |
| WOS记录号 | WOS:000261179300003 |
| 出版者 | SCIENCE PRESS |
| 源URL | [http://119.78.100.204/handle/2XEOYT63/11131]  |
| 专题 | 中国科学院计算技术研究所期刊论文_英文 |
| 通讯作者 | Liao, Hua-Ming |
| 作者单位 | Chinese Acad Sci, Inst Comp Technol, Res Ctr Grid & Serv Comp, Beijing 100190, Peoples R China |
| 推荐引用方式 GB/T 7714 | Liao, Hua-Ming,Pei, Guo-Shun. Cache-Based Aggregate Query Shipping: An Efficient Scheme of Distributed OLAP Query Processing[J]. JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY,2008,23(6):905-915. |
| APA | Liao, Hua-Ming,&Pei, Guo-Shun.(2008).Cache-Based Aggregate Query Shipping: An Efficient Scheme of Distributed OLAP Query Processing.JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY,23(6),905-915. |
| MLA | Liao, Hua-Ming,et al."Cache-Based Aggregate Query Shipping: An Efficient Scheme of Distributed OLAP Query Processing".JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY 23.6(2008):905-915. |
入库方式： OAI收割
来源：计算技术研究所
浏览0
下载0
收藏0
其他版本
除非特别说明，本系统中所有内容都受版权保护，并保留所有权利。