A Cost Model for Spatial Intersection Queries on RI-Trees

  • Hans-Peter Kriegel
  • Martin Pfeifle
  • Marco Pötke
  • Thomas Seidl
Conference paper

DOI: 10.1007/978-3-540-24571-1_30

Part of the Lecture Notes in Computer Science book series (LNCS, volume 2973)
Cite this paper as:
Kriegel HP., Pfeifle M., Pötke M., Seidl T. (2004) A Cost Model for Spatial Intersection Queries on RI-Trees. In: Lee Y., Li J., Whang KY., Lee D. (eds) Database Systems for Advanced Applications. DASFAA 2004. Lecture Notes in Computer Science, vol 2973. Springer, Berlin, Heidelberg

Abstract

The efficient management of interval sequences represents a core requirement for many temporal and spatial database applications. With the Relational Interval Tree (RI-tree), an efficient access method has been proposed to process intersection queries of spatial objects encoded by interval sequences on top of existing object-relational database systems. This paper complements that approach by effective and efficient models to estimate the selectivity and the I/O cost of interval sequence intersection queries in order to guide the cost-based optimizer whether and how to include the RI-tree into the execution plan. By design, the models immediately fit to common extensible indexing/ optimization frameworks, and their implementations exploit the built-in statistics facilities of the database server. According to our experimental evaluation on an Oracle database, the average relative error of the estimated query results and costs lies in the range of 0% to 32%, depending on the size and the structural complexity of the query objects.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer-Verlag Berlin Heidelberg 2004

Authors and Affiliations

  • Hans-Peter Kriegel
    • 1
  • Martin Pfeifle
    • 1
  • Marco Pötke
    • 2
  • Thomas Seidl
    • 3
  1. 1.University of Munich 
  2. 2.sd&m AG software design & management 
  3. 3.RWTH Aachen University 

Personalised recommendations