FILM: a Fully Learned Index for Larger-than-Memory Databases

Summary: FILM: a fully learned tree index for larger-than-memory DBs using tiny approximation models to index across memory+disk, reducing in-memory index size by orders of magnitude versus anti-caching. An adaptive LRU piggybacked on queries avoids swap overhead, improving query latency and insertion performance. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: h97b8cc3266aedc7d
Venue: VLDB
Year: 2023
Pagerank: 6.080267e-05
Overall Rank: 5,571 | 62.55%
DOI: 10.14778/3570690.3570704

Incoming Non-self Citations Over Time

Authors

1. Chaohong Ma (Renmin University of China)
2. Xiaohui Yu (York University)
3. Yifan Li (York University)
4. Xiaofeng Meng (Renmin University of China)
5. Aishan Maoliniyazi (Renmin University of China)

BibTeX Citation

@article{ma_vldb23,
        title = {{FILM: a Fully Learned Index for Larger-than-Memory Databases}},
        author = {Ma, Chaohong and Yu, Xiaohui and Li, Yifan and Meng, Xiaofeng and Maoliniyazi, Aishan},
        journal = {PVLDB},
        series = {{VLDB} '23},
        volume = {16},
        number = {3},
        pages = {561--573},
        doi = {10.14778/3570690.3570704},
        url = {https://doi.org/10.14778/3570690.3570704},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 11 of 11 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,697	Learned Index: A Comprehensive Experimental Evaluation	2023	VLDB	7.0882335e-05
6,821	Making In-Memory Learned Indexes Efficient on Disk	2024	SIGMOD	5.6720444e-05
6,863	Accelerating String-key Learned Index Structures via Memoization-based Incremental Training	2024	VLDB	5.6607844e-05
7,018	SALI: A Scalable Adaptive Learned Index Framework based on Probability Models	2023	SIGMOD	5.619958e-05
8,200	Algorithmic Complexity Attacks on Dynamic Learned Indexes	2024	VLDB	5.3787447e-05
9,593	Can Learned Indexes be Built Efficiently? A Deep Dive into Sampling Trade-offs	2024	SIGMOD	5.156392e-05
9,777	Understanding Robustness Issues of Updatable Learned Indexes: [Experiments & Analysis]	2026	SIGMOD	5.1314952e-05
10,475	LINE: A Learned Index with Group-Enhanced Leaves and Cache-Optimized Inner Tree	2026	SIGMOD	4.9793485e-05
10,484	NeurBench: A Benchmark Suite for Learned Database Components with Drift Modeling: [Experiments & Analysis]	2026	SIGMOD	4.9793485e-05
10,575	High Performance or Low Memory? An Updatable Learned Index Framework for Time-Space Tradeoff	2026	SIGMOD	4.9793485e-05
11,122	VEGA: An Active-tuning Learned Index with Group-Wise Learning Granularity	2025	SIGMOD	4.9793485e-05

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
40	The Case for Learned Index Structures	2018	SIGMOD	0.00046284649
234	TiDB: A Raft-based HTAP Database	2020	VLDB	0.00023765806
318	DeepDB: Learn from Data, not from Queries!	2020	VLDB	0.00021167555
430	ALEX: An Updatable Adaptive Learned Index	2020	SIGMOD	0.00018409112
463	The PGM-index: a fully-dynamic compressed learned index with provable worst-case bounds	2020	VLDB	0.00017804544
636	ERMIA: Fast Memory-Optimized Database System for Heterogeneous Workloads	2016	SIGMOD	0.00015360975
728	Anti-Caching: A New Approach to Database Management System Architecture	2013	VLDB	0.00014414001
779	FITing-Tree: A Data-aware Index Structure	2019	SIGMOD	0.00014030069
848	Benchmarking Learned Indexes	2021	VLDB	0.00013506188
868	Learning Multi-dimensional Indexes	2020	SIGMOD	0.00013354403
906	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD	0.00013160654
971	Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes	2016	SIGMOD	0.00012766019
1,321	Hybrid Transactional/Analytical Processing: A Survey	2017	SIGMOD	0.00011040617
1,446	LISA: A Learned Index Structure for Spatial Data	2020	SIGMOD	0.00010629222
1,510	BF-Tree: Approximate Tree Indexing	2014	VLDB	0.00010438563
1,524	Trekking Through Siberia: Managing Cold Data in a Memory-Optimized Database	2014	VLDB	0.00010356318
1,550	Updatable Learned Index with Precise Positions	2021	VLDB	0.00010282449
1,878	Effectively Learning Spatial Indices	2020	VLDB	9.4451309e-05
2,277	FINEdex: A Fine-grained Learned Index Scheme for Scalable and Concurrent Memory Systems	2022	VLDB	8.7075835e-05
2,922	Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads	2017	VLDB	7.8519075e-05
2,997	F1 Lightning: HTAP as a Service	2020	VLDB	7.7689996e-05
6,819	Liquid: Unifying Nearline and Offline Big Data Integration	2015	CIDR	5.672617e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,636	Are Updatable Learned Indexes Ready?	2022	VLDB
2	6,863	Accelerating String-key Learned Index Structures via Memoization-based Incremental Training	2024	VLDB
3	779	FITing-Tree: A Data-aware Index Structure	2019	SIGMOD
4	10,575	High Performance or Low Memory? An Updatable Learned Index Framework for Time-Space Tradeoff	2026	SIGMOD
5	1,624	An Efficient Indexing Technique for Full-Text Database Systems	1992	VLDB
6	868	Learning Multi-dimensional Indexes	2020	SIGMOD
7	6,821	Making In-Memory Learned Indexes Efficient on Disk	2024	SIGMOD
8	8,378	Tuning Hierarchical Learned Indexes on Disk and Beyond	2022	SIGMOD
9	848	Benchmarking Learned Indexes	2021	VLDB
10	3,697	Learned Index: A Comprehensive Experimental Evaluation	2023	VLDB