Journal of KIISE:Databases (한국정보과학회논문지:데이타베이스)

Korean Institute of Information Scientists and Engineers (한국정보과학회)
권호 표지

On Efficient Processing of Multidimensional Temporal Aggregates In Temporal Databases

시간지원 데이타베이스에서 다차원 시간 집계 연산의 효율적인 처리 기법

  • 강성탁 (한국과학기술원 전산학전공) ;
  • 정연돈 (한국과학기술원 전산학전공) ;
  • 김명호 (한국과학기술원 전산학전공)
  • Published : 2002.12.01
Download PDF
⟨ Previous Next ⟩

Abstract

Temporal databases manage time-evolving data. They provide built-in supports for efficient recording and querying of temporal data. The temporal aggregate in temporal databases is an extension of the conventional aggregate to include time concept on the domain and range of aggregation. This paper focuses on multidimensional temporal aggregation. In a multidimensional temporal aggregate, we use one or more general attributes as well as a time attribute on the range of aggregation, thus it is a useful operation for historical data warehouse, Call Data Records(CDR), etc. In this paper, we propose a structure for multidimensional temporal aggregation, called PTA-tree, and an aggregate processing method based on the PTA-tree. Through analyses and performance experiments, we also compare the PTA-tree with the simple extension of SB-tree that was proposed for temporal aggregation.

시간지원 데이타베이스 시스템은 자료의 과거 및 현재, 그리고 미래의 상태까지 관리함으로써, 사용자에게 시간에 따라 변화하는 자료에 대한 저장 및 질의 수단을 제공한다. 시간지원 데이터베이스에서의 집계 연산은 집계 연산과 질의에 시간 애트리뷰트를 고려하므로 기존의 집계 연산과는 큰 차이가 있다. 본 논문에서는 다차원 시간 집계 연산에 초점을 둔다. 다차원 시간 집계 연산은 시간 애트리뷰트 뿐만 아니라 하나 이상의 일반 애트리뷰트까지 고려한 시간 집계 연산으로 이력 데이타 웨어 하우스, 전화 기록 관리(CBR) 등에 유용하다. 본 논문에서는 다차원 시간 집계 연산을 효율적으로 처리하기 위한 자료 구조인 PTA-tree를 제안하고, 이를 이용한 시간 집계 처리 기법을 제안한다. 또한 본 논문에서는 제안된 PTA-tree를 이용한 기법과 기존의 SB-tree를 확장한 기법의 성능을 최악 경우 분석과 실험을 통해 비교한다.

Keywords

References

  1. H.Gregersen, and C.S,Jensen. Temporal Entity-Relationship Models - A Survey. Technical Report R-96-2039, Aalborg University, 1996
  2. J,S.Kim and M.H.Kim, An Effective Data Clustering Measure for Temporal Selection and Projection Queries, Decision Support Systems, 30(1), p33-50, Elsevier Science, 2000 https://doi.org/10.1016/S0167-9236(00)00088-9
  3. M.D.Soo, R.T.Snodgrass, and C.S.Jensen. Efficient Evaluation of the Valid-Time Natural Join. Proceedings of the International Conference on Data Engineering, 1994 https://doi.org/10.1109/ICDE.1994.283042
  4. B.Salzberg, and V.J.Tsotras. A Comparison of Access Methods for Time Evolving Data. ACM Computing Surveys, 1997 https://doi.org/10.1145/319806.319816
  5. P.A.Tuma. Implementing Historical Aggregates in TempIS. Master's Thesis, Wayne State University, Nov. 1992
  6. C.Dyreson, W.Evans, H.Lin and R.T.Snodgrass, Efficiently supporting Temporal Granularities. IEEE Transactions on Knowledge and Data Engineering, Vol. 12, No.4, pages 568-587, 2000 https://doi.org/10.1109/69.868908
  7. N.Kline, and R.T.Snodgrass. Computing Temporal Aggregates. International Conference on Database Engineering, pages 222-231, 1995 https://doi.org/10.1109/ICDE.1995.380389
  8. B.Moon, I.F.V.Lopez and V.Immanuel. Efficient Algorithms for Large Temporal Aggregation. IEEE Transactions on Knowledge and Data Engineering, 2002 https://doi.org/10.1109/TKDE.2003.1198403
  9. J,S.Kim, S.T.kang and M.H.Kim, On Temporal Aggregate Processing based on Time Points, Journal of Korea Information Science Society (KISS), p.1418-1427, Vol.26, No.12, 1999
  10. J.Yang and J.Widom, Incremental Computation and Maintenance of Temporal Aggregates. International Conference on Data Engineering, pages 51-60, 2001 https://doi.org/10.1109/ICDE.2001.914813
  11. D.Zhang, A.Markowetz, V.Tsotras, D.Gunopulos and B.Seeger, Efficient Computation of Temporal Aggregates with Range Predicates, A Time Center Technical Report TR-52, Dec 2000
  12. J.Gray. The Benchmark Handbook for Database and Transaction Processing Systems. Morgan Kaufmann, 1991
  13. R.T.Snodgrass, I.Ahn, G.Ariav, and et al. The TSQL2 Temporal Query Language. Kluwer Academic Publishers, 1995
  14. R.Epstein. Techniques for Processing of Aggregates in Relational Database Systems. UCB/ERL M7918, Feb 1979
  15. R.T.Snodgrass, S.Gomez and L.E.McKlenzie. Aggregates in the temporal query language TQuel. IEEE Transaction on Knowledge and Data Engineering, Vol. 5, No.5, pages 826-842, October 1993 https://doi.org/10.1109/69.243512
  16. V.Gaede and O.Gunther. Multidimensional Access Methods. ACM Computing Surveys, Vol. 30, Issue. 2, pages 170-231, 1998 https://doi.org/10.1145/280277.280279
  17. F.Ramsak, V.Markl, R.Fenk and et al. Integrating the UB-tree into a Database System Kernel. International Conference on Very Large Databases, pages 263-272, 2000