DBScholar

Back to papers

Dynamic Pruning for Recursive Joins

Summary: Dynamic pruning for recursive joins generates runtime filters per step, enabling deeper joins with fewer scanned tuples. Prototype evaluations show up to 135.6x speedups vs baseline and 3.99x vs state-of-the-art pruning, with negligible per-step overhead. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h44d795ccdeaa5eee
Venue
SIGMOD
Year
2025
Pagerank
4.9769913e-05
Overall Rank
11,135 | 25.16%
DOI
10.1145/3722212.3724434
PDF
Download (CC BY 4.0)

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

BibTeX Citation

@inproceedings{nishikawa_sigmod25,
        title = {{Dynamic Pruning for Recursive Joins}},
        author = {Nishikawa, Norifumi and Shimizu, Akira and Ito, Akira and Fujiwara, Shinji and Hayamizu, Yuto and Kitsuregawa, Masaru and Goda, Kazuo},
        series = {{SIGMOD} '25},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3722212.3724434},
        url = {https://dl.acm.org/doi/10.1145/3722212.3724434},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank Citing Paper Year Venue Pagerank
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 47 of 47 cited papers.

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

Rank Cited Paper Year Venue Pagerank
18 MAGIC SETS AND OTHER STRANGE WAYS TO IMPLEMENT LOGIC PROGRAMS (Extended Abstract) 1986 PODS 0.00058997063
30 SCOPE: Easy and Efficient Parallel Processing of Massive Data Sets 2008 VLDB 0.00050475202
67 An Amateur's Introduction to Recursive Query Processing Strategies 1986 SIGMOD 0.00037991902
216 Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing 1998 VLDB 0.00024485637
327 Impala: A Modern, Open-Source SQL Engine for Hadoop 2015 CIDR 0.00020942751
345 R* Optimizer Validation and Performance Evaluation for Distributed Queries 1986 VLDB 0.0002045459
353 On the Power of Magic 1987 PODS 0.00020213935
432 Shark: SQL and Rich Analytics at Scale 2013 SIGMOD 0.00018331051
456 Mergeable Summaries 2012 PODS 0.00017904764
681 Amazon Redshift Re-invented 2022 SIGMOD 0.0001482366
762 Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS 2007 VLDB 0.00014134432
907 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00013157412
1,032 Cost-Based Optimization for Magic: Algebra and Implementation 1996 SIGMOD 0.00012396854
1,036 Fine-grained Partitioning for Aggressive Data Skipping 2014 SIGMOD 0.00012372946
1,140 Direct Algorithms for Computing the Transitive Closure of Database Relations 1987 VLDB 0.00011847659
1,790 POLARIS: The Distributed SQL Engine in Azure Synapse 2020 VLDB 9.6227952e-05
1,830 Decidability and Undecidability Results for Boundedness of Linear Recursive Queries 1988 PODS 9.5453747e-05
1,838 Cheetah: A High Performance, Custom Data Warehouse on Top of MapReduce 2010 VLDB 9.5305061e-05
1,892 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.4150583e-05
2,029 Scalable Join Processing on Very Large RDF Graphs 2009 SIGMOD 9.1580838e-05
2,139 Quickstep: A Data Platform Based on the Scaling-Up Approach 2018 VLDB 8.9735524e-05
2,636 Big Data Analytics with Datalog Queries on Spark 2016 SIGMOD 8.1926426e-05
3,075 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.6742518e-05
3,083 Skipping-oriented Partitioning for Columnar Layouts 2017 VLDB 7.6620866e-05
3,195 One WITH RECURSIVE is Worth Many GOTOs 2021 SIGMOD 7.546228e-05
3,446 Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing 2019 SIGMOD 7.2908619e-05
3,592 Two Birds, One Stone: A Fast, yet Lightweight, Indexing Scheme for Modern Database Systems 2017 VLDB 7.1807308e-05
3,707 Implementation of Magic-sets in a Relational Database System 1994 SIGMOD 7.0789307e-05
3,763 Dimensions Based Data Clustering and Zone Maps 2017 VLDB 7.0389893e-05
4,062 Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates 2020 SIGMOD 6.8215782e-05
4,074 Apache Arrow DataFusion: A Fast, Embeddable, Modular Analytic Query Engine 2024 SIGMOD 6.8175757e-05
4,531 BigLake: BigQuery’s Evolution toward a Multi-Cloud Lakehouse 2024 SIGMOD 6.5557817e-05
4,755 Cuckoo Index: A Lightweight Secondary Index Structure 2020 VLDB 6.4309508e-05
4,770 Handling Redundancy in the Processing of Recursive Database Queries 1987 SIGMOD 6.4225302e-05
5,054 On the Optimization of Recursive Relational Queries: Application to Graph Queries 2020 SIGMOD 6.2946294e-05
5,692 A Parallel Processing Strategy for Evaluating Recursive Queries 1986 VLDB 6.0326851e-05
6,312 Automating Incremental and Asynchronous Evaluation for Recursive Aggregate Data Processing 2020 SIGMOD 5.8149275e-05
7,000 Statisticum: Data Statistics Management in SAP HANA 2017 VLDB 5.6226404e-05
7,090 On the Expected Size of Recursive Datalog Queries 1991 PODS 5.5994281e-05
7,311 Optimization for iterative queries on MapReduce 2014 VLDB 5.5546605e-05
8,159 Predicate Pushdown for Data Science Pipelines 2023 SIGMOD 5.3866275e-05
8,587 Conditional Cuckoo Filters 2021 SIGMOD 5.3075325e-05
9,026 Optimizing Parallel Recursive Datalog Evaluation on Multicore Machines 2022 SIGMOD 5.2341149e-05
9,356 Optimizing Recursive Queries in SQL 2005 SIGMOD 5.187626e-05
10,325 Out-of-order Execution of Database Queries 2020 VLDB 5.0343502e-05
10,337 Optimizing Differentially-Maintained Recursive Queries on Dynamic Graphs 2022 VLDB 5.0288349e-05
10,338 The CORAL Deductive Database System 1993 SIGMOD 5.0288349e-05
Previous Page 1 / 1 Next

Semantically Similar Papers