DBScholar

Back to papers

Random Sampling over Joins Revisited

Summary: Revisits random sampling over multi-way joins (acyclic and cyclic) with a general framework that subsumes Chaudhuri et al.'s approach. Explores instantiations under different data priors, balancing latency and throughput, and demonstrates superiority over baselines. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h3cff514cb6ec7fb2
Venue
SIGMOD
Year
2018
Pagerank
0.00013934719
Overall Rank
795 | 94.66%
DOI
10.1145/3183713.3183739

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{zhao_sigmod18,
        title = {{Random Sampling over Joins Revisited}},
        author = {Zhao, Zhuoyue and Christensen, Robert and Li, Feifei and Hu, Xiao and Yi, Ke},
        series = {{SIGMOD} '18},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3183713.3183739},
        url = {https://dl.acm.org/doi/10.1145/3183713.3183739},
        year = {2018}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 66 citing papers.

Rank Citing Paper Year Venue Pagerank
510 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017059914
981 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012713454
1,735 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.7566604e-05
1,828 DBEst: Revisiting Approximate Query Processing Engines with Machine Learning Models 2019 SIGMOD 9.547768e-05
2,002 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.2076835e-05
2,342 Learned Cardinality Estimation: An In-depth Study 2022 SIGMOD 8.6074783e-05
2,456 Towards Practical Oblivious Join 2022 SIGMOD 8.4350645e-05
2,518 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3532841e-05
2,635 Neural Subgraph Counting with Wasserstein Estimator 2022 SIGMOD 8.1954989e-05
2,757 Answering (Unions of) Conjunctive Queries using Random Access and Random-Order Enumeration 2020 PODS 8.0487636e-05
2,824 G-CARE: A Framework for Performance Benchmarking of Cardinality Estimation Techniques for Subgraph Matching 2020 SIGMOD 7.9662478e-05
2,844 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9446987e-05
3,053 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7041081e-05
3,161 A Learned Sketch for Subgraph Counting 2021 SIGMOD 7.5771609e-05
3,494 On Join Sampling and the Hardness of Combinatorial Output-Sensitive Join Algorithms 2023 PODS 7.2548566e-05
3,742 FACE: A Normalizing Flow based Cardinality Estimator 2022 VLDB 7.0564546e-05
3,983 Simplicity Done Right for Join Ordering 2021 CIDR 6.8722161e-05
3,994 Guaranteeing the O~(AGM/OUT) Runtime for Uniform Sampling and Size Estimation over Joins 2023 PODS 6.8652819e-05
4,299 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 6.6766173e-05
4,459 Lightweight and Accurate Cardinality Estimation by Neural Network Gaussian Process 2022 SIGMOD 6.5883555e-05
4,644 Efficient Join Synopsis Maintenance for Data Warehouse 2020 SIGMOD 6.4869417e-05
5,129 Monotonic Cardinality Estimation of Similarity Selection: A Deep Learning Approach 2020 SIGMOD 6.2582129e-05
5,236 FASTgres: Making Learned Query Optimizer Hinting Effective 2023 VLDB 6.2153504e-05
5,418 Towards Distribution-aware Query Answering in Data Markets 2022 VLDB 6.1370792e-05
5,426 Cardinality Estimation of Subgraph Matching: A Filtering-Sampling Approach 2024 VLDB 6.1332147e-05
5,610 Responsible Data Integration: Next-generation Challenges 2022 SIGMOD 6.0660772e-05
5,657 PGMJoins: Random Join Sampling with Graphical Models 2021 SIGMOD 6.0461e-05
5,715 Detect, Distill and Update: Learned DB Systems Facing Out of Distribution Data 2023 SIGMOD 6.0178585e-05
5,829 Joins on Samples: A Theoretical Guide for Practitioners 2020 VLDB 5.9764044e-05
5,904 Combining Sampling and Synopses with Worst-Case Optimal Runtime and Quality Guarantees for Graph Pattern Cardinality Estimation 2021 SIGMOD 5.9511271e-05
6,202 Combining Aggregation and Sampling (Nearly) Optimally for Approximate Query Processing 2021 SIGMOD 5.8494367e-05
6,472 Cardinality Estimation over Knowledge Graphs with Embeddings and Graph Neural Networks 2024 SIGMOD 5.7716301e-05
6,552 JoinBoost: Grow Trees Over Normalized Data Using Only SQL 2023 VLDB 5.7475822e-05
6,889 LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries 2024 SIGMOD 5.6536655e-05
7,152 Learning to Sample: Counting with Complex Queries 2020 VLDB 5.5959861e-05
7,203 Coresets over Multiple Tables for Feature-rich and Data-efficient Machine Learning 2023 VLDB 5.5845207e-05
7,248 Efficient Dynamic Weighted Set Sampling and Its Extension 2024 VLDB 5.572362e-05
7,471 Reservoir Sampling over Joins 2024 SIGMOD 5.5172544e-05
7,518 Computing A Well-Representative Summary of Conjunctive Query Results 2024 PODS 5.5023404e-05
7,749 PilotDB: Database-Agnostic Online Approximate Query Processing with A Priori Error Guarantees 2025 SIGMOD 5.4585522e-05
8,285 Subset Sampling over Joins 2026 PODS 5.3612232e-05
8,351 alpha to omega: The Greek Alphabet of Sampling 2020 CIDR 5.3480813e-05
8,667 ShadowAQP: Efficient Approximate Group-by and Join Query via Attribute-oriented Sample Size Allocation and Data Generation 2023 VLDB 5.2905894e-05
8,771 One Size Does Not Fit All: A Bandit-Based Sampler Combination Framework with Theoretical Guarantees 2022 SIGMOD 5.2808131e-05
9,154 One Seed, Two Birds: A Unified Learned Structure for Exact and Approximate Counting 2024 SIGMOD 5.2176438e-05
9,642 Poisson Sampling over Acyclic Joins 2026 SIGMOD 5.1445295e-05
9,657 gSWORD: GPU-accelerated Sampling for Subgraph Counting 2024 SIGMOD 5.142891e-05
9,804 NeuSO: Neural Optimizer for Subgraph Queries 2026 SIGMOD 5.1233734e-05
10,157 Threshold Queries in Theory and in the Wild 2022 VLDB 5.0691578e-05
10,187 Path-centric Cardinality Estimation for Subgraph Matching 2025 VLDB 5.0628015e-05
Previous Page 1 / 2 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.

Rank Cited Paper Year Venue Pagerank
9 Online Aggregation 1997 SIGMOD 0.00076265429
23 Spark SQL: Relational Data Processing in Spark 2015 SIGMOD 0.00055384955
57 On Random Sampling over Joins 1999 SIGMOD 0.00040095727
135 Ripple Joins for Online Aggregation 1999 SIGMOD 0.00029858107
138 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00029618887
429 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00018445263
521 Learning Linear Regression Models over Factorized Joins 2016 SIGMOD 0.00016923519
596 Wander Join: Online Aggregation via Random Walks 2016 SIGMOD 0.00015782051
731 Learning Generalized Linear Models Over Normalized Data 2015 SIGMOD 0.00014400356
746 Bifocal Sampling for Skew-Resistant Join Size Estimation 1996 SIGMOD 0.00014282427
749 Join Size Estimation Subject to Filter Conditions 2015 VLDB 0.00014261044
841 Quickr: Lazily Approximating Complex AdHoc Queries in BigData Clusters 2016 SIGMOD 0.00013543
947 Aqua: A Fast Decision Support System Using Approximate Query Answers 1999 VLDB 0.00012920489
1,021 Online Aggregation for Large MapReduce Jobs 2011 VLDB 0.00012437619
1,090 Scalable Approximate Query Processing With The DBO Engine 2007 SIGMOD 0.00012074369
1,258 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011308863
1,292 From Theory to Practice: Efficient Join Query Evaluation in a Parallel Database System 2015 SIGMOD 0.00011147959
1,820 A Scalable Hash Ripple Join Algorithm 2002 SIGMOD 9.5651265e-05
1,869 G-OLA: Generalized On-Line Aggregation for Interactive Analysis on Big Data 2015 SIGMOD 9.4749419e-05
1,892 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.4150583e-05
2,003 Sample + Seek: Approximating Aggregates with Distribution Precision Guarantee 2016 SIGMOD 9.2071735e-05
3,085 Continuous Sampling for Online Aggregation Over Multiple Queries 2010 SIGMOD 7.6607519e-05
3,213 Turbo-Charging Estimate Convergence in DBO 2009 VLDB 7.5304969e-05
3,819 Spatial Online Sampling and Aggregation 2016 VLDB 7.0027383e-05
3,904 Distributed Online Aggregations 2009 VLDB 6.9307047e-05
5,474 ABS: a System for Scalable Approximate Queries with Accuracy Guarantees 2014 SIGMOD 6.1159955e-05
8,550 The DBO Database System 2008 SIGMOD 5.3162466e-05
Previous Page 1 / 1 Next

Semantically Similar Papers