Integrating outlier removal into existing histogram construction methods for geographic data

摘要

Histograms have been widely used for estimating selectivity in query optimization. In this paper, we propose a new approach to improve the accuracy of histograms for multi-dimensional geographic data. Our idea is to remove outliers where appropriate in the histogram buckets. Our aim, in removing the outliers, is to increase the uniformity of data distribution in the buckets' areas, and thus enhance the histogram's accuracy. While the two fields, histogram construction and outlier detection, have been extensively investigated, there has been no research work on their integration to improve the accuracy of the histogram. Therefore, we present in this paper why removing outliers is useful for the histograms. Then, we describe a simple, yet effective, algorithm to detect and remove outliers for the histogram buckets. This algorithm is designed especially for histogram buckets and can be integrated easily into existing histogram construction methods. Through extensive experiments using real-life data sets, we show that the proposed approach can enhance the accuracy of existing histogram construction methods by 2 times on average.