Abstract
Selectivity estimation for spatial query is very important process in finding the most efficient execution plan. Many works have been performed to estimate accurate selectivity. However, the existing works require a large amount of memory to retain accurate selectivity, and these works 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. The proposed method is based on the spatial partitioning algorithm of MinSkew histogram and wavelet transformation. The experimental results showed that the MW histogram has lower relative error than MinSkew histogram and gets a good selectivity in little memory.
This research was supported by University IT Research Center Project in Korea.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Matias, Y., Vitter, J.S., Wang, M.: Wavelet-Based Histograms for Selectivity Estimation. In: Proc. ACM SIGMOD Int. Conf. on Management of Data, pp. 448–459 (1998)
Acharya, S., Poosala, V., Ramaswamy, S.: Selectivity estimation in spatial databases. In: Proc. ACM SIGMOD Int. Conf. on Management of Data, pp. 13–24 (1999)
Getoor, L., Taskar, B., Koller, D.: Selectivity estimation using probabilistic models. In: Proc. ACM SIGMOD Int. Conf. on Management of Data, pp. 461–473 (2001)
Sun, C., Agrawal, D., El Abbadi, A.: Selectivity for spatial joins with geometric selections. In: Proc. of EDBT (2002), pp. 609–626 (2002)
Chi, J.H., Kim, S.H., Ryu, K.H.: Selectivity Estimation using the Generalized Cumulative Density Histogram. In: Asian Symposium on Geographic Information System from Computer Science & Engineering View 2th(ASGIS 2004), pp. 201–207 (2004)
Mino, s.G., Phillip, B.G.: Wavelet Synopses with Error Guarantees. In: ACM SIGMOD, Madison, Wisconsin, USA, pp. 476–487 (2002)
Jin, J., An, N., Sivasubramaniam, A.: Analyzing Range Queries on Spatial Data. In: Proceedings of the IEEE International Conference on Data Engineering(ICDE 2000), pp. 525–534.
An, N., Yang, Z.-Y., Sivasubramaniam., A.: Selectivity estimation for spatial joins. In: Proceedings of the IEEE International Conference on Data Engineering(ICDE 2001), pp. 175–196 (2001)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Chi, J.H., Kim, S.H., Ryu, K.H. (2005). Spatial Selectivity Estimation Using Compressed Histogram Information. In: Zhang, Y., Tanaka, K., Yu, J.X., Wang, S., Li, M. (eds) Web Technologies Research and Development - APWeb 2005. APWeb 2005. Lecture Notes in Computer Science, vol 3399. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-31849-1_47
Download citation
DOI: https://doi.org/10.1007/978-3-540-31849-1_47
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-25207-8
Online ISBN: 978-3-540-31849-1
eBook Packages: Computer ScienceComputer Science (R0)