ETRI Journal

  • 제24권3호
  • /
  • Pages.226-238
  • /
  • 2002
  • /
  • 1225-6463(pISSN)
  • /
  • 2233-7326(eISSN)
한국전자통신연구원 (Electronics and Telecommunications Research Institute)
권호 표지

Integrating Spatial and Temporal Relationship Operators into SQL3 for Historical Data Management

  • Lee, Jong-Yun (Department of Information and Communication Engineering at Samchok National University)
  • 투고 : 2001.05.29
  • 발행 : 2002.06.30
PDF 다운로드
⟨ 이전 논문 다음 논문 ⟩

초록

A spatial object changes its states over time. However, existing spatial and temporal database systems cannot fully manage time-varying data with both spatial and non-spatial attributes. To overcome this limitation, we present a framework for spatio-temporal databases that can manage all time-varying historical information and integrate spatial and temporal relationship operators into the select statement in SQL3. For the purpose of our framework, we define three referencing macros and a history aggregate operator and classify the existing spatial and temporal relationship operators into three groups: exclusively spatial relationship operators, exclusively temporal relationship operators, and spatio-temporal common relationship operators. Finally, we believe the integration of spatial and temporal relationship operators into SQL3 will provide a useful framework for the history management of time-varying spatial objects in a uniform manner.

키워드

참고문헌

  1. GIS: A Computing Perspective Worboys, M.F.
  2. GIS/LIS Proc. v.2 Temporal GIS Prototype for Global Change Research Beller, A.;Giblin, T.;Le, K.V.;Litz, S.;Kittel, T.;Schimel, D.
  3. Temporal Geographical Information Systems Technology and Requirements: Where we are today Montgomery, L.D.
  4. Temporal Maps and Temporal Geographical Information Systems Renolen, A.
  5. The 3rd Int’l Conf./Workshop Integrating GIS and Environmental Modeling Temporal GIS and Spatio-Temporal Modeling Yuan, M.
  6. Recent Advances in Temporal Databases, Workshops in Computing Series Managing Time in GIS: An Event-Oriented Approach Claramunt, C.;Clifford, J.(ed.);Tuzhilin, A.(ed.)
  7. Int’l J. of Geographic Information systems v.3 no.3 Modeling the Temporal Element in and Land Information Systems Price, S.
  8. Proc. ACM SIGMOD A Data Model and Query Language for EXODUS Carey, J.M.;Dewiit, D.J.;Vandenberg, S.L.
  9. IEEE Trans. on Knowledge and Data Engineering v.6 no.1 Spatial SQL: A Query and Presentation Language Egenhofer, M.J.
  10. Proc. of the Fifteenth Int’l Conf. on Very Large Data Bases Gral: An Extensible Relational Database System for Geometric Applications Guting, R.H.
  11. Advances in Spatial Databases, 2nd Symposium, SSD '91 Exploiting Extensible DBMS in Integrated Geographic Information Systems Haas, L.M.;Cody, W.F.
  12. IEEE Trans. on Knowledge and Data Engineering v.2 no.1 The Implementation of POSTGRES Stonebraker, M.;Rowe, L.;Hirohama, M.
  13. IEEE Trans. on Software Engineering v.14 no.5 Probe Spatial Database Application Orenstein, J.;Manola, F.
  14. IEEE Trans. on Software Engineering v.14 no.5 An Efficient Pictorial Database System for PSQL Roussopoulos, N.;Faloutsos, C.;Sellis, T.
  15. The TSQL2 Temporal Query Language Snodgrass, R.T.
  16. Information Systems v.11 no.4 Adding Time Dimension to Relational Model and Extending Relational Algebra Tansel, A.U.
  17. The TSQL2 Temporal Query Language Snodgrass, R.T.
  18. Information Systems v.9 no.1 An Event-Based Spatiotemporal Data Model (ESTDM) for Temporal Analysis of Geographical Data Peuquet, D.;Duan, N.
  19. IEEE Trans. on Knowledge and Data Engineering v.9 no.3 SQL Extension for Interval Data Lorentzos, N.A.;Mitsopoulos, Y.G.
  20. The Computer J. v.37 no.1 A Unified Model for Spatial and Temporal Information Worboys, M.F.
  21. CIKIM'94 A Pattern Matching Language for Spatio-Temporal Databases Cheng, T.S.;Gadia, S.K.
  22. The Trans. of the Korea Information Processing Society v.5 no.9 A Historical Extension for SDE Data Model Lee, J.Y.;Ahn, B.I.;Ryu, K.H.
  23. The Int’l Association of Management 16th Annual Conf. SQL Unification of Spatiotemporal Operations for AVLS: SQL/ST Lee, J.Y.;Lee, S.J.;Ryu, K.H.
  24. Spatio-Temporal Database Support for Legacy Applications, A Time Center Technical Report TR-20 Bohlen, M.;Jensen, C.S.;Skjellaug, B.
  25. British Columbia Specification and Guidelines for Geomatics. Reference Series Volume 1: Spatial Archive and Interchange Format: SAIF Formal Definition, Release 3.1 Province of British Columbia, Ministry of Environment, Lands and Parks, Surveys and Resource Mapping Branch
  26. Logical Data Modeling of Spatio-Temporal Applications: Definitions and a Model, CHOROCHRONOS, Technical Report CH-97-03 Tryfona, N.;Hadzilacos, T.
  27. Temporal and Spatio-Temporal Data Models and Their Expressive Power, CHOROCHRONOS, Technical Report CH-97-10 Erwig, M.;Scheider, M.;Guting, R.H.
  28. ETRI J. v.22 no.3 TATS: an Efficient Technique for Computing Temporal Aggregates for Data Warehousing Shin, Young-Ok(et al.)
  29. A Data Model for Information with Spatial and Bitemporal Components, Technical Report TR93-06 Worboys, M.F.
  30. Comm. of the Association of Computing Machinery v.26 no.11 Maintaining Knowledge about Temporal Intervals Allen, J.F.
  31. Proc. Int’l Symposium On Spatial Data Handling (SDH) Modeling Topologic Relationships in Vector Maps Molenaar, M.;Kufoniyi, O.;Bouloucos, T.
  32. Introduction to $SDE^{TM}$ Environmental Systems Research Institute, Inc.