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: 13500
Venue: VLDB
Year: 2023
Pagerank: 6.2149491e-05
Overall Rank: 5,447 | 62.63%
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,792	Learned Index: A Comprehensive Experimental Evaluation	2023	VLDB	7.1220982e-05
6,687	Making In-Memory Learned Indexes Efficient on Disk	2024	SIGMOD	5.8022308e-05
6,874	SALI: A Scalable Adaptive Learned Index Framework based on Probability Models	2023	SIGMOD	5.7489487e-05
7,368	Accelerating String-key Learned Index Structures via Memoization-based Incremental Training	2024	VLDB	5.6315363e-05
8,039	Algorithmic Complexity Attacks on Dynamic Learned Indexes	2024	VLDB	5.5021992e-05
9,411	Can Learned Indexes be Built Efficiently? A Deep Dive into Sampling Trade-offs	2024	SIGMOD	5.274743e-05
9,599	Understanding Robustness Issues of Updatable Learned Indexes: [Experiments & Analysis]	2026	SIGMOD	5.2492748e-05
10,262	LINE: A Learned Index with Group-Enhanced Leaves and Cache-Optimized Inner Tree	2026	SIGMOD	5.093636e-05
10,272	NeurBench: A Benchmark Suite for Learned Database Components with Drift Modeling: [Experiments & Analysis]	2026	SIGMOD	5.093636e-05
10,378	High Performance or Low Memory? An Updatable Learned Index Framework for Time-Space Tradeoff	2026	SIGMOD	5.093636e-05
10,682	VEGA: An Active-tuning Learned Index with Group-Wise Learning Granularity	2025	SIGMOD	5.093636e-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
43	The Case for Learned Index Structures	2018	SIGMOD	0.00046060254
271	TiDB: A Raft-based HTAP Database	2020	VLDB	0.00022703024
323	DeepDB: Learn from Data, not from Queries!	2020	VLDB	0.00021264788
447	ALEX: An Updatable Adaptive Learned Index	2020	SIGMOD	0.00018322593
477	The PGM-index: a fully-dynamic compressed learned index with provable worst-case bounds	2020	VLDB	0.00017851226
655	ERMIA: Fast Memory-Optimized Database System for Heterogeneous Workloads	2016	SIGMOD	0.00015263509
720	Anti-Caching: A New Approach to Database Management System Architecture	2013	VLDB	0.00014632914
790	FITing-Tree: A Data-aware Index Structure	2019	SIGMOD	0.0001401445
847	Benchmarking Learned Indexes	2021	VLDB	0.0001365768
873	Learning Multi-dimensional Indexes	2020	SIGMOD	0.00013481915
941	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD	0.00013078348
964	Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes	2016	SIGMOD	0.00012934147
1,312	Hybrid Transactional/Analytical Processing: A Survey	2017	SIGMOD	0.00011193166
1,418	LISA: A Learned Index Structure for Spatial Data	2020	SIGMOD	0.00010835539
1,492	BF-Tree: Approximate Tree Indexing	2014	VLDB	0.00010588267
1,524	Trekking Through Siberia: Managing Cold Data in a Memory-Optimized Database	2014	VLDB	0.00010501517
1,551	Updatable Learned Index with Precise Positions	2021	VLDB	0.00010381398
1,840	Effectively Learning Spatial Indices	2020	VLDB	9.6404567e-05
2,233	FINEdex: A Fine-grained Learned Index Scheme for Scalable and Concurrent Memory Systems	2022	VLDB	8.8968964e-05
2,922	Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads	2017	VLDB	7.9593579e-05
2,972	F1 Lightning: HTAP as a Service	2020	VLDB	7.9114157e-05
6,734	Liquid: Unifying Nearline and Offline Big Data Integration	2015	CIDR	5.7879923e-05

Semantically Similar Papers

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