HINT on Steroids

Batch Query Processing for Interval Data

Conference Paper (2024)
Author(s)

Panagiotis Bouros (University of Mainz)

Artur Titkov (University of Mainz)

George Christodoulou (TU Delft - Web Information Systems)

Christian Rauch (University of Mainz)

Nikos Mamoulis (University of Ioannina)

DOI related publication
https://doi.org/10.48786/edbt.2024.38 Final published version
More Info
expand_more
Publication Year
2024
Language
English
Pages (from-to)
440-446
ISBN (electronic)
['9783893180912', '9783893180943', '9783893180950']
Event
Downloads counter
116
Reuse Rights

Other than for strictly personal use, it is not permitted to download, forward or distribute the text or part of it, without the consent of the author(s) and/or copyright holder(s), unless the work is under an open content license such as Creative Commons.

Abstract

A wide range of applications manage interval data. HINT was recently proposed to hierarchically index intervals in main memory. The index outperforms competitive structures by a wide margin, but under its current setup, HINT is able to service only single query requests. In practice however, real systems receive a large number of queries at the same time and so, our focus in this paper is on batch query processing. We propose two novel evaluation strategies termed level-based and partition-based, which both work in a per-level fashion, i.e., all queries for an index level are computed before moving to the next level. The new strategies operate in a cache-aware fashion to reduce the cache misses caused by climbing the index hierarchy or accessing multiple partitions per level, and to decrease the total execution time for a query batch. Our experimental analysis with both real and synthetic datasets showed that our batch processing strategies always outperform a baseline that executes queries in a serial fashion, and that partition-based is overall the most efficient strategy.