A learned index for continuous range queries over streaming data
摘要
Continuous range queries (CRQs) involve persistent queries on streaming data that continuously retrieve new records that fall within specified ranges. Due to high memory overheads and time costs, traditional query indexing structures have difficulty handling large-scale continuous-range query data. To address this problem, we propose a learned index for CRQs over streaming data (LICRQ). The LICRQ combines a multilayer grid, spatial range filters, and learned indexes to accelerate the processing of numerous CRQs of various sizes while reducing memory consumption. We also introduce the G-LICRQ, a GPU-accelerated extension of the LICRQ that significantly improves the processing throughput. The experimental results show that the LICRQ outperforms CKDB-tree, achieving approximately 50% faster query times and 20% lower memory usage, and surpasses PriPL-Tree with approximately 23% faster queries and 16% less space overhead than traditional indexes. Furthermore, the LICRQ decreases the query overheads by 12% compared with the learned index FLIRT, and the G-LICRQ reduces the query time by approximately 66% compared with that of the LICRQ and by approximately 43% compared with that of G-CKDB-tree.