approved
The PGM-index a fully-dynamic compressed learned index with provable worst-case bounds

We present the first learned index that supports predecessor, range queries and updates within provably efficient time and space bounds in the worst case. In the (static) context of just predecessor and range queries these bounds turn out to be optimal. We call this learned index the Piecewise Geometric Model index (PGM-index). Its flexible design allows us to introduce three variants which are novel in the context of learned data structures. The first variant of the PGM-index is able to adapt itself to the distribution of the query operations, thus resulting in the first known distribution-aware learned index to date. The second variant exploits the repetitiveness possibly present at the level of the learned models that compose the PGM-index to further compress its succinct space footprint. The third one is a multicriteria variant of the PGM-index that efficiently auto-tunes itself in a few seconds over hundreds of millions of keys to satisfy space-time constraints which evolve over time across users, devices and applications. These theoretical achievements are supported by a large set of experimental results on known datasets which show that the fully-dynamic PGM-index improves the space occupancy of existing traditional and learned indexes by up to three orders of magnitude, while still achieving their same or even better query and update time efficiency. As an example, in the static setting of predecessor and range queries, the PGM-index matches the query performance of a cache-optimised static B+ tree within two orders of magnitude (83×) less space; whereas in the fully-dynamic setting, where insertions and deletions are allowed, the PGM-index improves the query and update time performance of a B+ tree by up to 71% within three orders of magnitude (1140×) less space.

Tags
Data and Resources
To access the resources you must log in
  • link to publicationPDF

    The resource: 'link to publication' is not accessible as guest user. You must login to access it!
Additional Info
Field Value
Creator Ferragina, Paolo, paolo.ferragina@unipi.it
Creator Vinciguerra, Giorgio, giorgio.vinciguerra@phd.unipi.it
DOI https://dl.acm.org/doi/10.14778/3389133.3389135
Group Social Impact of AI and explainable ML
Publisher ACM Digital Library
Source Proceedings of the VLDB Endowment, April 2020
Thematic Cluster Text and Social Media Mining [TSMM]
link http://www.vldb.org/pvldb/vol13/p1162-ferragina.pdf
system:type JournalArticle
Management Info
Field Value
Author Wright Joanna
Maintainer Ferragina Paolo
Version 1
Last Updated 8 September 2023, 18:22 (CEST)
Created 3 February 2021, 12:07 (CET)