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.9793485e-05
Overall Rank
11,126 | 25.20%
DOI
10.1145/3722212.3724434

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.00059023577
30 SCOPE: Easy and Efficient Parallel Processing of Massive Data Sets 2008 VLDB 0.00050495102
67 An Amateur's Introduction to Recursive Query Processing Strategies 1986 SIGMOD 0.00038009523
216 Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing 1998 VLDB 0.00024485024
327 Impala: A Modern, Open-Source SQL Engine for Hadoop 2015 CIDR 0.0002095191
344 R* Optimizer Validation and Performance Evaluation for Distributed Queries 1986 VLDB 0.00020461727
352 On the Power of Magic 1987 PODS 0.00020223279
432 Shark: SQL and Rich Analytics at Scale 2013 SIGMOD 0.00018339357
456 Mergeable Summaries 2012 PODS 0.0001791284
680 Amazon Redshift Re-invented 2022 SIGMOD 0.00014828697
762 Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS 2007 VLDB 0.00014140446
906 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00013160654
1,032 Cost-Based Optimization for Magic: Algebra and Implementation 1996 SIGMOD 0.00012401489
1,036 Fine-grained Partitioning for Aggressive Data Skipping 2014 SIGMOD 0.00012377471
1,140 Direct Algorithms for Computing the Transitive Closure of Database Relations 1987 VLDB 0.00011853213
1,790 POLARIS: The Distributed SQL Engine in Azure Synapse 2020 VLDB 9.6272006e-05
1,830 Decidability and Undecidability Results for Boundedness of Linear Recursive Queries 1988 PODS 9.5498891e-05
1,837 Cheetah: A High Performance, Custom Data Warehouse on Top of MapReduce 2010 VLDB 9.5350058e-05
1,891 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.4184294e-05
2,026 Scalable Join Processing on Very Large RDF Graphs 2009 SIGMOD 9.1624074e-05
2,137 Quickstep: A Data Platform Based on the Scaling-Up Approach 2018 VLDB 8.9777553e-05
2,635 Big Data Analytics with Datalog Queries on Spark 2016 SIGMOD 8.1965216e-05
3,073 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.6777283e-05
3,081 Skipping-oriented Partitioning for Columnar Layouts 2017 VLDB 7.6653727e-05
3,194 One WITH RECURSIVE is Worth Many GOTOs 2021 SIGMOD 7.5498012e-05
3,446 Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing 2019 SIGMOD 7.2942885e-05
3,597 Two Birds, One Stone: A Fast, yet Lightweight, Indexing Scheme for Modern Database Systems 2017 VLDB 7.1788912e-05
3,707 Implementation of Magic-sets in a Relational Database System 1994 SIGMOD 7.0820673e-05
3,762 Dimensions Based Data Clustering and Zone Maps 2017 VLDB 7.0421949e-05
4,061 Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates 2020 SIGMOD 6.824809e-05
4,074 Apache Arrow DataFusion: A Fast, Embeddable, Modular Analytic Query Engine 2024 SIGMOD 6.8198673e-05
4,530 BigLake: BigQuery’s Evolution toward a Multi-Cloud Lakehouse 2024 SIGMOD 6.5588866e-05
4,756 Cuckoo Index: A Lightweight Secondary Index Structure 2020 VLDB 6.43221e-05
4,768 Handling Redundancy in the Processing of Recursive Database Queries 1987 SIGMOD 6.4255719e-05
5,050 On the Optimization of Recursive Relational Queries: Application to Graph Queries 2020 SIGMOD 6.2976106e-05
5,692 A Parallel Processing Strategy for Evaluating Recursive Queries 1986 VLDB 6.0355337e-05
6,309 Automating Incremental and Asynchronous Evaluation for Recursive Aggregate Data Processing 2020 SIGMOD 5.8176815e-05
6,999 Statisticum: Data Statistics Management in SAP HANA 2017 VLDB 5.6252486e-05
7,088 On the Expected Size of Recursive Datalog Queries 1991 PODS 5.6020796e-05
7,308 Optimization for iterative queries on MapReduce 2014 VLDB 5.5572894e-05
8,153 Predicate Pushdown for Data Science Pipelines 2023 SIGMOD 5.3891786e-05
8,580 Conditional Cuckoo Filters 2021 SIGMOD 5.3100462e-05
9,018 Optimizing Parallel Recursive Datalog Evaluation on Multicore Machines 2022 SIGMOD 5.2365938e-05
9,347 Optimizing Recursive Queries in SQL 2005 SIGMOD 5.1900828e-05
10,318 Out-of-order Execution of Database Queries 2020 VLDB 5.0367346e-05
10,330 Optimizing Differentially-Maintained Recursive Queries on Dynamic Graphs 2022 VLDB 5.0312167e-05
10,331 The CORAL Deductive Database System 1993 SIGMOD 5.0312167e-05
Previous Page 1 / 1 Next

Semantically Similar Papers