Weighted Distinct Sampling: Cardinality Estimation for SPJ Queries
Summary: Weighted distinct sampling (WDS) is proposed as a near-optimal framework for estimating SP cardinalities. The approach extends to SPJ queries, delivering the first non-trivial SPJ cardinality solution and is supported by extensive experiments. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Yuan Qiu (Hong Kong University of Science and Technology)
- 2. Yilei Wang (Hong Kong University of Science and Technology)
- 3. Ke Yi (Hong Kong University of Science and Technology; Shenzhen University)
- 4. Feifei Li (Alibaba)
- 5. Bin Wu (Alibaba)
- 6. Chaoqun Zhan (Alibaba)
BibTeX Citation
@inproceedings{qiu_sigmod21,
title = {{Weighted Distinct Sampling: Cardinality Estimation for SPJ Queries}},
author = {Qiu, Yuan and Wang, Yilei and Yi, Ke and Li, Feifei and Wu, Bin and Zhan, Chaoqun},
series = {{SIGMOD} '21},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3448016.3452821},
url = {https://dl.acm.org/doi/10.1145/3448016.3452821},
year = {2021}
}Incoming Citations (Sorted by Pagerank)
Showing 6 of 6 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 4,311 | ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads | 2024 | VLDB | 6.6727978e-05 |
| 5,058 | Fine-Grained Modeling and Optimization for Intelligent Resource Management in Big Data Processing | 2022 | VLDB | 6.2926774e-05 |
| 5,496 | Density-optimized Intersection-free Mapping and Matrix Multiplication for Join-Project Operations | 2022 | VLDB | 6.1049663e-05 |
| 8,004 | A Spark Optimizer for Adaptive, Fine-Grained Parameter Tuning | 2024 | VLDB | 5.4089097e-05 |
| 9,956 | Graph Transformers for Query Plan Representation: Potentials and Challenges | 2025 | VLDB | 5.1038322e-05 |
| 11,546 | Towards a Converged Relational-Graph Optimization Framework | 2024 | SIGMOD | 4.9793485e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 27 of 27 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 79 | Practical Selectivity Estimation through Adaptive Sampling | 1990 | SIGMOD |
| 2 | 1,536 | Cardinality Estimation: An Experimental Survey | 2018 | VLDB |
| 3 | 5,022 | Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server | 2023 | VLDB |
| 4 | 1,678 | Two-Level Sampling for Join Size Estimation | 2017 | SIGMOD |
| 5 | 10,700 | Sample-based Distinct Cardinality Estimation for Multiple Attributes in Multi-Dataset Queries | 2026 | VLDB |
| 6 | 1,203 | Fixed-Precision Estimation of Join Selectivity | 1993 | PODS |
| 7 | 9,632 | Small Selectivities Matter: Lifting the Burden of Empty Samples | 2021 | SIGMOD |
| 8 | 1,257 | Sampling-Based Query Re-Optimization | 2016 | SIGMOD |
| 9 | 2,433 | Cardinality Estimation Using Sample Views with Quality Assurance | 2007 | SIGMOD |
| 10 | 688 | Cardinality Estimation Done Right: Index-Based Join Sampling | 2017 | CIDR |