Adopting worst-case optimal joins in relational database systems

M Freitag, M Bandle, T Schmidt, A Kemper… - Proceedings of the …, 2020 - dl.acm.org
Worst-case optimal join algorithms are attractive from a theoretical point of view, as they offer
asymptotically better runtime than binary joins on certain types of queries. In particular, they …

Robust Join Processing with Diamond Hardened Joins

A Birler, A Kemper, T Neumann - Proceedings of the VLDB Endowment, 2024 - dl.acm.org
Join ordering and join processing has a huge impact on query execution and can easily
affect the query response time by orders of magnitude. In particular, when joins are …

Optimizing Queries with Many-to-Many Joins

H Kalumin, A Deshpande - arXiv preprint arXiv:2412.16323, 2024 - arxiv.org
As database query processing techniques are being used to handle diverse workloads, a
key emerging challenge is how to efficiently handle multi-way join queries containing …

[PDF][PDF] Dynamically Exploiting Factorized Representations

P Groß - 2024 - homepages.cwi.nl
Abstract While factorization and Worst-Case Optimal Join (WCOJ) algorithms promise
significant performance improvements, their widespread adoption lacks behind because …

Building an HTAP Database System for Modern Hardware

MJ Freitag - 2023 - mediatum.ub.tum.de
This thesis develops a comprehensive architectural blueprint for a high-performance flash-
based HTAP database system. In particular, we devise novel approaches for low-overhead …

[PDF][PDF] Towards Faster Answer Graphs

J van Merle - 2023 - research.tue.nl
The answer graph method is a query execution algorithm for graph databases that makes
smart use of factorization. It first constructs a factorized subgraph of the data graph …

[PDF][PDF] Beyond Worst-Case-Optimal Database Joins

F BARISIONE - users.dcc.uchile.cl
The natural join is arguably the most studied operation in database theory and systems. In
2008, the way traditional join algorithms work was found to be suboptimal and a new tight …