Enabling Adaptive Sampling for Intra-Window Join: Simultaneously Optimizing Quantity and Quality
Xilin Tang, Feng Zhang, Shuhao Zhang, Yani Liu, Bingsheng He, Xiaoyong Du
Abstract
>Sampling is one of the most widely employed approximations in big data processing. Among various challenges in sampling design, sampling for join is particularly intriguing yet complex. This perplexing problem starts with a classical case where the join of two Bernoulli samples shrinks its output size quadratically and exhibits a strong dependency on the input data, presenting a unique challenge that necessitates adaptive sampling to guarantee both the quantity and quality of the sampled data. The community has made strides in achieving this goal by constructing offline samples and integrating support from indexes or key frequencies. However, when dealing with stream data, due to the need for real-time processing and high-quality analysis, methods developed for processing static data become unavailable. Consequently, a fundamental question arises: Is it possible to achieve adaptive sampling in stream data without relying on offline techniques? To address this problem, we propose FreeSam, which couples hybrid sampling with intra-window join, a key stream join operator. Our focus lies on two widely used metrics: output size, ensuring quantity, and variance, ensuring quality. FreeSam enables adaptability in both the desired quantity and quality of data sampling by offering control on the two-dimensional space spanned by these metrics. Meanwhile, adjustable trade-offs between quality and performance make FreeSam practical for use. Our experiments show that, for every 1% increase in latency limitation, FreeSam can yield a 3.83% increase in the output size while maintaining the level of the estimator's variance. Additionally, we give FreeSam a multi-core implementation and ensure predictability of its latency through both an analytic model and a neural network model. The accuracy of these models is 88.05% and 96.75% respectively.
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 3e74a73e-9831-4297-afd8-5e57d1087b4dCited by top-tier papers3
- Tribase: A Vector Data Query Engine for Reliable and Lossless Pruning Compression using Triangle InequalitiesQian Xu, Juan Yang, Feng Zhang, Junda Pan et al.SIGMOD 2025 · 14 citations
- Succinct and Fast Tiny Pointer Hash TablesXilin Tang, Yuqi Mai, William Kuszmaul, Alex ConwayVLDB 2026
- Reasoning Through Execution: Unifying Process and Outcome Rewards for Code GenerationZhuohao Yu, Weizheng Gu, Yidong Wang, Xingru Jiang et al.ICML 2025
Builds on27
- Cardinality Estimation in DBMS: A Comprehensive Benchmark EvaluationYuxing Han, Ziniu Wu, Peizhi Wu, Rong Zhu et al.VLDB 2022 · 169 citations
- Towards Spatio- Temporal Aware Traffic Time Series ForecastingRazvan-Gabriel Cirstea, Bin Yang, Chenjuan Guo, Tung Kieu et al.ICDE 2022 · 137 citations
- Sliding Sketches: A Framework using Time Zones for Data Stream Processing in Sliding WindowsXiangyang Gou, Long He, Yinda Zhang, Ke Wang et al.KDD 2020 · 53 citations
- Efficient Sampling Approaches to Shapley Value ApproximationJiayao Zhang, Qiheng Sun, Jinfei Liu, Li Xiong et al.SIGMOD 2023 · 43 citations
- Move Fast and Meet Deadlines: Fine-grained Real-time Stream Processing with CameoLe Xu, Shivaram Venkataraman, Indranil Gupta, Luo Mai et al.NSDI 2021 · 38 citations
Related papers
- Join on Samples: A Theoretical Guide for PractitionersDawei Huang, Dong Young Yoon, Seth Pettie, Barzan MozafariVLDB 2020 · 13 citations
- Reservoir Sampling over JoinsBinyang Dai, Xiao Hu, Ke YiSIGMOD 2024 · 6 citations
- Low-Latency Adaptive Distributed Stream Join System Based on a Flexible Join ModelQihang Wang, Decheng Zuo, Zhan Zhang, Yanjun Shu et al.SIGMOD 2024
- JoinSketch: A Sketch Algorithm for Accurate and Unbiased Inner-Product EstimationFeiyu Wang, Qizhi Chen, Yuanpeng Li, Tong Yang et al.SIGMOD 2023 · 20 citations
- Adaptive Threshold SamplingDaniel TingSIGMOD 2022 · 3 citations
