Learned cardinalities: Estimating correlated joins with deep learning

A Kipf, T Kipf, B Radke, V Leis, P Boncz… - arXiv preprint arXiv …, 2018 - arxiv.org
arXiv preprint arXiv:1809.00677, 2018arxiv.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
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 …
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.
arxiv.org
以上显示的是最相近的搜索结果。 查看全部搜索结果