SeLeP: Learning Based Semantic Prefetching for Exploratory Database Workloads

Summary: SeLeP: semantic prefetching for exploratory SQL by encoding block values and framing prefetching as a time-series forecasting problem. An encoder–decoder LSTM learns semantic (not address) access patterns, improving hit ratio up to 40% and cutting I/O ~45% (96% hit, 84% I/O reduction avg). (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 13627
Venue: VLDB
Year: 2024
Pagerank: 5.093636e-05
Overall Rank: 11,232 | 22.94%
DOI: 10.14778/3659437.3659458

Incoming Non-self Citations Over Time

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

Authors

1. Farzaneh Zirak (University of Melbourne)
2. Farhana Choudhury (University of Melbourne)
3. Renata Borovica-Gajic (University of Melbourne)

BibTeX Citation

@article{zirak_vldb24,
        title = {{SeLeP: Learning Based Semantic Prefetching for Exploratory Database Workloads}},
        author = {Zirak, Farzaneh and Choudhury, Farhana and Borovica-Gajic, Renata},
        journal = {PVLDB},
        series = {{VLDB} '24},
        volume = {17},
        number = {8},
        pages = {2064--2076},
        doi = {10.14778/3659437.3659458},
        url = {https://doi.org/10.14778/3659437.3659458},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
21	Similarity Search in High Dimensions via Hashing	1999	VLDB	0.00056760516
34	The Design Of Postgres	1986	SIGMOD	0.00049302774
1,070	NoDB: Efficient Query Execution on Raw Data Files	2012	SIGMOD	0.0001232307
1,198	Overview of Data Exploration Techniques	2015	SIGMOD	0.00011706307
1,585	Dynamic Prefetching of Data Tiles for Interactive Visualization	2016	SIGMOD	0.00010288399
1,924	The Researcher's Guide to the Data Deluge: Querying a Scientific Database in Just a Few Seconds	2011	VLDB	9.4775501e-05
2,363	Clay: Fine-Grained Adaptive Partitioning for General Database Schemas	2017	VLDB	8.6873235e-05
2,592	SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment	2016	SIGMOD	8.3657526e-05
3,144	Interactive Data Exploration Using Semantic Windows	2014	SIGMOD	7.7134729e-05
3,413	Slalom: Coasting Through Raw Data via Adaptive Partitioning and Indexing	2017	VLDB	7.4326381e-05
5,423	Updatable Learned Indexes Meet Disk-Resident DBMS - From Evaluations to Design Choices	2023	SIGMOD	6.2242567e-05
5,558	HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning	2023	VLDB	6.1749098e-05
5,679	SCOUT: Prefetching for Latent Structure Following Queries	2012	VLDB	6.1240538e-05
6,684	CrocodileDB: Efficient Database Execution through Intelligent Deferment	2020	CIDR	5.8036476e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	13,314	SemExplorer: A User Interface for Semantic Approach to Customized Dataset Search	2025	SIGMOD
2	697	Selectivity Estimation for Range Predicates using Lightweight Models	2019	VLDB
3	5,132	Facilitating SQL Query Composition and Analysis	2020	SIGMOD
4	9,215	Deep Query Optimization	2019	SIGMOD
5	563	Plan-Structured Deep Neural Network Models for Query Performance Prediction	2019	VLDB
6	4,420	Optimization for Active Learning-based Interactive Database Exploration	2019	VLDB
7	5,073	Database Workload Characterization with Query Plan Encoders	2022	VLDB
8	4,671	PreQR: Pre-training Representation for SQL Understanding	2022	SIGMOD
9	1,573	Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries	2020	SIGMOD
10	6,273	Optimization of Query Streams Using Semantic Prefetching	2004	SIGMOD