HINT on Steroids

Batch Query Processing for Interval Data

Conference Paper (2024)
Author(s)

Panagiotis Bouros (University of Mainz)

Artur Titkov (University of Mainz)

G.C. Christodoulou (TU Delft - Web Information Systems)

Christian Rauch (University of Mainz)

Nikos Mamoulis (University of Ioannina)

Research Group
Web Information Systems
DOI related publication
https://doi.org/10.48786/edbt.2024.38
More Info
expand_more
Publication Year
2024
Language
English
Research Group
Web Information Systems
Pages (from-to)
440-446
ISBN (electronic)
['9783893180912', '9783893180943', '9783893180950']
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.