paper-with-me

Papers

Learned Indexes for Dynamic Workloads

2019-02-02 · Chuzhe Tang, Zhiyuan Dong, Minjie Wang, Zhaoguo Wang, Haibo Chen

The recent proposal of learned index structures opens up a new perspective on how traditional range indexes can be optimized. However, the current learned indexes assume the data distribution is relatively static and the access pattern is uniform, while real-world scenarios consist of skew query distribution and evolving data. In this paper, we demonstrate that the missing consideration of access patterns and dynamic data distribution notably hinders the applicability of learned indexes. To this end, we propose solutions for learned indexes for dynamic workloads (called Doraemon). To improve the latency for skew queries, Doraemon augments the training data with access frequencies. To address the slow model re-training when data distribution shifts, Doraemon caches the previously-trained models and incrementally fine-tunes them for similar access patterns and data distribution. Our preliminary result shows that, Doraemon improves the query latency by 45.1% and reduces the model re-training time to 1/20.

📄 PDF Abstract BibTeX arXiv:1902.00655

Code (0)

등록된 구현이 없습니다.

Similar Papers 제목 키워드 기반

ALEX: An Updatable Adaptive Learned Index

2019-05-21 · Jialin Ding, Umar Farooq Minhas, JIA YU, Chi Wang 외

Recent work on "learned indexes" has changed the way we look at the decades-old field of DBMS indexing. The key idea is that indexes can be thought of as "models" that predict the position of a key in a dataset. Indexes …

Micro-architectural Analysis of a Learned Index

2021-09-17 · Mikkel Møller Andersen, Pınar Tözün

Since the publication of The Case for Learned Index Structures in 2018, there has been a rise in research that focuses on learned indexes for different domains and with different functionalities. While the effectiveness …

Tsunami: A Learned Multi-dimensional Index for Correlated Data and Skewed Workloads

2020-06-23 · Jialin Ding, Vikram Nathan, Mohammad Alizadeh, Tim Kraska

Filtering data based on predicates is one of the most fundamental operations for any modern data warehouse. Techniques to accelerate the execution of filter expressions include clustered indexes, specialized sort orders …

Sig2Model: A Boosting-Driven Model for Updatable Learned Indexes

2025-09-25 · Alireza Heidari, Amirhossein Ahmad, Wei Zhang, Ying Xiong arxiv

Learned Indexes (LIs) represent a paradigm shift from traditional index structures by employing machine learning models to approximate the cumulative distribution function (CDF) of sorted data. While LIs achieve remarkab…

A New Paradigm in Tuning Learned Indexes: A Reinforcement Learning Enhanced Approach

2025-02-07 · Taiyi Wang, Liang Liang, Guang Yang, Thomas Heinis 외

Learned Index Structures (LIS) have significantly advanced data management by leveraging machine learning models to optimize data indexing. However, designing these structures often involves critical trade-offs, making i…

Deep Reinforcement Learning