Spatio-temporal SQL

  • José R. Rios Viqueira
  • Nikos A. Lorentzos
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2563)


An extension of SQL is formalized for the management of spatio-temporal data, i.e. of spatial data that evolves with respect to time. The syntax and semantics of the extension is fully consistent with SQL. The formalism is very general, in that the extension can be applied to any kind of data, either temporal or spatial or conventional.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    L. Becker, A. Voigtmann and K.H. Hinrichs: “Temporal Support for Geo-data in Object-oriented Databases”, Springer LNCSVol.1134, pp.79–93, 1996.Google Scholar
  2. [2]
    S. Grumbach, P. Rigaux and L. Segoufin: “Spatio-temporal Data Handling with Constraints”, Proceedings 6th ACM-GIS Symposium, pp.106.111, 1998.Google Scholar
  3. [3]
    R.H. Güting, M.H. Böhlen, M. Erwig, C.S. Jensen, N.A. Lorentzos, M. Schneider and M. Vazirgiannis: “A Foundation for Representing and Querying Moving Objects”, ACM Transactions on Database Systems, Vol.25, No.1, pp.1–42, 2000.CrossRefGoogle Scholar
  4. [4]
    R. Laurini and D. Thompson: “Fundamentals of Spatial Information Systems”, Academic Press, New York, 1992.zbMATHGoogle Scholar
  5. [5]
    N.A. Lorentzos and Y.G. Mitsopoulos: “SQL Extension for Interval Data”, IEEE Transactions on Knowledge and Data Engineering, Vol.9, No.3, pp.480–499, 1997.CrossRefGoogle Scholar
  6. [6]
    N.A. Lorentzos, N. Tryfona and J.R. Rios Viqueira: “Relational Algebra for Spatial Data Management”, Proceedings Workshop Integrated Spatial Databases. Digital Images and GIS (1SD), pp.192–208, 2000.Google Scholar
  7. [7]
    J. Moreira, C. Ribeiro and J.-M. Saglio: “Representation and Manipulation of Moving Points: an Extended Data Model for Location Estimation”, Cartography and Geographic Information Science, Special Issue on Dealing with Time, Vol.26, No.2, pp.109–123, 1999.Google Scholar
  8. [8]
    P. Rigaux, M. Scholl and A. Voisard: “Spatial Databases: with Application to GIS”, Morgan Kaufmann, 2001.Google Scholar
  9. [9]
    T. Sellis: “Research Issues in Spatio-temporal Database Systems”, Proceedings 6th SSD Symposium, pp.5–11, 1999.Google Scholar
  10. [10]
    S. Shekhar, S. Chawla, S. Ravada, A. Fetterer, X. Liu, and C.-T. Lu: “Spatial Databases: Accomplishments and Research Needs”, IEEE Transactions on Knowledge and Data Engineering, Vol.11, No.1, pp.45–55, 1999.CrossRefGoogle Scholar
  11. [11]
    A. Sistla, O. Wolfton, S. Chamberlain and S. Dao: “Modeling and Querying Moving Objects”, Proceedings 13th IEEE ICDEE Conference, pp.422–433, 1997.Google Scholar
  12. [12]
    A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev and R. Snodgrass: “Temporal Databases: Theory, Design, and Implementation”, Benjamin/Cummings, 1993.Google Scholar
  13. [13]
    N. Tryfona and T. Hadzilacos: “Logical Data Modelling of Spatio-temporal Applications: Definitions and a Model”, Proceedings 1998 IDEAS Symposium, pp.14–23, 1998.Google Scholar
  14. [14]
    M.F. Worboys: “A Unified Model for Spatial and Temporal Information”, The Computer Journal, Vol.37, No.1, pp.27–34, 1994.CrossRefGoogle Scholar
  15. [15]
    M.F. Worboys: “GIS: a Computing Perspective”, Taylor&Francis, 1995.Google Scholar
  16. [16]
    T.-S. Yeh and B. de Cambray: “Managing Highly Variable Spatio-temporal Data”, Proceedings 6th Australiasian Database Conference, pp.221–230, 1995.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2003

Authors and Affiliations

  • José R. Rios Viqueira
    • 1
  • Nikos A. Lorentzos
    • 2
  1. 1.Computation DepartmentUniversity of A CoruniaA CoruniaSpain
  2. 2.Informatics LaboratoryAgricultural University of AthensAthensGreece

Personalised recommendations