Optimization of spatial joins using filters

  • Hein M. Veenhof
  • Peter M. G. Apers
  • Maurice A. W. Houtsma
Conference paper

DOI: 10.1007/BFb0000545

Part of the Lecture Notes in Computer Science book series (LNCS, volume 940)
Cite this paper as:
Veenhof H.M., Apers P.M.G., Houtsma M.A.W. (1995) Optimization of spatial joins using filters. In: Goble C., Keane J. (eds) Advances in Databases. BNCOD 1995. Lecture Notes in Computer Science, vol 940. Springer, Berlin, Heidelberg

Abstract

When viewing present-day technical applications that rely on the use of database systems, one notices that new techniques must be integrated in database management systems to be able to support these applications efficiently. This paper discusses one of these techniques in the context of supporting a Geographic Information System. It is known that the use of filters on geometric objects has a significant impact on the processing of 2-way spatial join queries. For this purpose, filters require approximations of objects. Queries can be optimized by filtering data not with just one but with several filters. Existing join methods are based on a combination of filters and a spatial index. The index is used to reduce the cost of the filter step and to minimize the cost of retrieving geometric objects from disk.

In this paper we examine n-way spatial joins. Complex n-way spatial join queries require solving several 2-way joins of intermediate results. In this case, not only the profit gained from using both filters and spatial indices but also the additional cost due to using these techniques are examined. For 2-way joins of base relations these costs are considered part of physical database design. We focus on the criteria for mutually comparing filters and not on those for spatial indices. Important aspects of a multi-step filter-based n-way spatial join method are described together with performance experiments. The winning join method uses several filters with approximations that are constructed by rotating two parallel lines around the object.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer-Verlag 1995

Authors and Affiliations

  • Hein M. Veenhof
    • 1
  • Peter M. G. Apers
    • 1
  • Maurice A. W. Houtsma
    • 2
  1. 1.University of TwenteAE Enschedethe Netherlands
  2. 2.Telematics Research CentreAE Enschedethe Netherlands

Personalised recommendations