The RLR-tree: a reinforcement learning based R-tree for spatial data

Learned indexes have been proposed to replace classic index structures like B-Tree with machine learning (ML) models. They require to replace both the indexes and query processing algorithms currently deployed by the databases, and such a radical departure is likely to encounter challenges and obsta...

Full description

Bibliographic Details
Main Authors: Gu, Tu, Feng, Kaiyu, Cong, Gao, Long, Cheng, Wang, Zheng, Wang, Sheng
Other Authors: Interdisciplinary Graduate School (IGS)
Format: Conference Paper
Language:English
Published: 2023
Subjects:
Online Access:https://hdl.handle.net/10356/166210
https://2023.sigmod.org/
_version_ 1811686233161596928
author Gu, Tu
Feng, Kaiyu
Cong, Gao
Long, Cheng
Wang, Zheng
Wang, Sheng
author2 Interdisciplinary Graduate School (IGS)
author_facet Interdisciplinary Graduate School (IGS)
Gu, Tu
Feng, Kaiyu
Cong, Gao
Long, Cheng
Wang, Zheng
Wang, Sheng
author_sort Gu, Tu
collection NTU
description Learned indexes have been proposed to replace classic index structures like B-Tree with machine learning (ML) models. They require to replace both the indexes and query processing algorithms currently deployed by the databases, and such a radical departure is likely to encounter challenges and obstacles. In contrast, we propose a fundamentally different way of using ML techniques to build a better R-Tree without the need to change the structure or query processing algorithms of traditional R-Tree. Specifically, we develop reinforcement learning (RL) based models to decide how to choose a subtree for insertion and how to split a node when building and updating an R-Tree, instead of relying on hand-crafted heuristic rules currently used by the R-Tree and its variants. Experiments on real and synthetic datasets with up to more than 100 million spatial objects show that our RL based index outperforms the R-Tree and its variants in terms of query processing time.
first_indexed 2024-10-01T04:57:09Z
format Conference Paper
id ntu-10356/166210
institution Nanyang Technological University
language English
last_indexed 2024-10-01T04:57:09Z
publishDate 2023
record_format dspace
spelling ntu-10356/1662102023-05-08T02:17:54Z The RLR-tree: a reinforcement learning based R-tree for spatial data Gu, Tu Feng, Kaiyu Cong, Gao Long, Cheng Wang, Zheng Wang, Sheng Interdisciplinary Graduate School (IGS) 2023 ACM SIGMOD/PODS Alibaba Group Alibaba-NTU Singapore Joint Research Institute (JRI) Engineering::Computer science and engineering::Data Spatial Data Spatial Query Processing Learned Index Reinforcement Learning Deep Learning Learned indexes have been proposed to replace classic index structures like B-Tree with machine learning (ML) models. They require to replace both the indexes and query processing algorithms currently deployed by the databases, and such a radical departure is likely to encounter challenges and obstacles. In contrast, we propose a fundamentally different way of using ML techniques to build a better R-Tree without the need to change the structure or query processing algorithms of traditional R-Tree. Specifically, we develop reinforcement learning (RL) based models to decide how to choose a subtree for insertion and how to split a node when building and updating an R-Tree, instead of relying on hand-crafted heuristic rules currently used by the R-Tree and its variants. Experiments on real and synthetic datasets with up to more than 100 million spatial objects show that our RL based index outperforms the R-Tree and its variants in terms of query processing time. Nanyang Technological University This work was supported by Alibaba Group through Alibaba Innovative Research (AIR) Program and Alibaba-NTU Singapore Joint Research Institute (JRI), Nanyang Technological University, Singapore. 2023-05-08T02:17:19Z 2023-05-08T02:17:19Z 2023 Conference Paper Gu, T., Feng, K., Cong, G., Long, C., Wang, Z. & Wang, S. (2023). The RLR-tree: a reinforcement learning based R-tree for spatial data. 2023 ACM SIGMOD/PODS. https://dx.doi.org/10.1145/3588917 https://hdl.handle.net/10356/166210 10.1145/3588917 https://2023.sigmod.org/ en AN-GC-2018-024 © 2023 The owner/author(s). Publication rights licensed to ACM. All rights reserved.
spellingShingle Engineering::Computer science and engineering::Data
Spatial Data
Spatial Query Processing
Learned Index
Reinforcement Learning
Deep Learning
Gu, Tu
Feng, Kaiyu
Cong, Gao
Long, Cheng
Wang, Zheng
Wang, Sheng
The RLR-tree: a reinforcement learning based R-tree for spatial data
title The RLR-tree: a reinforcement learning based R-tree for spatial data
title_full The RLR-tree: a reinforcement learning based R-tree for spatial data
title_fullStr The RLR-tree: a reinforcement learning based R-tree for spatial data
title_full_unstemmed The RLR-tree: a reinforcement learning based R-tree for spatial data
title_short The RLR-tree: a reinforcement learning based R-tree for spatial data
title_sort rlr tree a reinforcement learning based r tree for spatial data
topic Engineering::Computer science and engineering::Data
Spatial Data
Spatial Query Processing
Learned Index
Reinforcement Learning
Deep Learning
url https://hdl.handle.net/10356/166210
https://2023.sigmod.org/
work_keys_str_mv AT gutu therlrtreeareinforcementlearningbasedrtreeforspatialdata
AT fengkaiyu therlrtreeareinforcementlearningbasedrtreeforspatialdata
AT conggao therlrtreeareinforcementlearningbasedrtreeforspatialdata
AT longcheng therlrtreeareinforcementlearningbasedrtreeforspatialdata
AT wangzheng therlrtreeareinforcementlearningbasedrtreeforspatialdata
AT wangsheng therlrtreeareinforcementlearningbasedrtreeforspatialdata
AT gutu rlrtreeareinforcementlearningbasedrtreeforspatialdata
AT fengkaiyu rlrtreeareinforcementlearningbasedrtreeforspatialdata
AT conggao rlrtreeareinforcementlearningbasedrtreeforspatialdata
AT longcheng rlrtreeareinforcementlearningbasedrtreeforspatialdata
AT wangzheng rlrtreeareinforcementlearningbasedrtreeforspatialdata
AT wangsheng rlrtreeareinforcementlearningbasedrtreeforspatialdata