Learned cardinalities: Estimating correlated joins with deep learning

A Kipf, T Kipf, B Radke, V Leis, P Boncz… - arXiv preprint arXiv …, 2018 - arxiv.org
We describe a new deep learning approach to cardinality estimation. MSCN is a multi-set
convolutional network, tailored to representing relational query plans, that employs set …

Learning to optimize join queries with deep reinforcement learning

S Krishnan, Z Yang, K Goldberg, J Hellerstein… - arXiv preprint arXiv …, 2018 - arxiv.org
Exhaustive enumeration of all possible join orders is often avoided, and most optimizers
leverage heuristics to prune the search space. The design and implementation of heuristics …

Duckdb: an embeddable analytical database

M Raasveldt, H Mühleisen - … of the 2019 International Conference on …, 2019 - dl.acm.org
The immense popularity of SQLite shows that there is a need for unobtrusive in-process data
management solutions. However, there is no such system yet geared towards analytical …

A survey on advancing the dbms query optimizer: Cardinality estimation, cost model, and plan enumeration

H Lan, Z Bao, Y Peng - Data Science and Engineering, 2021 - Springer
Query optimizer is at the heart of the database systems. Cost-based optimizer studied in this
paper is adopted in almost all current database systems. A cost-based optimizer introduces …

Optimizing subgraph queries by combining binary and worst-case optimal joins

A Mhedhbi, S Salihoglu - Proceedings of the VLDB Endowment, 2019 - dl.acm.org
We study the problem of optimizing subgraph queries using the new worst-case optimal join
plans. Worst-case optimal plans evaluate queries by matching one query vertex at a time …

Detecting optimization bugs in database engines via non-optimizing reference engine construction

M Rigger, Z Su - Proceedings of the 28th ACM Joint Meeting on …, 2020 - dl.acm.org
Database Management Systems (DBMS) are used ubiquitously. To efficiently access data,
they apply sophisticated optimizations. Incorrect optimizations can result in logic bugs, which …

The LDBC social network benchmark: Business intelligence workload

G Szárnyas, J Waudby, BA Steer, D Szakállas… - Proceedings of the …, 2022 - dl.acm.org
The Social Network Benchmark's Business Intelligence workload (SNB BI) is a
comprehensive graph OLAP benchmark targeting analytical data systems capable of …

Pessimistic cardinality estimation: Tighter upper bounds for intermediate join cardinalities

W Cai, M Balazinska, D Suciu - … of the 2019 International Conference on …, 2019 - dl.acm.org
In this work we introduce a novel approach to the problem of cardinality estimation over
multijoin queries. Our approach leveraging randomized hashing and data sketching to …

Quantifying TPC-H choke points and their optimizations

M Dreseler, M Boissier, T Rabl, M Uflacker - Proceedings of the VLDB …, 2020 - dl.acm.org
TPC-H continues to be the most widely used benchmark for relational OLAP systems. It
poses a number of challenges, also known as" choke points", which database systems have …

Ready to leap (by co-design)? join order optimisation on quantum hardware

M Schönberger, S Scherzinger… - Proceedings of the ACM on …, 2023 - dl.acm.org
The prospect of achieving computational speedups by exploiting quantum phenomena
makes the use of quantum processing units (QPUs) attractive for many algorithmic database …