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

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

A Hybrid Index based on Aggregation R-tree for Spatio-Temporal Aggregation

시공간 집계정보를 위한 Aggregation R-tree 기반의 하이브리드 인덱스

  • 유병섭 (인하대학교 컴퓨터.정보공학과) ;
  • 배해영 (인하대학교 컴퓨터.정보공학과)
  • Published : 2006.10.15
Download PDF
⟨ Previous Next ⟩

Abstract

In applications such as a traffic management system, analysis using a spatial hierarchy of a spatial data warehouse and a simple aggregation is required. Over the past few years, several studies have been made on solution using a spatial index. Many studies have focused on using extended R-tree. But, because it just provides either the current aggregation or the total aggregation, decision support of traffic policy required historical analysis can not be provided. This paper proposes hybrid index based on extended aR-tree for the spatio-temporal aggregation. The proposed method supports a spatial hierarchy and the current aggregation by the R-tree. The sorted hash table using the time structure of the extended aR-tree provides a temporal hierarchy and a historical aggregation. Therefore, the proposed method supports an efficient decision support with spatio-temporal analysis and is Possible currently traffic analysis and determination of a traffic policy with historical analysis.

교통 관리 시스템과 같은 응용에서는 공간 데이타 웨어하우스의 공간 계층을 이용한 분석을 수행하는데, 이러한 분석에서는 주로 단순한 집계정보만을 요구한다. 공간 계층 기반의 집계정보 제공을 위하여 기존의 연구들은 공간 인덱스를 사용한 해결방법을 제시하였는데, 대부분의 연구들은 공간 인덱스 중 가장 널리 이용되는 R-tree를 확장한 방법을 이용하였다. 그러나 단순히 현재 집계 정보만을 제공하여 수년에 걸친 분석을 요구하는 교통 정책에 대하여 의사결정을 지원할 수 없었다. 본 논문에서는 과거의 집계정보까지 관리할 수 있는 aR-tree(Aggregation R-tree)기반의 하이브리드 인덱스를 제안한다. 제안 기법은 aR-tree를 이용하여 공간 계층과 현재시점의 집계정보를 제공하며, 시간 구조체를 이용한 정렬 해쉬 테이블로 시간 계층과 과거의 집계정보를 제공한다. 따라서 제안기법은 시공간 분석을 통한 효율적인 의사결정을 지원하며, 이는 현재의 교통 분석 및 과거를 통한 교통 정책 결정을 가능하게 한다.

Keywords

References

  1. Eric Sperley, The Enterprise Data Warehouse: Planning, Building, and Implementation, Prentice Hall PTR, pp. 8-15, 1999
  2. ESRI, 'Spatial Data Warehousing for Hospital Organizations,' An ESRI White Paper, 1998. http://www.esri.com/library/whitepapers/pdfs/sdwho.pdf
  3. N. Stefanovic, J. Han, and K. Koperski, 'Object-Based Selective Materialization for Efficient Implementation of Spatial Data Cubes,' IEEE Transactions on Knowledge and Data Engineering, vol. 12(6), pp. 1-21, 2000 https://doi.org/10.1109/69.895803
  4. D. Papadias, P. Kalnis, J Zhang, and Y. Tao, 'Efficient OLAP Operations in Spatial Data Warehouses,' Technical Report: HKUST-CS0l-01, University of Science & Technology, Hon Kong, 2001
  5. I.S. Mumick, D. Quass, and B.S. Mumick. 'Maintenance of data cubes and summary tables in a warehouse,' In Proc. of ACM SIGMOD, Vo1.26, No.2, pp. 100-111, 1997 https://doi.org/10.1145/253262.253277
  6. Y. Tao and D. Papadias, 'Range Aggregate Processing in Spatial Databases,' IEEE Transactions on Knowledge and Data Engineering, vol. 16(12), pp. 1555-1570, 2004 https://doi.org/10.1109/TKDE.2004.93
  7. A. Guttman, 'R-trees: a dynamic index structure for spatial searching,' ACM SIGMOD, Vo1.14, No.2, pp. 47-57, 1984 https://doi.org/10.1145/602259.602266
  8. N. Beckmann, H. P. Kriegel, R. Schneider, and B. Seeger, 'The R*-tree: an efficient and robust access method for points and rectangles,' ACM SIGMOD, vol. 19, No.2, pp. 322-331 1990 https://doi.org/10.1145/93605.98741
  9. T. K. Sellis, N. Roussopoulos, and C. Faloutsos, 'The R+-Tree: A dynamic index for multidimensional objects,' VLDB, 1987
  10. R. A. Finkel, and J. L. Bentley, 'Quad trees: A data structure for retrieval on composite keys,' Acta Informatica, Vol. 4, pp. 1-9 1974 https://doi.org/10.1007/BF00288933
  11. L. Zhang, Y. Li, F. Rao, X. Yu, and Y. Chen, 'An approach to enabling spatial OLAP by aggregating on spatial hierarchy,' In Proc. Data Warehousing and Knowledge Discovery, pp. 35-44, 2003
  12. F. Rao, L. Zhang, X. L. Yu, Y. Li, and Y. Chen, 'Spatial Hierarchy and OLAP-Favored Search in Spatial Data Warehouse,' DOLAP, pp. 48-55, 2003 https://doi.org/10.1145/956060.956070
  13. J. Han, N. Stefanovic, and K. Koperski, 'Selective Materialization: An Efficient Method for Spatial Data Cube Construction,' In Research and Deve-lopment in Knowledge Discovery and Data Mining, pp. 144-158, 1998
  14. W. H. Inmon, Building the Data Warehouse, 3rd Ed., John Wiley & Sons. Inc, 1996
  15. J. Gray, A. Bosworth, A. Layman, and H. Pirahesh, 'Data Cube: a Relational Aggregation Operator Generalizing Group-by,' In Proc. 12th ICDE, pp. 152-159, 1996 https://doi.org/10.1109/ICDE.1996.492099
  16. V. Harinarayan, A. Rajaraman, and J. Ullman, 'Implementing Data Cubes Efficiently,' ACM SIGMOD, Vol.25, No.2, pp. 205-216, 1996 https://doi.org/10.1145/235968.233333