We introduce the RadixStringSpline (RSS) learned index structure for efficiently indexing strings. RSS is a tree of radix splines each indexing a fixed number of bytes. RSS approaches or exceeds the performance of traditional string indexes while using 7-70× less memory. RSS achieves this by using the minimal string prefix to sufficiently distinguish the data unlike most learned approaches which index the entire string. Additionally, the bounded-error nature of RSS accelerates the last mile search and also enables a memory-efficient hash-table lookup accelerator. We benchmark RSS on several real-world string datasets against ART and HOT. Our experiments suggest this line of research may be promising for future memory-intensive database applications.
@article{arxiv.2111.14905,
title = {Bounding the Last Mile: Efficient Learned String Indexing},
author = {Benjamin Spector and Andreas Kipf and Kapil Vaidya and Chi Wang and Umar Farooq Minhas and Tim Kraska},
journal= {arXiv preprint arXiv:2111.14905},
year = {2021}
}
Comments
3rd International Workshop on Applied AI for Database Systems and Applications (AIDB'21), August 20, 2021, Copenhagen, Denmark