Browse > Article

Selectivity Estimation for Timestamp Queries  

Shin, Byoung-Cheol (충북대학교 컴퓨터교육과)
Lee, Jong-Yun (충북대학교 컴퓨터교육과)
Publication Information
Journal of KIISE:Databases / v.33, no.2, 2006 , pp. 214-223 More about this Journal
Abstract
Recently there is a need to store and process enormous spatial data in spatio-temporal databases. For effective query processing in spatio-temporal databases, selectivity estimation in query optimization techniques, which approximate query results when the precise answer is not necessary or early feedback is helpful, has been studied. There have been selectivity estimation techniques such as sampling-based techniques, histogram-based techniques, and wavelet-based techniques. However, existing techniques in spatio-temporal databases focused on selectivity estimation for future extent of moving objects. In this paper, we construct a new histogram, named T-Minskew, for query optimization of past spatio-temporal data. We also propose an effective selectivity estimation method using T-Minskew histogram and effective histogram maintenance technique to prevent frequent histogram reconstruction using threshold.
Keywords
Spatio-temporal Databases; Query Optimization; Selectivity Estimation; Histogram;
Citations & Related Records
연도 인용수 순위
  • Reference
1 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   DOI   ScienceOn
2 Lee, J., Kim, D., and Chung, C., 'Multidimensional selectivity estimation using compressed histogram information,' In Proceeding of ACM SIGMOD international conferences on Management of data, pages 205-214, 1999   DOI
3 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   DOI
4 Zhan, Q. and Lin, X., 'Clustering Moving Objects for Spatio-temporal Selectivity Estimation,' In ADC, pages 123-130, 2004
5 Choi, Y. and Chung, C., 'Selectivity Estimation for Spatio-Temporal Queries to Moving Objects,' In ACM SIGMOD, pages 440-451, 2002   DOI
6 Tao, Y., Sun, J., and Papadias, D., 'Selectivity Estimation for Predictive Spatio-Temporal Queries,' ICDE, pages 417-428, 2003
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   DOI
8 Nikos Mamoulis and Dimitris Papadias, 'Selectivity Estimation of Complex Spatial Queries,' In The 7th International Sysposium on Spatial and Temporal Databases (SSTD), CA, USA, pages 156-174, July 2001
9 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
10 Aboulnaga, A. and Naughton, J. 'Accurate Estimation of the Cost of Spatial Selections,' In ICDE, pages 123-134, 2000   DOI
11 Tao, Y. and Papadias, D., 'Time-Parameterized Queries in Spatio-Temporal Databases,' In Proceedings of ACM SIGMOD international conferences on Management of data, pages 334-345, 2002   DOI
12 Acharya, S., Poosala, V., and Ramaswamy, S., 'Selectivity Estimation in Spatial Databases,' In ACM SIGMOD, USA, pages 13-24, 1999   DOI
13 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