DBScholar

Back to papers

Eliminating Redundant Feature Tests in Decision Tree and Random Forest Inference on SQL Predicates

Summary: ReTree eliminates redundant decision-tree feature tests when ML inference appears in SQL predicates, targeting sibling- and ancestor-induced redundancy. Its subtree collapse and recombination techniques, implemented in DuckDB, deliver 2.56× average speedup. (summarized by gpt-5.6-luna on Jul 26 2026)

Paper ID
7421
Venue
SIGMOD
Year
2026
Pagerank
5.093636e-05
Overall Rank
10,230 | 29.82%
DOI
10.1145/3802048

Incoming Non-self Citations Over Time

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

Authors

BibTeX Citation

@inproceedings{liu_sigmod26,
        title = {{Eliminating Redundant Feature Tests in Decision Tree and Random Forest Inference on SQL Predicates}},
        author = {Liu, Mingxi and Ding, Zhengyuan and Zhang, Chenyang and Pan, Qingfeng and Su, Huayou and Zhang, Zhao and Xu, Chen and Ruan, Qingsong},
        series = {{SIGMOD} '26},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3802048},
        url = {https://dl.acm.org/doi/10.1145/3802048},
        year = {2026}
}

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 22 of 22 cited papers.

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

Rank Cited Paper Year Venue Pagerank
103 DuckDB: an Embeddable Analytical Database 2019 SIGMOD 0.00034161428
106 The MADlib Analytics Library or MAD Skills, the SQL 2012 VLDB 0.00033539462
295 Accelerating Machine Learning Inference with Probabilistic Predicates 2018 SIGMOD 0.00022238183
764 To Join or Not to Join? Thinking Twice about Joins before Feature Selection 2016 SIGMOD 0.00014226652
1,948 Greenplum: A Hybrid Database for Transactional and Analytical Workloads 2021 SIGMOD 9.432395e-05
2,293 Extending Relational Query Processing with ML Inference 2020 CIDR 8.7949378e-05
2,865 End-to-end Optimization of Machine Learning Prediction Queries 2022 SIGMOD 8.0180243e-05
2,918 OceanBase: A 707 Million tpmC Distributed Relational Database System 2022 VLDB 7.9649716e-05
2,933 EVA: A Symbolic Approach to Accelerating Exploratory Video Analytics with Materialized Views 2022 SIGMOD 7.9474026e-05
3,203 TitAnt: Online Real-time Transaction Fraud Detection in Ant Financial 2019 VLDB 7.6402128e-05
3,874 Tensors: An abstraction for general data processing 2021 VLDB 7.0561161e-05
4,114 Optimizing Machine Learning Inference Queries with Correlative Proxy Models 2022 VLDB 6.8941194e-05
4,375 FiGO: Fine-Grained Query Optimization in Video Analytics 2022 SIGMOD 6.7369552e-05
5,040 TPCx-AI - An Industry Standard Benchmark for Artificial Intelligence and Machine Learning Systems 2023 VLDB 6.390395e-05
5,456 InferDB: In-Database Machine Learning Inference Using Indexes 2024 VLDB 6.2131252e-05
5,706 SmartLite: A DBMS-based Serving System for DNN Inference in Resource-constrained Environments 2024 VLDB 6.1144255e-05
6,585 JoinBoost: Grow Trees Over Normalized Data Using Only SQL 2023 VLDB 5.8350362e-05
6,614 Mitigating the Impedance Mismatch between Prediction Query Execution and Database Engine 2025 SIGMOD 5.8216658e-05
6,921 Rethinking Learned Cost Models: Why Start from Scratch? 2023 SIGMOD 5.7388557e-05
7,381 DeltaBoost: Gradient Boosting Decision Trees with Efficient Machine Unlearning 2023 SIGMOD 5.6288368e-05
9,530 OceanBase Paetica: A Hybrid Shared-nothing/Shared-everything Database for Supporting Single Machine and Distributed Cluster 2023 VLDB 5.2543048e-05
9,874 Fast Search-By-Classification for Large-Scale Databases Using Index-Aware Decision Trees and Random Forests 2023 VLDB 5.2043672e-05
Previous Page 1 / 1 Next

Semantically Similar Papers