Learned Cardinality Estimation for Similarity Queries
Ji Sun, Guoliang Li, Nan Tang
摘要
In this paper, we study the problem of using deep neural networks (DNNs) for estimating the cardinality of similarity queries. Intuitively, DNNs can capture the distribution of data points, and learn to predict the number of data points that are similar to one data point (a similarity search) or a set of data points (a similarity join). However, DNNs are data hungry; directly training a DNN often results in poor performance. We propose two strategies to improve the accuracy and reduce the size of training data: query segmentation and data segmentation. Query segmentation divides a query into query segments, trains a neural network for each query segment, and combines their outputs with subsequent DNNs to get the query embedding. Data segmentation groups similar data into data segments, train a local-model for each data segment, and learn a global-model to decide which local-models should be used for a given query. The estimates from selected local-models will be summed up as the final estimate.We also extend our model to support similarity joins, which trains a DNN to directly estimate the cumulative sum of objects that are similar to a set of queries. Experiments show that our methods can efficiently (i.e., with small training data) learn to estimate the cardinality of similarity searches/joins, and yield effective estimates (i.e., close to real cardinalities).
问问这篇 Paper
问问你的智能体。
Lune 读过与它相关的顶会 Paper,每个回答都会注明依据哪几篇。
引用它的顶会 Paper16
- A Learned Query Rewrite System using Monte Carlo Tree SearchXuanhe Zhou, Guoliang Li, Chengliang Chai, Jianhua FengVLDB 2022 · 被引用 85 次
- CARMI: A Cache-Aware Learned Index with a Cost-based Construction AlgorithmJiaoyi Zhang, Yihan GaoVLDB 2022 · 被引用 42 次
- Fine-Grained Modeling and Optimization for Intelligent Resource Management in Big Data ProcessingChenghao Lyu, Qi Fan, Fei Song, Arnab Sinha 等VLDB 2022 · 被引用 14 次
- Selectivity Functions of Range Queries are LearnableXiao Hu, Yuxi Liu, Haibo Xiu, Pankaj K. Agarwal 等SIGMOD 2022 · 被引用 11 次
- PerfGuard: Deploying ML-for-Systems without Performance Regressions, Almost!H. M. Sajjad Hossain, Marc T. Friedman, Hiren Patel, Shi Qiao 等VLDB 2021 · 被引用 10 次
相关 Paper
- Cardinality Estimation of Approximate Substring Queries using Deep LearningSuyong Kwon, Woohwan Jung, Kyuseok ShimVLDB 2022 · 被引用 10 次
- Monotonic Cardinality Estimation of Similarity Selection: A Deep Learning ApproachYaoshu Wang, Chuan Xiao, Jianbin Qin, Xin Cao 等SIGMOD 2020 · 被引用 19 次
- Sample-Efficient Cardinality Estimation Using Geometric Deep LearningSilvan Reiner, Michael GrossniklausVLDB 2024 · 被引用 20 次
- Cardinality Estimation of LIKE Predicate Queries using Deep LearningSuyong Kwon, Kyuseok Shim, Woohwan JungSIGMOD 2025 · 被引用 3 次
- Deep Learning Models for Selectivity Estimation of Multi-Attribute QueriesShohedul Hasan, Saravanan Thirumuruganathan, Jees Augustine, Nick Koudas 等SIGMOD 2020 · 被引用 101 次
