Optimal partitioning for efficient I/O in spatial databases

Hakan Ferhatosmanoglu, Divyakant Agrawal, Amr El Abbadi

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Citation (Scopus)

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/O cost 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.

Original languageEnglish
Title of host publicationEuro-Par 2001 Parallel Processing - 7th International Euro-Par Conference, Proceedings
EditorsRizos Sakellariou, John Gurd, Len Freeman, John Keane
PublisherSpringer Verlag
Pages889-900
Number of pages12
ISBN (Electronic)3540424954, 9783540424956
Publication statusPublished - 1 Jan 2001
Event7th European Conference on Parallel Computing, Euro-Par 2001 - Manchester, United Kingdom
Duration: 28 Aug 200131 Aug 2001

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume2150
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Other

Other7th European Conference on Parallel Computing, Euro-Par 2001
CountryUnited Kingdom
CityManchester
Period28/8/0131/8/01

    Fingerprint

ASJC Scopus subject areas

  • Theoretical Computer Science
  • Computer Science(all)

Cite this

Ferhatosmanoglu, H., Agrawal, D., & El Abbadi, A. (2001). Optimal partitioning for efficient I/O in spatial databases. In R. Sakellariou, J. Gurd, L. Freeman, & J. Keane (Eds.), Euro-Par 2001 Parallel Processing - 7th International Euro-Par Conference, Proceedings (pp. 889-900). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 2150). Springer Verlag.