A Compressed Histogram Technique for Spatial Selectivity Estimation

공간 선택률 추정을 위한 압축 히스토그램 기법

  • Chung, Jae-Du (Database Laboratory of Chungbuk National University) ;
  • Chi, Jeong-Hee (Database Laboratory of Chungbuk National University) ;
  • Ryu, Keun-Ho (Database Laboratory of Chungbuk National University)
  • 정재두 (충북대학교 데이터베이스 연구실) ;
  • 지정희 (충북대학교 데이터베이스 연구실) ;
  • 류근호 (충북대학교 데이터베이스 연구실)
  • Published : 2004.12.10

Abstract

Selectivity estimation for spatial query is very important process in finding the most efficient execution plan. Many works have been performed to estimate accurately selectivity. Although they deal with some problems such as false-count, multi-count, they require a large amount of memory to retain accurate selectivity, so they can not get good results in little memory environments such as mobile-based small database. In order to solve this problem, we propose a new technique called MW histogram which is able to compress summary data and get reasonable results. It also has a flexible structure to react dynamic update. The experimental results showed that the MW histogram has lower relative error than MinSkew histogram and gets a good selectivity in little memory.

Keywords