Skip to main content

Spatio-temporal Query Languages

  • Reference work entry
Encyclopedia of GIS

Synonyms

Spatio-temporal data models; SQL/MM; SQL/Temporal; Operator, spatial; Operator, temporal; Bi-temporal; ISO; Operator, topological; Operator, metric

Definition

A spatio-temporal database is a database that embodies spatial, temporal and spatio-temporal database concepts and captures simultaneously spatial and temporal aspects of data. Spatio‐temporal databases allow sophisticated queries over time and space to be stated [6]. Spatio‐temporal query languages are the query languages used to query spatio‐temporal databases.

Though we could use the basic data types in SQL to represent spatio‐temporal data, however, the queries would be very complicated to write. In some cases, we may not be able to answer some queries. For example, assume there is a traveler. If we use date to represent the start and end of a time interval while the person remains at the same place, and two floating point numbers to represent the coordinates of a point in a two‐dimensional space which is the...

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

Access this chapter

Institutional subscriptions

Recommended Reading

  1. Allen, J.F.: Maintaining knowledge about temporal intervals. In: Communications of the ACM, 26(11), pp. 832–843. ACM Press, New York, NY, USA (1983)

    Google Scholar 

  2. Cai, M., Keshwani, D., Revesz, P.Z.: Parametric Rectangles: A Model for Querying and Animation of Spatiotemporal Databases. In: Proceedings of the 7th International Conference on Extending Database Technology, pp. 430–444. Konstanz, Germany (2000)

    Google Scholar 

  3. Chomicki, J., Revesz, P.Z.: Constraint-Based Interoperability of Spatiotemporal Databases. In: Scholl, M., Voisard, A. (eds.) Advances in Spatial Databases, pp. 142–161. Springer‐Verlag, Berlin, Heidelberg, New York (1997)

    Chapter  Google Scholar 

  4. Chen, C.X., Zaniolo, C.: SQLST: A Spatio‐temporal Data Model and Query Language. In: Proceedings of the 19th International Conference on Conceptual Modeling, pp. 96–111. Salt Lake City, Utah, USA (2000)

    Google Scholar 

  5. Chen, C.X., Wang, H., Zaniolo, C.: Toward Extensible Spatio‐temporal Databases: an approach based on User-Defined Aggregates. In: de Caluwe, R., et al.(eds.) Spatio‐temporal Databases: Flexible Querying And Reasoning, pp. 55–74. Springer, Berlin, Heidelberg, New York (2004)

    Chapter  Google Scholar 

  6. Erwig, M., Schneider, M.: Spatio‐temporal Predicates. In: Transactions on Knowledge and Data Engineering, vol.14, No.4, pp. 881–901. IEEE Educational Activities Department, Piscataway, NY, USA (2002)

    Article  Google Scholar 

  7. Forlizzi, L., Guting, R.H., Nardelli, E., Schneider, M.: A Data Model and Data Structures for Moving Objects Databases. In: Proceedings of ACM-SIGMOD International Conference on Management of Data, pp. 319–330. Dallas, Texas, USA (2000)

    Google Scholar 

  8. Güting, R.H., Böhlen, M.H., Erwig, M., Jensen, C.S., Lorentzos, N.A., Schneider, M., Vazirgiannis, M.: A Foundation for Representing and Querying Moving Object. In: ACM Transactions on Database Systems, Vol.25, No.1, pp. 1–42. ACM Press, New York, NY, USA (2000)

    Google Scholar 

  9. Güting, R.H., Böhlen, M.H., Erwig, M., Jensen, C.S., Lorentzos, N.A., Nardelli, E., Schneider, M., Viqueira, J.R.R.: Spatio‐temporal Models and Languages: An Approach Based on Data Types. In: Sellis, T., et al.(eds.) Spatio‐temporal Databases: The CHOROCHRONOS Approach, LNCS 2520, pp. 117–176. Springer, Berlin, Heidelberg, New York (2003)

    Google Scholar 

  10. Herring, J.R.(eds.): OpenGIS Implementation Specification for Geographic Information – Simple Feature Access. http://www.opengeospatial.org/standards/sfs (2006). Accessed 30 Aug 2007

  11. Khatri, V., Ram, S., Snodgrass, R.T.: On Augmenting Database Design‐Support Environments to Capture the Geo-Spatio‐temporal Data Semantics. In: Information Systems, Vol.31, No.2, pp. 98–133. Elsevier Science Ltd., Oxford, UK (2006)

    Google Scholar 

  12. Laurini, R., Thompson, D.: Fundamentals of Spatial Information Systems. Academic Press, London, UK (1992)

    MATH  Google Scholar 

  13. Stolze, K.: SQL/MM Spatial – The Standard to Manage Spatial Data in a Relational Database System. In: Datenbanksysteme für Business, Technologie und Web, Tagungsband der 10, pp. 247–264. Leipzig, Germany (2003)

    Google Scholar 

  14. Worboys, M.F.: A Unified Model for Spatial and Temporal Information. In: Computer Journal, Vol.37, No.1, pp. 26–34. Oxford University Press, Oxford, UK (1994)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2008 Springer-Verlag

About this entry

Cite this entry

Chen, C. (2008). Spatio-temporal Query Languages. In: Shekhar, S., Xiong, H. (eds) Encyclopedia of GIS. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-35973-1_1332

Download citation

Publish with us

Policies and ethics