Ecole d'ingénieur et centre de recherche en Sciences du numérique

A novel, low-latency algorithm for multiple group-by query optimization

Phan, Duy-Hung; Michiardi, Pietro

ICDE 2016, 32nd IEEE International Conference on Data Engineering, May 16-20, 2016, Helsinki, Finland

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.

Document Doi Bibtex

Titre:A novel, low-latency algorithm for multiple group-by query optimization
Type:Conférence
Langue:English
Ville:Helsinki
Pays:FINLANDE
Date:
Département:Data Science
Eurecom ref:4827
Copyright: © 2016 IEEE. Personal use of this material is permitted. However, permission to reprint/republish this material for advertising or promotional purposes or for creating new collective works for resale or redistribution to servers or lists, or to reuse any copyrighted component of this work in other works must be obtained from the IEEE.
Bibtex: @inproceedings{EURECOM+4827, doi = {http://dx.doi.org/10.1109/ICDE.2016.7498249}, year = {2016}, title = {{A} novel, low-latency algorithm for multiple group-by query optimization}, author = {{P}han, {D}uy-{H}ung and {M}ichiardi, {P}ietro}, booktitle = {{ICDE} 2016, 32nd {IEEE} {I}nternational {C}onference on {D}ata {E}ngineering, {M}ay 16-20, 2016, {H}elsinki, {F}inland}, address = {{H}elsinki, {FINLANDE}}, month = {05}, url = {http://www.eurecom.fr/publication/4827} }
Voir aussi: