Browse > Article

Entropy-based Dynamic Histogram for Spatio-temporal Databases  

박현규 (한국과학기술원 전자전산학과 전산학)
손진현 (한양대학교 컴퓨터공학과)
김명호 (한국과학기술원 전자전산학과 전산학)
Abstract
Various techniques including histograms, sampling and parametric techniques have been proposed to estimate query result sizes for the query optimization. Histogram-based techniques are the most widely used form for the selectivity estimation in relational database systems. However, in the spatio-temporal databases for the moving objects, the continual changes of the data distribution suffer the direct utilization of the state of the art histogram techniques. Specifically for the future queries, we need another methodology that considers the updated information and keeps the accuracy of the result. In this paper we propose a novel approach based upon the duality and the marginal distribution to construct a histogram with very little time since the spatio-temporal histogram requires the data distribution defined by query predicates. We use data synopsis method in the dual space to construct spatio-temporal histograms. Our method is robust to changing data distributions during a certain period of time while the objects keep the linear movements. An additional feature of our approach supports the dynamic update incrementally and maintains the accuracy of the estimated result.
Keywords
Spatio-temporal Database; Moving Object; Selectivity Estimation; Histogram;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Wolfson, O., Sistla, P., Chamberlain, S., Yesha, Y., 'Updating and Querying Databases that track Mobile Units,' J. of Distributed and Parallel Databases, Vol. 7, pp257-287, 1999   DOI
2 Kollios, G., Gunopulos, D., Tsotras, V., 'On Indexing Mobile Objects,' Proceedings of PODS, pp. 262-272, 1999   DOI
3 Thaper, N., Guha, S., Indyk, P., Koudas, N., 'Dynamic Multidimensional Histograms,' Proceedings of SIGMOD Conference, pp. 427-439, 2002   DOI
4 Park, H.K., Son, J.H., Kim, M.H., 'An Efficient Spatioternporal Indexing Method for Moving Objects in Mobile Communication Environments,' The Int. Conf. on MDM, LNCS 2574, pp78-91. 2003
5 Saltcnis, S., Jensen, C, 'Indexing of Moving Objects for Location-Based Services,' Proceedings of ICDE, pp. 463-472, 2002   DOI
6 Choi, Y.. Chung, C., 'Selectivity Estimation for Spatia-Temporal Queries to Moving Objects,' Proceedings of SIGMOD Conference, pp. 440-451, 2002   DOI
7 Wang, M., Vitter, J.. Lim, L., Padmanabhan, S., 'Wavelet-Based Cost Estimation for Spatial Queries,' The Int. Conf. on SSTD, LNCS 2121, pp. 175-193, 2001
8 Acharya, S., Poosala, V., Ramaswamy, S., 'Selectivity Estimation in Spatial Databases,' Proceedings of SIGMOD, pp. 13-24, 1999   DOI
9 Aboulnaga, A., Naughton, J., 'Accurate Estimation of the Cost of Spatial Selections,' Proceedings of ICDE, pp. 123-134, 2000   DOI
10 Poosala, V., et al., 'Improved Histograms for Selectivity Estimation of Range Predicates,' Proceedings of SIGMOD Conference, pp. 294 - 305, 1996   DOI
11 Muthukrishnan, S., Poosala, V., Suel, T., 'On Rectangular Partitioning in Two Dimensions: Algorithms, Complexity and Applications,' The Int. Conf. on DT, LNCS 1540, pp. 236-256, 1998
12 Bertimas, D., Tsitsiklis, J.. Introduction to Linear Optimization, Athena Scientific, 1997
13 Devore, J.. Probability and Statistics for Engineering and the Sciences, 5th Ed. Duxbury, Pacific Grove, CA., 2000
14 Baeza-Yates, R., Ribeiro-Neto, B., Modem Information Retrieval, Addison-Wesley, 1999
15 Chakrabarti, K., et al., 'Approximate Query Processing Using Wavelets,' Proceedings of the VLDB Conference, pp.111-122, 2000
16 Matias, Y., Vitter, J., Wang, M., 'Dynamic Maintenance of Wavelet-Based Histograms,' Proceedings of 26th VLDB, pp. 101-110, 2000