Selectivity Estimation for Timestamp Queries

시점 질의를 위한 선택율 추정

  • Published : 2006.04.01

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.

최근 시간에 따른 대량의 공간 객체들의 효과적인 저장과 처리의 필요성이 요구되면서 시공간 데이타베이스에 대한 필요성이 증가하였다. 이러한 시공간 데이타베이스에서 효과적인 질의 처리를 위하여 여러 가지 질의 최적화 기법이 연구되었고 그중 질의의 근사적인 결과를 계산하는 선택도 추정 기법이 활발하게 연구되었다. 선택도 추정 기법에는 샘플링 기반 기법, 히스토그램 기반 기법, 웨이블릿 기반 기법 등이 있고 그중 히스토그램 기법은 현재 상용 데이타베이스에서 널리 사용되고 있다. 하지만 지금까지의 시공간 질의 최적화 연구는 이동 객체의 미래 위치에 대한 선택도 추정에 치중되어 왔다. 본 논문에서는 과거의 시공간 데이타의 질의 최적화를 위하여 새로운 히스토그램인 T-Minskew의 구축 방법을 제안한다. 또한 T-Minskew를 이용한 효과적인 선택도 추정 기법을 제안하고 임계치 기법을 이용한 히스토그램의 효과적인 유지 기법을 통해 잦은 히스토그램 재구축을 방지하고 작은 추정 오류율을 유지하는 방법을 제안한다.

Keywords

References

  1. 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
  2. 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 https://doi.org/10.1145/564691.564730
  3. Acharya, S., Poosala, V., and Ramaswamy, S., 'Selectivity Estimation in Spatial Databases,' In ACM SIGMOD, USA, pages 13-24, 1999 https://doi.org/10.1145/304182.304184
  4. Aboulnaga, A. and Naughton, J. 'Accurate Estimation of the Cost of Spatial Selections,' In ICDE, pages 123-134, 2000 https://doi.org/10.1109/ICDE.2000.839399
  5. 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 https://doi.org/10.1145/233269.233342
  6. 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
  7. 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
  8. Choi, Y. and Chung, C., 'Selectivity Estimation for Spatio-Temporal Queries to Moving Objects,' In ACM SIGMOD, pages 440-451, 2002 https://doi.org/10.1145/564691.564742
  9. Tao, Y., Sun, J., and Papadias, D., 'Selectivity Estimation for Predictive Spatio-Temporal Queries,' ICDE, pages 417-428, 2003
  10. 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 https://doi.org/10.1109/SSDM.2003.1214981
  11. Zhan, Q. and Lin, X., 'Clustering Moving Objects for Spatio-temporal Selectivity Estimation,' In ADC, pages 123-130, 2004
  12. 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 https://doi.org/10.1145/276305.276344
  13. 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 https://doi.org/10.1145/304181.304200