Reverse spatial top-k keyword queries

• Published in: The VLDB journal Vol. 32; no. 3; pp. 501 - 524
• Main Authors: Ahmed, Pritom, Eldawy, Ahmed, Hristidis, Vagelis, Tsotras, Vassilis J.
• Format: Journal Article
• Language: English
• Published: Berlin/Heidelberg Springer Berlin Heidelberg 01-05-2023; Springer Nature B.V
• Subjects: Algorithms; Computer Science; Database Management; Datasets; Neighborhoods; Performance enhancement; Performance evaluation; Queries; Regular Paper; Top-K; Social networks; Spatial data; Reverse top-K
• ISSN: 1066-8888; 0949-877X
• DOI: 10.1007/s00778-022-00759-9

We introduce the
R
everse
S
patial Top-k
K
eyword (RSK)
query, which is defined as:
given a query term q, an integer k and a neighborhood size find all the neighborhoods of that size where q is in the top-k most frequent terms among the social posts in those neighborhoods
. An obvious approach would be to partition the dataset with a uniform grid structure of a given cell size and identify the cells where this term is in the top-k most frequent keywords. However, this answer would be incomplete since it only checks for neighborhoods that are perfectly aligned with the grid. Furthermore, for every neighborhood (square) that is an answer, we can define infinitely more result neighborhoods by minimally shifting the square without including more posts in it. To address that, we need to identify contiguous regions where any point in the region can be the center of a neighborhood that satisfies the query. We propose an algorithm to efficiently answer an RSK query using an index structure consisting of a uniform grid augmented by materialized lists of term frequencies. We apply various optimizations that drastically improve query latency against baseline approaches. We also provide a theoretical model to choose the optimal cell size for the index to minimize query latency. We further examine a restricted version of the problem (RSKR) that limits the scope of the answer and propose efficient
approximate
algorithms. Finally, we examine how parallelism can improve performance by balancing the workload using a smart
load slicing
technique. Extensive experimental performance evaluation of the proposed methods using real Twitter datasets and crime report datasets, shows the efficiency of our optimizations and the accuracy of the proposed theoretical model.