Learned cardinalities: Estimating correlated joins with deep learning
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 …
convolutional network, tailored to representing relational query plans, that employs set …
Learning to optimize join queries with deep reinforcement learning
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 …
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 …
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
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 …
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 …
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
Database Management Systems (DBMS) are used ubiquitously. To efficiently access data,
they apply sophisticated optimizations. Incorrect optimizations can result in logic bugs, which …
they apply sophisticated optimizations. Incorrect optimizations can result in logic bugs, which …
The LDBC social network benchmark: Business intelligence workload
The Social Network Benchmark's Business Intelligence workload (SNB BI) is a
comprehensive graph OLAP benchmark targeting analytical data systems capable of …
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 …
multijoin queries. Our approach leveraging randomized hashing and data sketching to …
Quantifying TPC-H choke points and their optimizations
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 …
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 …
makes the use of quantum processing units (QPUs) attractive for many algorithmic database …