Practical planning and execution of groupjoin and nested aggregates

Groupjoins combine execution of a join and a subsequent group-by . They are common in analytical queries and occur in about of the queries in TPC-H and TPC-DS. While they were originally invented to improve performance, efficient parallel execution of groupjoins can be limited by contention in many-...

Full description

Bibliographic Details

Published in:	The VLDB journal Vol. 32; no. 6; pp. 1165 - 1190
Main Authors:	Fent, Philipp, Birler, Altan, Neumann, Thomas
Format:	Journal Article
Language:	English
Published:	Berlin/Heidelberg Springer Berlin Heidelberg 01.11.2023 Springer Nature B.V
Subjects:	Aggregates Algorithms Computer Science Database Management Estimates Optimization Queries Semantics Special Issue Paper Query processing Parallel processing Query optimization
ISSN:	1066-8888, 0949-877X
Online Access:	Get full text
Tags:	Add Tag No Tags, Be the first to tag this record!