PLATON: top-down R-tree packing with learned partition policy

The exponential growth of spatial data poses new challenges to the performance of spatial databases. Spatial indexes like R-tree greatly accelerate the query performance and can be effectively constructed through packing, i.e., loading all data into the index at once. However, existing R-tree packin...

Full description

Saved in:
Bibliographic Details
Main Authors: Yang, Jingyi, Cong, Gao
Other Authors: Interdisciplinary Graduate School (IGS)
Format: Conference or Workshop Item
Language:English
Published: 2024
Subjects:
Online Access:https://hdl.handle.net/10356/174800
https://dl.acm.org/toc/pacmmod/2023/1/4
https://2023.sigmod.org/
Tags: Add Tag
No Tags, Be the first to tag this record!
Institution: Nanyang Technological University
Language: English
id sg-ntu-dr.10356-174800
record_format dspace
spelling sg-ntu-dr.10356-1748002024-04-14T15:37:57Z PLATON: top-down R-tree packing with learned partition policy Yang, Jingyi Cong, Gao Interdisciplinary Graduate School (IGS) 2023 ACM SIGMOD/PODS International Conference on Management of Data Computer and Information Science Learned index Information systems The exponential growth of spatial data poses new challenges to the performance of spatial databases. Spatial indexes like R-tree greatly accelerate the query performance and can be effectively constructed through packing, i.e., loading all data into the index at once. However, existing R-tree packing methods rely on a set of fixed heuristic rules, which may not be suitable for different data distributions and workload patterns. To address the limitations of existing R-tree packing methods, we propose PLATON, a top-down R-tree packing method with learned partition policy that explicitly optimizes the query performance with regard to the given data and workload instance. We develop a learned partition policy based on Monte Carlo Tree Search and carefully make design choices for the MCTS exploration strategy and simulation strategy to improve algorithm convergence. We propose a divide and conquer strategy and two optimization techniques, early termination and level-wise sampling, to drastically reduce the MCTS algorithm’s time complexity and make it a linear-time algorithm. Experiments on both synthetic and real-world datasets demonstrate the superior performance of PLATON over existing R-tree variants and recently proposed learned/workload-aware spatial indexes. Ministry of Education (MOE) Published version This research is supported in part by MOE Tier-2 grant MOE-T2EP20221-0015. 2024-04-12T05:41:04Z 2024-04-12T05:41:04Z 2023 Conference Paper Yang, J. & Cong, G. (2023). PLATON: top-down R-tree packing with learned partition policy. 2023 ACM SIGMOD/PODS International Conference on Management of Data, 1(4), 253-. https://dx.doi.org/10.1145/3626742 2836-6573 https://hdl.handle.net/10356/174800 10.1145/3626742 https://dl.acm.org/toc/pacmmod/2023/1/4 https://2023.sigmod.org/ 1(4) 253 en MOE-T2EP20221-0015 © 2023 Copyright held by the owner/author(s). Publication rights licensed to ACM. Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than the author(s) must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from permissions@acm.org. application/pdf
institution Nanyang Technological University
building NTU Library
continent Asia
country Singapore
Singapore
content_provider NTU Library
collection DR-NTU
language English
topic Computer and Information Science
Learned index
Information systems
spellingShingle Computer and Information Science
Learned index
Information systems
Yang, Jingyi
Cong, Gao
PLATON: top-down R-tree packing with learned partition policy
description The exponential growth of spatial data poses new challenges to the performance of spatial databases. Spatial indexes like R-tree greatly accelerate the query performance and can be effectively constructed through packing, i.e., loading all data into the index at once. However, existing R-tree packing methods rely on a set of fixed heuristic rules, which may not be suitable for different data distributions and workload patterns. To address the limitations of existing R-tree packing methods, we propose PLATON, a top-down R-tree packing method with learned partition policy that explicitly optimizes the query performance with regard to the given data and workload instance. We develop a learned partition policy based on Monte Carlo Tree Search and carefully make design choices for the MCTS exploration strategy and simulation strategy to improve algorithm convergence. We propose a divide and conquer strategy and two optimization techniques, early termination and level-wise sampling, to drastically reduce the MCTS algorithm’s time complexity and make it a linear-time algorithm. Experiments on both synthetic and real-world datasets demonstrate the superior performance of PLATON over existing R-tree variants and recently proposed learned/workload-aware spatial indexes.
author2 Interdisciplinary Graduate School (IGS)
author_facet Interdisciplinary Graduate School (IGS)
Yang, Jingyi
Cong, Gao
format Conference or Workshop Item
author Yang, Jingyi
Cong, Gao
author_sort Yang, Jingyi
title PLATON: top-down R-tree packing with learned partition policy
title_short PLATON: top-down R-tree packing with learned partition policy
title_full PLATON: top-down R-tree packing with learned partition policy
title_fullStr PLATON: top-down R-tree packing with learned partition policy
title_full_unstemmed PLATON: top-down R-tree packing with learned partition policy
title_sort platon: top-down r-tree packing with learned partition policy
publishDate 2024
url https://hdl.handle.net/10356/174800
https://dl.acm.org/toc/pacmmod/2023/1/4
https://2023.sigmod.org/
_version_ 1814047302480822272