about
Estimating the Number of Results of Database Queries with Deep Learning (arxiv.org)
3 points by byteshift on Sep 14, 2018 | hide | past | pdf | discuss on HN

In plain words: A neural network reads each query as a set of features and learns to predict how many rows it returns, fixing sampling's blind spot when no sampled rows match. It guessed row counts more accurately than sampling alone, especially for joins across tables.

Abstract · 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 semantics to capture query features and true cardinalities. MSCN builds on sampling-based estimation, addressing its weaknesses when no sampled tuples qualify a predicate, and in capturing join-crossing correlations. Our evaluation of MSCN using a real-world dataset shows that deep learning significantly enhances the quality of cardinality estimation, which is the core problem in query optimization.

Andreas Kipf, Thomas Kipf, Bernhard Radke, Viktor Leis, Peter Boncz, Alfons Kemper
arXiv:1809.00677 · cs.DB · submitted Sep 3, 2018 · updated Dec 18, 2018
abstract · pdf · html · CIDR 2019. https://github.com/andreaskipf/learnedcardinalities

add comment on HN