FINEdex: A Fine-grained Learned Index Scheme for Scalable and Concurrent Memory Systems
Pengfei Li, Yu Hua, Jingnan Jia, Pengfei Zuo
Abstract
Index structures in memory systems become important to improve the entire system performance. The promising learned indexes leverage deep-learning models to complement existing index structures and obtain significant performance improvements. Existing schemes rely on a delta-buffer to support the scalability, which however incurs high overheads when a large number of data are inserted, due to the needs of checking both learned indexes and extra delta-buffer. The practical system performance also decreases since the shared delta-buffer quickly becomes large and requires frequent retraining due to high data dependency. To address the problems of limited scalability and frequent retraining, we propose a FINE-grained learned index scheme with high scalability, called FINEdex, which constructs independent models with a flattened data structure (i.e., the data arrays with low data dependency) under the trained data array to concurrently process the requests with low overheads. By further efficiently exploring and exploiting the characteristics of the workloads, FINEdex processes the new requests in-place with the support of non-blocking retraining, hence adapting to the new distributions without blocking the systems. We evaluate FINEdex via YCSB and real-world datasets, and extensive experimental results demonstrate that FINEdex improves the performance respectively by up to 1.8× and 2.5× than state-of-the-art XIndex and Masstree. We have released the open-source codes of FINEdex for public use in GitHub.
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 31297f1b-abdc-4383-81eb-2c3a008ecaafCited by top-tier papers28
- Learned Index: A Comprehensive Experimental EvaluationZhaoyan Sun, Xuanhe Zhou, Guoliang LiVLDB 2023 · 87 citations
- Are Updatable Learned Indexes Ready?Chaichon Wongkham, Baotong Lu, Chris Liu, Zhicong Zhong et al.VLDB 2022 · 66 citations
- PLIN: A Persistent Learned Index for Non-Volatile Memory with High Performance and Instant RecoveryZhou Zhang, Zhaole Chu, Peiquan Jin, Yongping Luo et al.VLDB 2023 · 39 citations
- DILI: A Distribution-Driven Learned IndexPengfei Li, Hua Lu, Rong Zhu, Bolin Ding et al.VLDB 2023 · 37 citations
- FILM: a Fully Learned Index for Larger-than-Memory DatabasesChaohong Ma, Xiaohui Yu, Yifan Li, Xiaofeng Meng et al.VLDB 2023 · 33 citations
Builds on12
- ALEX: An Updatable Adaptive Learned IndexJialin Ding, Umar Farooq Minhas, Jia Yu, Chi Wang et al.SIGMOD 2020 · 274 citations
- Benchmarking Learned IndexesRyan Marcus, Andreas Kipf, Alexander van Renen, Mihail Stoian et al.VLDB 2021 · 185 citations
- Tsunami: A Learned Multi-dimensional Index for Correlated Data and Skewed WorkloadsJialin Ding, Vikram Nathan, Mohammad Alizadeh, Tim KraskaVLDB 2021 · 178 citations
- The PGM-index: a fully-dynamic compressed learned index with provable worst-case boundsPaolo Ferragina, Giorgio VinciguerraVLDB 2020 · 178 citations
- LISA: A Learned Index Structure for Spatial DataPengfei Li, Hua Lu, Qian Zheng, Long Yang et al.SIGMOD 2020 · 158 citations
Related papers
- ALT-Index: A Hybrid Learned Index for Concurrent Memory Database SystemsYuxin Yang, Fang Wang, Mengya Lei, Peng Zhang et al.ICDE 2025
- XIndex: a scalable learned index for multicore data storageChuzhe Tang, Youyun Wang, Zhiyuan Dong, Gansen Hu et al.PPoPP 2020 · 109 citations
- On Self-Designing Learned IndexesBaofu Han, Guoyu Hu, Bing Li, Xiaokui Xiao et al.SIGMOD 2026
- LOFT: A Lock-free and Adaptive Learned Index with High Scalability for Dynamic WorkloadsYuxuan Mo, Yu HuaEuroSys 2025 · 1 citation
- Hyper: A High-Performance and Memory-Efficient Learned Index via Hybrid ConstructionShunkang Zhang, Ji Qi, Xin Yao, André BrinkmannSIGMOD 2024 · 12 citations
