Skip to main content

Spatio-temporal SQL

  • Conference paper
  • First Online:
Advances in Informatics (PCI 2001)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 2563))

Included in the following conference series:

Abstract

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.

This work has been supported by the European Union, TMR Project CHOROCHRONOS (FMRX-CT96-0056).

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  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. 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. 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.

    Article  Google Scholar 

  4. R. Laurini and D. Thompson: “Fundamentals of Spatial Information Systems”, Academic Press, New York, 1992.

    MATH  Google Scholar 

  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.

    Article  Google Scholar 

  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. 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. P. Rigaux, M. Scholl and A. Voisard: “Spatial Databases: with Application to GIS”, Morgan Kaufmann, 2001.

    Google Scholar 

  9. T. Sellis: “Research Issues in Spatio-temporal Database Systems”, Proceedings 6th SSD Symposium, pp.5–11, 1999.

    Google Scholar 

  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.

    Article  Google Scholar 

  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. 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. 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. M.F. Worboys: “A Unified Model for Spatial and Temporal Information”, The Computer Journal, Vol.37, No.1, pp.27–34, 1994.

    Article  Google Scholar 

  15. M.F. Worboys: “GIS: a Computing Perspective”, Taylor&Francis, 1995.

    Google Scholar 

  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 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2003 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Viqueira, J.R.R., Lorentzos, N.A. (2003). Spatio-temporal SQL. In: Manolopoulos, Y., Evripidou, S., Kakas, A.C. (eds) Advances in Informatics. PCI 2001. Lecture Notes in Computer Science, vol 2563. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-38076-0_4

Download citation

  • DOI: https://doi.org/10.1007/3-540-38076-0_4

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-07544-8

  • Online ISBN: 978-3-540-38076-4

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics