One Size Does Not Fit All: A Bandit-Based Sampler Combination Framework with Theoretical Guarantees
Jinglin Peng, Bolin Ding, Jiannan Wang, Kai Zeng, Jingren Zhou
Abstract
Sample-based estimation, which uses a sample to estimate population parameters (e.g., SUM, COUNT, and AVG), has various applications in database systems. A sampler defines how samples are drawn from a population. Various samplers have been proposed (e.g., uniform sampler, stratified sampler, and measure-biased sampler), since there is no single sampler that works well in all cases. To overcome the "one size does not fit all" challenge, we study how to combine multiple samplers to estimate population parameters, and propose SamComb, a novel bandit-based sampler combination framework. Given a set of samplers, a budget, and a population parameter, SamComb can automatically decide how much budget should be allocated to each sampler so that the combined estimation achieves the highest accuracy. We model this sampler combination problem as a multi-armed bandit (MAB) problem and propose effective approaches to balance the exploration and exploitation trade-off in a principled way. We provide theoretical guarantees for our approaches and conduct extensive experiments on both synthetic and real datasets. The results show that there is a strong need to combine multiple samplers, in order to obtain accurate estimations without the knowledge about population predicates and distributions, and SamComb is an effective framework to achieve this goal.
Ask about this paper
Your agent reads all of it.
Lune indexed this paper to the last equation, along with the top-tier papers that cite it. Ask a question and the answer quotes them.
Your agent calls
Luneget_paper_fulltext
Free to start. No credit card required.
Terminal
Install the CLIlune papers fulltext 5aa2d1ed-6ac1-431e-b07b-c29b4ecf0974Cited by top-tier papers2
- AdaNDV: Adaptive Number of Distinct Value Estimation via Learning to Select and Fuse EstimatorsXianghong Xu, Tieying Zhang, Xiao He, Haoyang Li et al.VLDB 2025 · 3 citations
- Enabling Adaptive Sampling for Intra-Window Join: Simultaneously Optimizing Quantity and QualityXilin Tang, Feng Zhang, Shuhao Zhang, Yani Liu et al.SIGMOD 2025 · 1 citation
Builds on2
Related papers
- Guided SQL-Based Data Exploration with User FeedbackAntonis Mandamadiotis, Georgia Koutrika, Sihem Amer-YahiaICDE 2024 · 3 citations
- A Unified and Efficient Coordinating Framework for Autonomous DBMS TuningXinyi Zhang, Zhuo Chang, Hong Wu, Yang Li et al.SIGMOD 2023 · 17 citations
- Learning to Sample: Counting with Complex QueriesBrett Walenz, Stavros Sintos, Sudeepa Roy, Jun YangVLDB 2020 · 16 citations
- Tailoring Data Source Distributions for Fairness-aware Data IntegrationFatemeh Nargesian, Abolfazl Asudeh, H. V. JagadishVLDB 2021 · 51 citations
- HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design TuningR. Malinga Perera, Bastian Oetomo, Benjamin I. P. Rubinstein, Renata Borovica-GajicVLDB 2023 · 24 citations
