arrow
Return

Bulk-loading and bulk-insertion algorithms for xBR+-trees in Solid State Drives

delete2019-03-12
delete2
PRE
AI
G
George Roumelis
A
Athanasios Fevgas
M
Michael Vassilakopoulos *
A
Antonio Corral
P
Panayiotis Bozanis
Y
Yannis Manolopoulos
DOI:10.1007/s00607-019-00709-4delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
Spatial indexes are important in spatial databases for efficient execution of queries involving spatial constraints. The xBR(+)-tree is a balanced, disk-resident, Quadtree-based index for point data, which is very efficient for processing spatial queries. Bulk-loading refers to the process of creating an index from scratch as a whole, when the dataset to be indexed is available beforehand, instead of creating (loading) the index gradually, when the dataset items are available one-by-one. Bulk insertion refers to the process of updating an existing index by inserting a large batch of new data, treating the items of this batch as a whole and not by inserting these items one-by-one. In this paper, we modify previous bulk-loading and bulk-insertion algorithms for xBR(+)-trees to achieve higher performance by taking advantage of the special features of Solid State Drives (SSDs). SSDs have attracted database developers, mainly due to their higher read performance (thanks to their internal parallelism) than Hard Disk Drives. Using real and artificial datasets of various cardinalities, we experimentally compare the modified algorithms against their predecessors and show that the modified algorithms are clear winners regarding performance.
Keywords:
Spatial indexes
Bulk-loading
Bulk-insertion
xBR(+)-trees
Solid State Drives
AI Summary

AI Summary

Key information extracted from the uploaded paper, including a brief overview, abstract, background, key highlights, visual analysis, and future outlook.

Journal

C
Computing
IF:
2.8
Papers:
2.3K
Citations:
3.5K

Organization

O
Open University of Cyprus
Scholars:
292
Papers: 356
Citations: 311
U
universidad de almeria
Scholars:
4.4K
Papers: 4.0K
Citations: 1
U
University of Thessaly
Scholars:
7.7K
Papers: 6.0K
Citations: 5.7K
researcher View more organizations