Learned index structures have been shown to achieve favorable lookup performance and space consumption compared to their traditional counterparts such as B-trees. However, most learned index studies have focused on the primary indexing setting, where the base data is sorted. In this work, we investigate whether learned indexes sustain their advantage in the secondary indexing setting. We introduce Learned Secondary Index (LSI), a first attempt to use learned indexes for indexing unsorted data. LSI works by building a learned index over a permutation vector, which allows binary search to performed on the unsorted base data using random access. We additionally augment LSI with a fingerprint vector to accelerate equality lookups. We show that LSI achieves comparable lookup performance to state-of-the-art secondary indexes while being up to 6x more space efficient.
arXiv Fulltext PDF:/Users/le/Zotero/storage/GBJXJMFG/Kipf et al. - 2022 - LSI A Learned Secondary Index Structure.pdf:application/pdf;arXiv.org Snapshot:/Users/le/Zotero/storage/LS6YMZ59/2205.html:text/html
%0 Report
%1 kipf_lsi_2022
%A Kipf, Andreas
%A Horn, Dominik
%A Pfeil, Pascal
%A Marcus, Ryan
%A Kraska, Tim
%D 2022
%K latent_semantic_indexing
%N arXiv:2205.05769
%R 10.48550/arXiv.2205.05769
%T LSI : a learned secondary index structure
%U http://arxiv.org/abs/2205.05769
%X Learned index structures have been shown to achieve favorable lookup performance and space consumption compared to their traditional counterparts such as B-trees. However, most learned index studies have focused on the primary indexing setting, where the base data is sorted. In this work, we investigate whether learned indexes sustain their advantage in the secondary indexing setting. We introduce Learned Secondary Index (LSI), a first attempt to use learned indexes for indexing unsorted data. LSI works by building a learned index over a permutation vector, which allows binary search to performed on the unsorted base data using random access. We additionally augment LSI with a fingerprint vector to accelerate equality lookups. We show that LSI achieves comparable lookup performance to state-of-the-art secondary indexes while being up to 6x more space efficient.
@techreport{kipf_lsi_2022,
abstract = {Learned index structures have been shown to achieve favorable lookup performance and space consumption compared to their traditional counterparts such as B-trees. However, most learned index studies have focused on the primary indexing setting, where the base data is sorted. In this work, we investigate whether learned indexes sustain their advantage in the secondary indexing setting. We introduce Learned Secondary Index (LSI), a first attempt to use learned indexes for indexing unsorted data. LSI works by building a learned index over a permutation vector, which allows binary search to performed on the unsorted base data using random access. We additionally augment LSI with a fingerprint vector to accelerate equality lookups. We show that LSI achieves comparable lookup performance to state-of-the-art secondary indexes while being up to 6x more space efficient.},
added-at = {2022-05-27T13:34:28.000+0200},
author = {Kipf, Andreas and Horn, Dominik and Pfeil, Pascal and Marcus, Ryan and Kraska, Tim},
biburl = {https://www.bibsonomy.org/bibtex/27970ba2aad471c86788d381878c18463/lepsky},
doi = {10.48550/arXiv.2205.05769},
file = {arXiv Fulltext PDF:/Users/le/Zotero/storage/GBJXJMFG/Kipf et al. - 2022 - LSI A Learned Secondary Index Structure.pdf:application/pdf;arXiv.org Snapshot:/Users/le/Zotero/storage/LS6YMZ59/2205.html:text/html},
institution = {arXiv},
interhash = {5ece7801ef4559837b746fb044c02b90},
intrahash = {7970ba2aad471c86788d381878c18463},
keywords = {latent_semantic_indexing},
month = may,
note = {arXiv:2205.05769 [cs]type: article},
number = {arXiv:2205.05769},
shorttitle = {{LSI}},
timestamp = {2022-06-13T17:34:08.000+0200},
title = {{LSI} : a learned secondary index structure},
url = {http://arxiv.org/abs/2205.05769},
urldate = {2022-05-16},
year = 2022
}