Optimal Partitioning for Efficient I/O in Spatial Databases

  • Authors:
  • Hakan Ferhatosmanoglu;Divyakant Agrawal;Amr El Abbadi

  • Affiliations:
  • -;-;-

  • Venue:
  • Euro-Par '01 Proceedings of the 7th International Euro-Par Conference Manchester on Parallel Processing
  • Year:
  • 2001

Quantified Score

Hi-index 0.01

Visualization

Abstract

It is desirable to design partitioning techniques that minimize the I/Oti me incurred during query execution in spatial databases. In this paper, we explore optimal partitioning techniques for spatial data for different types of queries, and develop multi-disk allocation techniques that maximize the degree of I/Opa rallelism obtained during the retrieval. We show that hexagonal partitioning has optimal I/Ocost for circular queries compared to all possible non-overlapping partitioning techniques that use convex regions. For rectangular queries, we show that although for the special case when queries are rectilinear, rectangular grid partitioning gives superior performance, hexagonal partitioning has overall better I/Oc ost for a general class of range queries. We then discuss parallel storage and retrieval techniques for hexagonal partitioning using current techniques for rectangular grid partitioning.