The RLR-Tree: A Reinforcement Learning Based R-Tree for Spatial Data

Author:

Gu Tu1ORCID,Feng Kaiyu1ORCID,Cong Gao1ORCID,Long Cheng1ORCID,Wang Zheng1ORCID,Wang Sheng2ORCID

Affiliation:

1. Nanyang Technological University, Singapore, Singapore

2. Alibaba Group, Singapore, Singapore

Abstract

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.

Funder

Alibaba-NTU Singapore Joint Research Institute

Publisher

Association for Computing Machinery (ACM)

Reference45 articles.

1. The priority R-tree

2. The R*-tree: an efficient and robust access method for points and rectangles

3. A revised r*-tree in comparison with related index structures

4. Multidimensional binary search trees used for associative searching

5. Angjela Davitkova Evica Milchevski and Sebastian Michel. 2020. The ML-Index: A Multidimensional Learned Index for Point Range and Nearest-Neighbor Queries.. In EDBT. 407--410. Angjela Davitkova Evica Milchevski and Sebastian Michel. 2020. The ML-Index: A Multidimensional Learned Index for Point Range and Nearest-Neighbor Queries.. In EDBT. 407--410.

Cited by 9 articles. 订阅此论文施引文献 订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献

1. A Survey of Multi-Dimensional Indexes: Past and Future Trends;IEEE Transactions on Knowledge and Data Engineering;2024-08

2. The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions;Proceedings of the VLDB Endowment;2024-07

3. Machine Learning for Databases: Foundations, Paradigms, and Open problems;Companion of the 2024 International Conference on Management of Data;2024-06-09

4. Unicorn: A Unified Multi-Tasking Matching Model;ACM SIGMOD Record;2024-05-14

5. Chameleon: Towards Update-Efficient Learned Indexing for Locally Skewed Data;2024 IEEE 40th International Conference on Data Engineering (ICDE);2024-05-13

同舟云学术

1.学者识别学者识别

2.学术分析学术分析

3.人才评估人才评估

"同舟云学术"是以全球学者为主线,采集、加工和组织学术论文而形成的新型学术文献查询和分析系统,可以对全球学者进行文献检索和人才价值评估。用户可以通过关注某些学科领域的顶尖人物而持续追踪该领域的学科进展和研究前沿。经过近期的数据扩容,当前同舟云学术共收录了国内外主流学术期刊6万余种,收集的期刊论文及会议论文总量共计约1.5亿篇,并以每天添加12000余篇中外论文的速度递增。我们也可以为用户提供个性化、定制化的学者数据。欢迎来电咨询!咨询电话:010-8811{复制后删除}0370

www.globalauthorid.com

TOP

Copyright © 2019-2024 北京同舟云网络信息技术有限公司
京公网安备11010802033243号  京ICP备18003416号-3