DBScholar

Back to papers

Join Size Estimation Subject to Filter Conditions

Summary: Correlated Sampling: single-pass, compact synopsis for estimating multi-table equality-join sizes under dynamic multi-attribute filters. Shows lower estimator variance than Bernoulli, End-Biased, and sketch-based baselines in theory and experiments. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h4ead19a1cb00f454
Venue
VLDB
Year
2015
Pagerank
0.00014234789
Overall Rank
752 | 94.97%
DOI
10.14778/2824032.2824038
PDF
Download (CC BY-NC-ND 3.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{vengerov_vldb15,
        title = {{Join Size Estimation Subject to Filter Conditions}},
        author = {Vengerov, David and Menck, Andre Cavalheiro and Zait, Mohamed and Chakkappen, Sunil P.},
        journal = {PVLDB},
        series = {{VLDB} '15},
        volume = {8},
        number = {12},
        pages = {1530--1541},
        doi = {10.14778/2824032.2824038},
        url = {https://doi.org/10.14778/2824032.2824038},
        year = {2015}
}

Incoming Citations (Sorted by Pagerank)

Showing 48 of 48 citing papers.

Rank Citing Paper Year Venue Pagerank
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035920657
594 Wander Join: Online Aggregation via Random Walks 2016 SIGMOD 0.00015814493
793 Random Sampling over Joins Revisited 2018 SIGMOD 0.00013903938
1,065 Approximate Query Processing: No Silver Bullet 2017 SIGMOD 0.00012181098
1,261 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011289724
1,444 Pessimistic Cardinality Estimation: Tighter Upper Bounds for Intermediate Join Cardinalities 2019 SIGMOD 0.00010616242
1,681 Two-Level Sampling for Join Size Estimation 2017 SIGMOD 9.8821344e-05
2,228 Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models 2017 VLDB 8.7912743e-05
2,635 Neural Subgraph Counting with Wasserstein Estimator 2022 SIGMOD 8.1795762e-05
2,829 G-CARE: A Framework for Performance Benchmarking of Cardinality Estimation Techniques for Subgraph Matching 2020 SIGMOD 7.9469964e-05
2,938 Data Sketches for Disaggregated Subset Sum and Frequent Item Estimation 2018 SIGMOD 7.8224388e-05
2,987 Accurate Summary-based Cardinality Estimation Through the Lens of Cardinality Estimation Graphs 2022 VLDB 7.767043e-05
3,093 Correlation Sketches for Approximate Join-Correlation Queries 2021 SIGMOD 7.6378811e-05
3,105 A Learned Sketch for Subgraph Counting 2021 SIGMOD 7.6278115e-05
3,212 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.5145409e-05
3,502 On Join Sampling and the Hardness of Combinatorial Output-Sensitive Join Algorithms 2023 PODS 7.2308675e-05
4,252 Adaptive Statistics in Oracle 12c 2017 VLDB 6.6894038e-05
5,029 COMPASS: Online Sketch-based Query Optimization for In-Memory Databases 2021 SIGMOD 6.2952031e-05
5,271 Cardinality Estimation of Subgraph Matching: A Filtering-Sampling Approach 2024 VLDB 6.1891764e-05
5,717 Combining Sampling and Synopses with Worst-Case Optimal Runtime and Quality Guarantees for Graph Pattern Cardinality Estimation 2021 SIGMOD 6.0067263e-05
5,841 Joins on Samples: A Theoretical Guide for Practitioners 2020 VLDB 5.9569427e-05
5,911 Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees 2025 SIGMOD 5.9338021e-05
6,485 Cardinality Estimation over Knowledge Graphs with Embeddings and Graph Neural Networks 2024 SIGMOD 5.7525455e-05
6,840 ASM: Harmonizing Autoregressive Model, Sampling, and Multi-dimensional Statistics Merging for Cardinality Estimation 2024 SIGMOD 5.6513231e-05
6,906 LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries 2024 SIGMOD 5.634971e-05
7,387 Weighted Distinct Sampling: Cardinality Estimation for SPJ Queries 2021 SIGMOD 5.5212177e-05
7,587 Convolution and Cross-Correlation of Count Sketches Enables Fast Cardinality Estimation of Multi-Join Queries 2024 SIGMOD 5.4745198e-05
7,626 Privacy Amplification by Sampling under User-level Differential Privacy 2024 SIGMOD 5.4657865e-05
7,902 Identifying Insufficient Data Coverage in Databases with Multiple Relations 2020 VLDB 5.4135994e-05
8,060 JoinSketch: A Sketch Algorithm for Accurate and Unbiased Inner-Product Estimation 2023 SIGMOD 5.382134e-05
8,446 Sampling Methods for Inner Product Sketching 2024 VLDB 5.3148581e-05
8,538 Optimistic Data Parallelism for FPGA-Accelerated Sketching 2023 VLDB 5.3049126e-05
8,790 One Size Does Not Fit All: A Bandit-Based Sampler Combination Framework with Theoretical Guarantees 2022 SIGMOD 5.2633515e-05
9,027 Scotch: Generating FPGA-Accelerators for Sketching at Line Rate 2021 VLDB 5.2200134e-05
9,460 Cost-efficient Data Acquisition on Online Data Marketplaces for Correlation Analysis 2019 VLDB 5.1596443e-05
9,810 Color: A Framework for Applying Graph Coloring to Subgraph Cardinality Estimation 2025 VLDB 5.112328e-05
9,837 NeuSO: Neural Optimizer for Subgraph Queries 2026 SIGMOD 5.1064323e-05
9,918 Towards a Unified Framework for String Similarity Joins 2019 VLDB 5.0983269e-05
9,935 Approximate Sketches 2024 SIGMOD 5.0941477e-05
10,094 SPACE: Cardinality Estimation for Path Queries Using Cardinality-Aware Sequence-based Learning 2025 SIGMOD 5.068372e-05
10,221 Path-centric Cardinality Estimation for Subgraph Matching 2025 VLDB 5.0460607e-05
10,480 Accelerating Approximate Analytical Join Queries over Unstructured Data with Statistical Guarantees 2026 SIGMOD 4.9605343e-05
10,584 Sublime: Sublinear Error & Space for Unbounded Skewed Streams 2026 SIGMOD 4.9605343e-05
10,699 CorrBound: Cardinality Estimation Accounting for Inter- and Intra-relation Correlations 2026 SIGMOD 4.9605343e-05
11,344 Evaluating Methods for Efficient Entity Count Estimation 2025 VLDB 4.9605343e-05
11,353 Cardinality Estimation for Having-Clauses 2025 VLDB 4.9605343e-05
11,591 Enabling Adaptive Sampling for Intra-Window Join: Simultaneously Optimizing Quantity and Quality 2024 SIGMOD 4.9605343e-05
12,251 Tighter Upper Bounds for Join Cardinality Estimates 2018 SIGMOD 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
311 Approximate Query Processing Using Wavelets 2000 VLDB 0.00021315058
432 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00018400309
750 Bifocal Sampling for Skew-Resistant Join Size Estimation 1996 SIGMOD 0.00014246313
844 Processing Complex Aggregate Queries over Data Streams 2002 SIGMOD 0.00013498392
1,206 Fixed-Precision Estimation of Join Selectivity 1993 PODS 0.00011510881
1,896 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.4010932e-05
Previous Page 1 / 1 Next

Semantically Similar Papers