A Spatio-temporal Database System Based on TimeDB and Oracle Spatial

  • Alexandre Carvalho
  • Cristina Ribeiro
  • A. Augusto Sousa
Part of the IFIP International Federation for Information Processing book series (IFIPAICT, volume 205)


The importance of the spatial component of data items has been long recognized and gave rise to a successful line of research and development in Geographic Information Systems (GIS). In many application domains it is also essential to deal with the evolution of data along time and to integrate spatial, temporal and other aspects of the information domain in an expressive and operationally effective manner. Until recently, temporal solutions provided by spatial database systems were semi-temporal approaches lacking full temporal support. As a consequence, most spatial database systems manage snapshots of the present state of facts without fully exploiting historical temporal aspects. This paper provides preliminary results on a spatiotemporal database implementation. The proposed system builds on existing database technologies, TimeDB and Oracle Spatial, for temporal and spatial support, respectively. The justification for the choice of these technologies is given, based on the state of the art in spatial and temporal database research. The integration of the spatial and temporal components is achieved with the extension of the TimeDB implementation layer. A set of goals has been established in order to cover both the integration of the spatial support and the enforcement of the temporal requirements in the extended system. Issues and solutions are presented and illustrative examples show the use of the implemented functionalities.


Geographic Information System Temporal Database Temporal Support Spatial Support Enterprise Information System 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


  1. 1.
    C. Date, An Introduction to Database Systems, 7th edition (Addison-Wesley Chapter 22, 2000), pp. 730–768.Google Scholar
  2. 2.
    R. Snodgrass, M. Böhlen, C. Jensen, A. Steiner, Adding Valid Time to SQL/Temporal, SQL/Temporal Change Proposal, ANSI X3H2-96-501r2, ISO/IEC JTC1/SC21/WG3 DBL MAD-146r2, 1996.Google Scholar
  3. 3.
    C. Jensen, Temporal Database Management, PhD, 2000.Google Scholar
  4. 4.
    R. Snodgrass, M. Böhlen, C. Jensen, A. Steiner, Adding Transaction time to SQL/Temporal, SQL/Temporal Change Proposal, ANSI X3H2-96-502r2, ISO/IEC JTC1/SC21/WG3 DBLMAD-147r2, 1996.Google Scholar
  5. 5.
    A. Steiner, A Generalization Approach to temporal Data Models and Their Implementations, PhD, Zurich, 1998.Google Scholar
  6. 6.
    R. Bastos, Autonomic Computing Approach for Resource Allocation, Expert Systems with Applications 28, 9–19 (2005).CrossRefGoogle Scholar
  7. 7.
    M. Dumas, C. Fauvet, P. Scholl, TEMPOS: A Temporal Database Model Seamless Extending ODMG, LSR-IMAG, University of Grenoble, PhD, 2000.Google Scholar
  8. 8.
    Oracle Corporation, Oracle Spatial 9.0.1-User’s Guide and Reference, June 2001. Oracle Corporation, Oracle 9i, Application Developer’s Guide-Object-Relational Features, March 2002.Google Scholar
  9. 9.
    M. BGhlen, C. Jensen, R. Snodgrass, Evaluating the completeness of TSQL2, Recent Advances in Temporal Databases, J. Clifford and A. Tuzhilin, 1995.Google Scholar
  10. 10.
    T. Griffiths, A. Fernandes, N. Paton, S. Jeong, N. Djafri, Tripod: A Spatio-Historical Object Database System, Mining Spatio-Temporal Information Systems, The Kluwer International Series in Engineering and Computer Science: Volume 699, 2002, pp. 127–146.Google Scholar
  11. 11.
    M. Bohlen, Temporal Database System Implementations, SIGMOD Record 24(4), (1995).Google Scholar
  12. 12.
    C. Medeiros, F. Pires, Databases for GIS, SIGMOD 23(1), (1994).Google Scholar
  13. 13.
    C. Vassilakis, P. Georgiadis, A. Sotiropoulou, A Comparative Study of Temporal DBMS Architectures, DEXA, 1996, pp. 153–164.Google Scholar
  14. 14.
    K. Torp, C. Jensen, M. Böhlen, Layered Implementation of Temporal DMBSs — Concepts and Techniques, Time Center Technical Report, 1997.Google Scholar
  15. 15.
    J. Allen, Maintaining Knowledge about Temporal Intervals, Communications of the ACM 16(11), 832–843 (1983).CrossRefGoogle Scholar

Copyright information

© International Federation for Information Processing 2006

Authors and Affiliations

  • Alexandre Carvalho
    • 1
  • Cristina Ribeiro
    • 1
  • A. Augusto Sousa
    • 1
  1. 1.FEUP / INESC PortoPortoPortugal

Personalised recommendations