DBScholar

Back to papers

Debunking the Myth of Join Ordering: Toward Robust SQL Analytics

Summary: Robust Predicate Transfer (RPT) for acyclic joins; introduces LargestRoot and SafeSubjoin to achieve provable robustness to arbitrary join orders. Implemented in DuckDB; evaluated on TPC-H/JOB/TPC-DS/DSB, delivering up to 1.6x robustness improvement and ~1.5x end-to-end speedup. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
7278
Venue
SIGMOD
Year
2025
Pagerank
6.18591e-05
Overall Rank
5,529 | 62.07%
DOI
10.1145/3725283

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{zhao_sigmod25,
        title = {{Debunking the Myth of Join Ordering: Toward Robust SQL Analytics}},
        author = {Zhao, Junyi and Su, Kai and Yang, Yifei and Yu, Xiangyao and Koutris, Paraschos and Zhang, Huanchen},
        series = {{SIGMOD} '25},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3725283},
        url = {https://dl.acm.org/doi/10.1145/3725283},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 12 of 12 citing papers.

Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 1 of 51 cited papers.

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

Rank Cited Paper Year Venue Pagerank
10,662 Data Chunk Compaction in Vectorized Execution 2025 SIGMOD 5.093636e-05
Previous Page 2 / 2 Next

Semantically Similar Papers