A Novel, Low-latency Algorithm for Multiple Group-By Query Optimization

被引:0
作者
Duy-Hung Phan [1 ]
Michiardi, Pietro [1 ]
机构
[1] EURECOM, Biot, France
来源
2016 32ND IEEE INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE) | 2016年
关键词
D O I
暂无
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Data summarization is essential for users to interact with data. Current state of the art algorithms to optimize its most general form, the multiple Group By queries, have limitations in scalability. In this paper, we propose a novel algorithm, Top-Down Splitting, that scales to hundreds or even thousands of attributes and queries, and that quickly and efficiently produces optimized query execution plans. We analyze the complexity of our algorithm, and evaluate, empirically, its scalability and effectiveness through an experimental campaign. Results show that our algorithm is remarkably faster than alternatives in prior works, while generally producing better solutions. Ultimately, our algorithm reduces up to 34% the query execution time, when compared to un-optimized plans.
引用
收藏
页码:301 / 312
页数:12
相关论文
共 19 条
  • [1] Agarwal S., 1996, P VLDB
  • [2] Baer A., 2011, LADIS
  • [3] Ballamkonda S., 2004, Patent US Patent, Patent No. [6,775,681, 6775681]
  • [4] Beyer K., 1999, ACM SIGMOD
  • [5] Chang F., 2008, ACM TCS
  • [6] Chaudhuri S., 2004, P ACM SIGMOD
  • [7] Chen Y., 2012, PVLDB
  • [8] Chen Z., 2005, P ACM SIGMOD 2005
  • [9] Cieslewicz J., 2007, PVLDB
  • [10] DEAN J, 2004, ACM OSDI