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).
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
L. Becker, A. Voigtmann and K.H. Hinrichs: “Temporal Support for Geo-data in Object-oriented Databases”, Springer LNCSVol.1134, pp.79–93, 1996.
S. Grumbach, P. Rigaux and L. Segoufin: “Spatio-temporal Data Handling with Constraints”, Proceedings 6th ACM-GIS Symposium, pp.106.111, 1998.
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.
R. Laurini and D. Thompson: “Fundamentals of Spatial Information Systems”, Academic Press, New York, 1992.
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.
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.
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.
P. Rigaux, M. Scholl and A. Voisard: “Spatial Databases: with Application to GIS”, Morgan Kaufmann, 2001.
T. Sellis: “Research Issues in Spatio-temporal Database Systems”, Proceedings 6th SSD Symposium, pp.5–11, 1999.
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.
A. Sistla, O. Wolfton, S. Chamberlain and S. Dao: “Modeling and Querying Moving Objects”, Proceedings 13th IEEE ICDEE Conference, pp.422–433, 1997.
A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev and R. Snodgrass: “Temporal Databases: Theory, Design, and Implementation”, Benjamin/Cummings, 1993.
N. Tryfona and T. Hadzilacos: “Logical Data Modelling of Spatio-temporal Applications: Definitions and a Model”, Proceedings 1998 IDEAS Symposium, pp.14–23, 1998.
M.F. Worboys: “A Unified Model for Spatial and Temporal Information”, The Computer Journal, Vol.37, No.1, pp.27–34, 1994.
M.F. Worboys: “GIS: a Computing Perspective”, Taylor&Francis, 1995.
T.-S. Yeh and B. de Cambray: “Managing Highly Variable Spatio-temporal Data”, Proceedings 6th Australiasian Database Conference, pp.221–230, 1995.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights 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