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
7159
Venue
SIGMOD
Year
2025
Pagerank
5.093636e-05
Overall Rank
10,690 | 26.66%
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
16 MAGIC SETS AND OTHER STRANGE WAYS TO IMPLEMENT LOGIC PROGRAMS (Extended Abstract) 1986 PODS 0.00060089598
30 SCOPE: Easy and Efficient Parallel Processing of Massive Data Sets 2008 VLDB 0.00051174276
63 An Amateur's Introduction to Recursive Query Processing Strategies 1986 SIGMOD 0.00038782376
227 Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing 1998 VLDB 0.00023958508
330 Impala: A Modern, Open-Source SQL Engine for Hadoop 2015 CIDR 0.0002104801
342 R* Optimizer Validation and Performance Evaluation for Distributed Queries 1986 VLDB 0.00020673706
344 On the Power of Magic 1987 PODS 0.00020659405
425 Shark: SQL and Rich Analytics at Scale 2013 SIGMOD 0.00018704491
451 Mergeable Summaries 2012 PODS 0.00018151445
761 Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS 2007 VLDB 0.00014254351
818 Amazon Redshift Re-invented 2022 SIGMOD 0.00013822916
941 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00013078348
1,037 Cost-Based Optimization for Magic: Algebra and Implementation 1996 SIGMOD 0.00012494928
1,044 Fine-grained Partitioning for Aggressive Data Skipping 2014 SIGMOD 0.0001244236
1,114 Direct Algorithms for Computing the Transitive Closure of Database Relations 1987 VLDB 0.00012118382
1,788 Decidability and Undecidability Results for Boundedness of Linear Recursive Queries 1988 PODS 9.7653696e-05
1,791 Cheetah: A High Performance, Custom Data Warehouse on Top of MapReduce 2010 VLDB 9.7470504e-05
1,893 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.5269935e-05
1,925 POLARIS: The Distributed SQL Engine in Azure Synapse 2020 VLDB 9.4764398e-05
1,979 Scalable Join Processing on Very Large RDF Graphs 2009 SIGMOD 9.3621296e-05
2,156 Quickstep: A Data Platform Based on the Scaling-Up Approach 2018 VLDB 9.0635624e-05
2,594 Big Data Analytics with Datalog Queries on Spark 2016 SIGMOD 8.3646367e-05
3,106 Skipping-oriented Partitioning for Columnar Layouts 2017 VLDB 7.7515666e-05
3,137 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.7204167e-05
3,257 One WITH RECURSIVE is Worth Many GOTOs 2021 SIGMOD 7.590651e-05
3,555 Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing 2019 SIGMOD 7.3115321e-05
3,576 Two Birds, One Stone: A Fast, yet Lightweight, Indexing Scheme for Modern Database Systems 2017 VLDB 7.2936598e-05
3,650 Implementation of Magic-sets in a Relational Database System 1994 SIGMOD 7.2249961e-05
3,992 Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates 2020 SIGMOD 6.9695338e-05
4,329 Dimensions Based Data Clustering and Zone Maps 2017 VLDB 6.75682e-05
4,649 BigLake: BigQuery’s Evolution toward a Multi-Cloud Lakehouse 2024 SIGMOD 6.586622e-05
4,673 Handling Redundancy in the Processing of Recursive Database Queries 1987 SIGMOD 6.573022e-05
4,782 Cuckoo Index: A Lightweight Secondary Index Structure 2020 VLDB 6.5115802e-05
4,972 On the Optimization of Recursive Relational Queries: Application to Graph Queries 2020 SIGMOD 6.4193234e-05
5,469 Apache Arrow DataFusion: A Fast, Embeddable, Modular Analytic Query Engine 2024 SIGMOD 6.2073056e-05
5,563 A Parallel Processing Strategy for Evaluating Recursive Queries 1986 VLDB 6.1716947e-05
6,203 Automating Incremental and Asynchronous Evaluation for Recursive Aggregate Data Processing 2020 SIGMOD 5.9447217e-05
6,907 Statisticum: Data Statistics Management in SAP HANA 2017 VLDB 5.7417459e-05
6,948 On the Expected Size of Recursive Datalog Queries 1991 PODS 5.7306589e-05
7,168 Optimization for iterative queries on MapReduce 2014 VLDB 5.6841364e-05
8,413 Conditional Cuckoo Filters 2021 SIGMOD 5.4306049e-05
8,465 Predicate Pushdown for Data Science Pipelines 2023 SIGMOD 5.4194578e-05
8,858 Optimizing Parallel Recursive Datalog Evaluation on Multicore Machines 2022 SIGMOD 5.3567857e-05
9,173 Optimizing Recursive Queries in SQL 2005 SIGMOD 5.3090815e-05
10,096 Out-of-order Execution of Database Queries 2020 VLDB 5.1523392e-05
10,103 Optimizing Differentially-Maintained Recursive Queries on Dynamic Graphs 2022 VLDB 5.1466947e-05
10,104 The CORAL Deductive Database System 1993 SIGMOD 5.1466947e-05
Previous Page 1 / 1 Next

Semantically Similar Papers