Skip to main navigation Skip to search Skip to main content

Learned Indexes with Distribution Smoothing via Virtual Points

  • Kasun Amarasinghe
  • , Farhana Choudhury
  • , Jianzhong Qi
  • , James Bailey

Research output: Chapter in Book/Report/Conference proceeding › Conference Paper › Research › peer-review

Abstract

Recent research on learned indexes has created a new perspective for indexes as models that map keys to their respective storage locations. These learned indexes are created to approximate the cumulative distribution function of the key set, where using only a single model may have limited accuracy. To overcome this limitation, a typical method is to use multiple models, arranged in a hierarchical manner, where the query performance depends on two aspects: (i) traversal time to find the correct model and (ii) search time to find the key in the selected model. Such a method may cause some key space regions that are difficult to model to be placed at deeper levels in the hierarchy. To address this issue, we propose an alternative method that modifies the key space as opposed to any structural or model modifications. This is achieved through making the key set more learnable (i.e., smoothing the distribution) by inserting virtual points. Furthermore, we develop an algorithm named CSV to integrate our virtual point insertion method into existing learned indexes, reducing both their traversal and search time. We implement CSV on state-of-the-art learned indexes and evaluate them on real-world datasets. Extensive experimental results show significant query performance improvement for the keys in deeper levels of the index structures at a low storage cost.

Original languageEnglish
Title of host publicationProceedings 28th International Conference on Extending Database Technology ( EDBT 2025 )
EditorsAlkis Simitsis, Bettina Kemme
Place of PublicationKonstanz Germany
PublisherOpenProceedings
Pages668-680
Number of pages13
ISBN (Electronic)9783893180981, 9783893180998
DOIs
Publication statusPublished - 2025
Externally publishedYes
EventInternational Conference on Extending Database Technology 2025 - Barcelona, Spain
Duration: 25 Mar 2025 → 28 Mar 2025
Conference number: 28th
https://edbticdt2025.upc.edu/ (Website)
https://openproceedings.org/html/pages/2025_edbt.html (Proceedings)

Publication series

NameAdvances in Database Technology - EDBT
PublisherOpenProceedings
Number3
Volume28
ISSN (Electronic)2367-2005

Conference

ConferenceInternational Conference on Extending Database Technology 2025
Abbreviated titleEDBT 2025
Country/TerritorySpain
CityBarcelona
Period25/03/25 → 28/03/25
Internet address

Cite this