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.9605343e-05
Overall Rank
11,195 | 24.96%
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.00058816744
30 SCOPE: Easy and Efficient Parallel Processing of Massive Data Sets 2008 VLDB 0.00050364918
67 An Amateur's Introduction to Recursive Query Processing Strategies 1986 SIGMOD 0.0003786983
216 Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing 1998 VLDB 0.00024446892
327 Impala: A Modern, Open-Source SQL Engine for Hadoop 2015 CIDR 0.00020904249
345 R* Optimizer Validation and Performance Evaluation for Distributed Queries 1986 VLDB 0.00020445813
353 On the Power of Magic 1987 PODS 0.0002014941
436 Shark: SQL and Rich Analytics at Scale 2013 SIGMOD 0.00018274105
452 Mergeable Summaries 2012 PODS 0.00018032092
651 Amazon Redshift Re-invented 2022 SIGMOD 0.00015126716
768 Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS 2007 VLDB 0.00014096379
894 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00013179915
1,032 Cost-Based Optimization for Magic: Algebra and Implementation 1996 SIGMOD 0.00012376627
1,039 Fine-grained Partitioning for Aggressive Data Skipping 2014 SIGMOD 0.00012349128
1,142 Direct Algorithms for Computing the Transitive Closure of Database Relations 1987 VLDB 0.00011812263
1,687 POLARIS: The Distributed SQL Engine in Azure Synapse 2020 VLDB 9.8500167e-05
1,842 Decidability and Undecidability Results for Boundedness of Linear Recursive Queries 1988 PODS 9.5141238e-05
1,850 Cheetah: A High Performance, Custom Data Warehouse on Top of MapReduce 2010 VLDB 9.4997173e-05
1,896 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.4010932e-05
2,041 Scalable Join Processing on Very Large RDF Graphs 2009 SIGMOD 9.1287048e-05
2,147 Quickstep: A Data Platform Based on the Scaling-Up Approach 2018 VLDB 8.9595129e-05
2,644 Big Data Analytics with Datalog Queries on Spark 2016 SIGMOD 8.1655777e-05
3,081 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.6515625e-05
3,094 Skipping-oriented Partitioning for Columnar Layouts 2017 VLDB 7.637515e-05
3,190 One WITH RECURSIVE is Worth Many GOTOs 2021 SIGMOD 7.5364422e-05
3,457 Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing 2019 SIGMOD 7.2667942e-05
3,601 Two Birds, One Stone: A Fast, yet Lightweight, Indexing Scheme for Modern Database Systems 2017 VLDB 7.1582591e-05
3,702 Implementation of Magic-sets in a Relational Database System 1994 SIGMOD 7.0617354e-05
3,766 Dimensions Based Data Clustering and Zone Maps 2017 VLDB 7.0177057e-05
4,078 Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates 2020 SIGMOD 6.8028789e-05
4,095 Apache Arrow DataFusion: A Fast, Embeddable, Modular Analytic Query Engine 2024 SIGMOD 6.7952274e-05
4,546 BigLake: BigQuery’s Evolution toward a Multi-Cloud Lakehouse 2024 SIGMOD 6.5341042e-05
4,773 Cuckoo Index: A Lightweight Secondary Index Structure 2020 VLDB 6.4102054e-05
4,790 Handling Redundancy in the Processing of Recursive Database Queries 1987 SIGMOD 6.4012965e-05
5,073 On the Optimization of Recursive Relational Queries: Application to Graph Queries 2020 SIGMOD 6.2738154e-05
5,701 A Parallel Processing Strategy for Evaluating Recursive Queries 1986 VLDB 6.0127868e-05
6,325 Automating Incremental and Asynchronous Evaluation for Recursive Aggregate Data Processing 2020 SIGMOD 5.7957351e-05
7,019 Statisticum: Data Statistics Management in SAP HANA 2017 VLDB 5.6041386e-05
7,112 On the Expected Size of Recursive Datalog Queries 1991 PODS 5.5809131e-05
7,329 Optimization for iterative queries on MapReduce 2014 VLDB 5.5364687e-05
8,176 Predicate Pushdown for Data Science Pipelines 2023 SIGMOD 5.3688159e-05
8,604 Conditional Cuckoo Filters 2021 SIGMOD 5.2899825e-05
9,047 Optimizing Parallel Recursive Datalog Evaluation on Multicore Machines 2022 SIGMOD 5.2168077e-05
9,382 Optimizing Recursive Queries in SQL 2005 SIGMOD 5.1704731e-05
10,351 Out-of-order Execution of Database Queries 2020 VLDB 5.0177035e-05
10,363 Optimizing Differentially-Maintained Recursive Queries on Dynamic Graphs 2022 VLDB 5.0122065e-05
10,364 The CORAL Deductive Database System 1993 SIGMOD 5.0122065e-05
Previous Page 1 / 1 Next

Semantically Similar Papers