BLOCK: Efficient Execution of Spatial Range Queries in Main-Memory

被引:3
|
作者
Olma, Matthaios [1 ]
Tauheed, Farhan [2 ]
Heinis, Thomas [3 ]
Ailamaki, Anastasia [1 ]
机构
[1] Ecole Polytech Fed Lausanne, Lausanne, Switzerland
[2] Oracle Labs, Zurich, Switzerland
[3] Imperial Coll, London, England
基金
英国工程与自然科学研究理事会; 欧盟地平线“2020”;
关键词
D O I
10.1145/3085504.3085519
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
The execution of spatial range queries is at the core of many applications, particularly in the simulation sciences but also in many other domains. Although main memory in desktop and supercomputers alike has grown considerably in recent years, most spatial indexes supporting the efficient execution of range queries are still only optimized for disk access (minimizing disk page reads). Recent research has primarily focused on the optimization of known disk-based approaches for memory (through cache alignment etc.) but has not fundamentally revisited index structures for memory. In this paper we develop BLOCK, a novel approach to execute range queries on spatial data featuring volumetric objects in main memory. Our approach is built on the key insight that in-memory approaches need to be optimized to reduce the number of intersection tests (between objects and query but also in the index structure). Our experimental results show that BLOCK outperforms known in-memory indexes as well as in-memory implementations of disk-based spatial indexes up to a factor of 7. The experiments show that it is more scalable than competing approaches as the data sets become denser.
引用
收藏
页数:12
相关论文
共 50 条
  • [1] MQJoin: Efficient Shared Execution of Main-Memory Joins
    Makreshanski, Darko
    Giannikis, Georgios
    Alonso, Gustavo
    Kossmann, Donald
    [J]. PROCEEDINGS OF THE VLDB ENDOWMENT, 2016, 9 (06): : 480 - 491
  • [2] BB-Tree: A main-memory index structure for multidimensional range queries
    Sprenger, Stefan
    Schaefer, Patrick
    Leser, Ulf
    [J]. 2019 IEEE 35TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2019), 2019, : 1566 - 1569
  • [3] Efficient execution of small (single-tuple) transactions in main-memory databases
    Kolltveit, Heine
    Hvasshovd, Svein-Olaf
    [J]. ADVANCES IN DATABASES AND INFORMATION SYSTEMS, PROCEEDINGS, 2008, 5207 : 153 - 167
  • [4] DATA-FLOW QUERY EXECUTION IN A PARALLEL MAIN-MEMORY ENVIRONMENT
    WILSCHUT, AN
    APERS, PMG
    [J]. DISTRIBUTED AND PARALLEL DATABASES, 1993, 1 (01) : 103 - 128
  • [5] Efficient Bundled Spatial Range Queries
    Zacharatou, Eleni Tzirita
    Sidlauskas, Darius
    Tauheed, Farhan
    Heinis, Thomas
    Ailamaki, Anastasia
    [J]. 27TH ACM SIGSPATIAL INTERNATIONAL CONFERENCE ON ADVANCES IN GEOGRAPHIC INFORMATION SYSTEMS (ACM SIGSPATIAL GIS 2019), 2019, : 139 - 148
  • [6] Efficient Execution of Multiple Queries on Deep Memory Hierarchy
    Yan Zhang
    Zhi-Feng Chen
    Yuan-Yuan Zhou
    [J]. Journal of Computer Science and Technology, 2007, 22 : 273 - 279
  • [7] Efficient execution of multiple queries on deep memory hierarchy
    Zhang, Yan
    Chen, Zhi-Feng
    Zhou, Yuan-Yuan
    [J]. JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY, 2007, 22 (02): : 273 - 279
  • [8] Main-Memory Database Systems
    Kemper, Alfons
    Neumann, Thomas
    [J]. 2014 IEEE 30TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE), 2014, : 1310 - 1310
  • [9] Efficient Main-Memory Top-K Selection For Multicore Architectures
    Zois, Vasileios
    Tsotras, Vassilis J.
    Najjar, Walid A.
    [J]. PROCEEDINGS OF THE VLDB ENDOWMENT, 2019, 13 (02): : 114 - 127
  • [10] Efficient Evaluation of Multi-Column Selection Predicates in Main-Memory
    Broneske, David
    Koeppen, Veit
    Saake, Gunter
    Schaeler, Martin
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2019, 31 (07) : 1296 - 1311