A Critical Analysis of Recursive Model Indexes
Marcel Maltry, Jens Dittrich
Abstract
The recursive model index (RMI) has recently been introduced as a machine-learned replacement for traditional indexes over sorted data, achieving remarkably fast lookups. Follow-up work focused on explaining RMI's performance and automatically configuring RMIs through enumeration. Unfortunately, configuring RMIs involves setting several hyperparameters, the enumeration of which is often too time-consuming in practice. Therefore, in this work, we conduct the first inventor-independent broad analysis of RMIs with the goal of understanding the impact of each hyperparameter on performance. In particular, we show that in addition to model types and layer size, error bounds and search algorithms must be considered to achieve the best possible performance. Based on our findings, we develop a simple-to-follow guideline for configuring RMIs. We evaluate our guideline by comparing the resulting RMIs with a number of state-of-the-art indexes, both learned and traditional. We show that our simple guideline is sufficient to achieve competitive performance with other learned indexes and RMIs whose configuration was determined using an expensive enumeration procedure. In addition, while carefully reimplementing RMIs, we are able to improve the build time by 2.5x to 6.3x.
Ask about this paper
Your agent reads all of it.
Lune indexed this paper to the last equation, along with the top-tier papers that cite it. Ask a question and the answer quotes them.
Your agent calls
Luneget_paper_fulltext
Free to start. No credit card required.
Terminal
Install the CLIlune papers fulltext c36c5fa6-4923-4fb2-acfb-9733b24502a7Cited by top-tier papers4
- Learned Index: A Comprehensive Experimental EvaluationZhaoyan Sun, Xuanhe Zhou, Guoliang LiVLDB 2023 · 87 citations
- SALI: A Scalable Adaptive Learned Index Framework based on Probability ModelsJiake Ge, Huanchen Zhang, Boyu Shi, Yuanhui Luo et al.SIGMOD 2024 · 28 citations
- A Fully On-Disk Updatable Learned IndexHai Lan, Zhifeng Bao, J. Shane Culpepper, Renata Borovica-Gajic et al.ICDE 2024 · 10 citations
- Understanding Robustness Issues of Updatable Learned Indexes: [Experiments & Analysis]Yuanhui Luo, Minhui Xie, Yiheng Tong, Shichao Jiang et al.SIGMOD 2026 · 1 citation
Builds on3
- ALEX: An Updatable Adaptive Learned IndexJialin Ding, Umar Farooq Minhas, Jia Yu, Chi Wang et al.SIGMOD 2020 · 274 citations
- The PGM-index: a fully-dynamic compressed learned index with provable worst-case boundsPaolo Ferragina, Giorgio VinciguerraVLDB 2020 · 178 citations
- Why Are Learned Indexes So Effective?Paolo Ferragina, Fabrizio Lillo, Giorgio VinciguerraICML 2020 · 63 citations
Related papers
- CARMI: A Cache-Aware Learned Index with a Cost-based Construction AlgorithmJiaoyi Zhang, Yihan GaoVLDB 2022 · 42 citations
- VEGA: An Active-tuning Learned Index with Group-Wise Learning GranularityMeng Li, Huayi Chai, Siqiang Luo, Haipeng Dai et al.SIGMOD 2025 · 3 citations
- The Price of Tailoring the Index to Your Data: Poisoning Attacks on Learned Index StructuresEvgenios M. Kornaropoulos, Silei Ren, Roberto TamassiaSIGMOD 2022 · 13 citations
- The Case for Learned In-Memory JoinsIbrahim Sabek, Tim KraskaVLDB 2023 · 27 citations
- DILI: A Distribution-Driven Learned IndexPengfei Li, Hua Lu, Rong Zhu, Bolin Ding et al.VLDB 2023 · 37 citations
