Browse > Article

Selectivity Estimation for Multidimensional Sequence Data in Spatio-Temporal Databases  

Shin, Byoung-Cheol (에어포인트(주) 기술연구소)
Lee, Jong-Yun (충북대학교 컴퓨터교육과)
Publication Information
Journal of KIISE:Databases / v.34, no.1, 2007 , pp. 84-97 More about this Journal
Abstract
Selectivity estimation techniques in query optimization have been used in commercial databases and histograms are popularly used for the selectivity estimation. Recently, the techniques for spatio-temporal databases have been restricted to existing temporal and spatial databases. In addition, the selectivity estimation techniques focused on time-series data such as moving objects. It is also impossible to estimate selectivity for range queries with a time interval. Therefore, we construct two histograms, CMH (current multidimensional histogram) and PMH (past multidimensional histogram), to estimate the selectivity of multidimensional sequence data in spatio-temporal databases and propose effective selectivity estimation methods using the histograms. Furthermore, we solve a problem about the range query using our proposed histograms. We evaluated the effectiveness of histograms for range queries with a time interval through various experimental results.
Keywords
Selectivity estimation; Spatio-temporal Databases; Sequence Data; Histogram;
Citations & Related Records
연도 인용수 순위
  • Reference
1 J. S. Vitter, M. Wang, and B. Iyer, 'Data cube approximation and histograms via wavelets,' In Proceedings of Seventh International Conference on Information and Knowledge Management, pages 96-104, Washington D.C., November 1998
2 Tao, Y., Sun, J., and Papadias, D., 'Selectivity Estimation for Predictive Spatio-Temporal Queries,' ICDE, pages 417-428, 2003
3 Tao, Y., Papadias, D., and Sun, J., 'The TPR*- tree: An Optimized Spatio- Temporal Access Method for Predictive Queries,' In Proceedings of the 29th Very Large Data Bases Conference, Berlin, Germany, pages 790-801, 2003
4 Yossi Matias, Jeffrey Scott Vitter, and Min Wang, 'Wavelet-Based Histogram for Selectivity Estimation,' In Proceedings of ACM SIGMOD international conferences on Management of data, pages 448-459, 1998
5 Acharya, S., Poosala, V., and Ramaswamy, S., 'Selectivity Estimation in Spatial Databases,' In ACM SIGMOD, USA, pages 13-24, 1999
6 K. Charkrabarti, M. Garofalakis, R. Rastogi, and K. Shim, 'Approximate Query Processing Using Wavelets,' In Proc. of the 26th Intl. Conf. on Very Large Data Bases, September 2000
7 Poosala V., Yannis E., Ioannidis, Peter J., Haas., and Eugene J. Shekita, 'Improved Histograms for Selectivity Estimation of Range Predicates,' In ACM SIGMOD, NY, USA, pages 294-305, 1996
8 Wang, M., Vitter, J., S., Lim, L., and Pdmanabhan, S., 'Wavelet-Based Cost Estimation for Spatial Queries,' In The 7th International Sysposium on Spatial and Temporal Databases(SSTD), CA, USA, pages 175-196, July 2001
9 M. Garofalakis and P.B. Gibbons, 'Wavelet Synopses with Error Guarantees,' Bell Labs Tech. Memorandum, December 2001
10 Zhan, Q. and Lin, X., 'Clustering Moving Objects for Spatio-temporal Selectivity Estimation,' In ADC, pages 123-130, 2004
11 Sun, J., Papadias, D., Tao, Y., and Liu, B,. 'Querying about the Past, the Present, and the Future in Spatio-Temporal Databases,' In ICDE, pages 202-213, Mar. 2004
12 Antonios Deligiannakis and Nick Roussopoulos, 'Extended Wavelets for Multiple Measures,' In Processdings of the 2003 ACM SIGMOD International Conference on Management of Data
13 Aboulnaga, A. and Naughton, J. 'Accurate Estimation of the Cost of Spatial Selections,' In ICDE, pages 123-134, 2000
14 Lee, J. and Shin, B., 'Histogram-based Selectiviry Estimation in Spatio-Temporal Databases,' In Jonual of Korea Information Processing Society, Vol. 12-D, No.1, Feb. 2005
15 Choi, Y. and Chung, C., 'Selectivity Estimation for Spatio-Temporal Queries to Moving Objects,' In ACM SIGMOD, pages 440-451, 2002
16 Hadjieleftheriou, M., Kollios, H., and Tsotras, V J., 'Performance Evaluation of Spatio-temporal Selectivity Estimation Techniques,' In The 15th Int. conference on Science and Statistical Database Management (SSDBM), pages 202-211, 2003
17 Matias, J.S. Vitter, and M. Wang, 'Dynamic Maintenance of Wavelet-Based Histogram,' In Proc. of the 26th INtl. Conf. on Very Large Data Bases, September 2000