Accelerating queries with group-by and join by groupjoin

Guido Moerkotte, Thomas Neumann

Research output: Contribution to journalConference articlepeer-review

30 Scopus citations

Abstract

Most aggregation queries contain both group-by and join operators, and spend a signicant amount of time evaluating these two expensive operators. Merging them into one operator (the groupjoin) signicantly speeds up query execution. We introduce two main equivalences to allow for the merging and prove their correctness. Furthermore, we show experimentally that these equivalences can signicantly speed up TPC-H.

Original languageEnglish
Pages (from-to)843-851
Number of pages9
JournalProceedings of the VLDB Endowment
Volume4
Issue number11
DOIs
StatePublished - Aug 2011
Event37th International Conference on Very Large Data Bases, VLDB 2011 - Seattle, United States
Duration: 29 Aug 20113 Sep 2011

Fingerprint

Dive into the research topics of 'Accelerating queries with group-by and join by groupjoin'. Together they form a unique fingerprint.

Cite this