Selectivity Estimation for Spatial Databases

  • Chi, Jeong-Hee (Database Laboratory, Chungbuk National University) ;
  • Lee, Jin-Yul (Database Laboratory, Chungbuk National University) ;
  • Ryu, Keun-Ho (Database Laboratory, Chungbuk National University)
  • Published : 2003.11.03

Abstract

Selectivity estimation for spatial query is curial in Spatial Database Management Systems(SDBMS). Many works have been performed to estimate accurate selectivity. Although they deal with some problems such as false-count, multi-count arising from properties of spatial dataset, they can not get such effects in little memory space.* Therefore, we need to compress spatial dataset into little memory. In this paper, we propose a new technique called MW Histogram which is able to compress summary data and get reasonable results. Our method is based on two techniques:(a)MinSkew partitioning algorithm which deal with skewed spatial datasets. efficiently (b) Wavelet transformation which compression effect is proven. We evaluate our method via real datasets. The experimental result shows that the MW Histogram has the ability of providing estimates with low relative error and retaining the similar estimates even if memory space is small.

Keywords