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...
Recommended Reading
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)
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)
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)
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)
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)
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)
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)
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)
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)
Herring, J.R.(eds.): OpenGIS Implementation Specification for Geographic Information – Simple Feature Access. http://www.opengeospatial.org/standards/sfs (2006). Accessed 30 Aug 2007
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)
Laurini, R., Thompson, D.: Fundamentals of Spatial Information Systems. Academic Press, London, UK (1992)
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)
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)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights 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
DOI: https://doi.org/10.1007/978-0-387-35973-1_1332
Publisher Name: Springer, Boston, MA
Print ISBN: 978-0-387-30858-6
Online ISBN: 978-0-387-35973-1
eBook Packages: Computer ScienceReference Module Computer Science and Engineering