PAC: Computing Join Queries with Semi-Covers

An increased and growing interest in large-scale data processing has triggered a demand for specialized algorithms that thrive in massively parallel shared-nothing systems. To answer the question of how to efficiently compute join queries in this setting, a rich line of research has emerged specifically for the Massively Parallel Communication (MPC) model. In the MPC model, algorithms are executed in rounds, with each round consisting of a synchronized communication phase and a separate local computation phase. The main cost measure is the load of the algorithm, defined as the maximum number of messages received by any server in any round. We study worst-case optimal algorithms for the join query evaluation problem in the constant-round MPC model. In the single-round variant of the MPC model, the worst-case optimal load for this problem is well understood and algorithms exist that guarantee this load for any join query. In the constant-round variant of the MPC model, queries can often be computed with a lower load compared to the single-round variant, but the worst-case optimal load is only known for specific classes of queries, including the graph-like join queries and the acyclic join queries. Each of these classes has its own associated algorithms to achieve the worst-case optimal load, and these algorithms rely on very different techniques that are specific to the class. In this paper, we propose a new, unified constant-round MPC algorithm for computing join queries. This algorithm is correct for every join query and preserves the worst-case optimal load for many queries, particularly all join queries that are acyclic or graph-like. Additionaly, the algorithm is shown to be worst-case optimal for a new class of cyclic queries.

Authors

Institutions

Publication Details

Journal
ACM Transactions on Database Systems
Published
2026-06-09
DOI
https://doi.org/10.1145/3820043
Primary Topic
Advanced Database Systems and Queries
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

PAC: Computing Join Queries with Semi-Covers

Bas Ketsman, Heba Aamer
ACM Transactions on Database Systems
Advanced Database Systems and Queries
article

PAC: Computing Join Queries with Semi-Covers

Bas Ketsman, Heba Aamer
article en

Abstract

An increased and growing interest in large-scale data processing has triggered a demand for specialized algorithms that thrive in massively parallel shared-nothing systems. To answer the question of how to efficiently compute join queries in this setting, a rich line of research has emerged specifically for the Massively Parallel Communication (MPC) model. In the MPC model, algorithms are executed in rounds, with each round consisting of a synchronized communication phase and a separate local computation phase. The main cost measure is the load of the algorithm, defined as the maximum number of messages received by any server in any round. We study worst-case optimal algorithms for the join query evaluation problem in the constant-round MPC model. In the single-round variant of the MPC model, the worst-case optimal load for this problem is well understood and algorithms exist that guarantee this load for any join query. In the constant-round variant of the MPC model, queries can often be computed with a lower load compared to the single-round variant, but the worst-case optimal load is only known for specific classes of queries, including the graph-like join queries and the acyclic join queries. Each of these classes has its own associated algorithms to achieve the worst-case optimal load, and these algorithms rely on very different techniques that are specific to the class. In this paper, we propose a new, unified constant-round MPC algorithm for computing join queries. This algorithm is correct for every join query and preserves the worst-case optimal load for many queries, particularly all join queries that are acyclic or graph-like. Additionaly, the algorithm is shown to be worst-case optimal for a new class of cyclic queries.

ACM Transactions on Database Systems
Vrije Universiteit Brussel (BE), Hasselt University (BE)
Openalex Percentile: Top 5%
Advanced Database Systems and Queries
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

PAC: Computing Join Queries with Semi-Covers — Bas Ketsman, Heba Aamer · ACM Transactions on Database Systems (2026) | TGRS Research Map | TGRS