Abstract
We address a fundamental question concerning spatio-temporal database systems: “What are exactly spatio-temporal queries?” We define spatio-temporal queries to be computable mappings that are also generic, meaning that the result of a query may only depend to a limited extent on the actual internal representation of the spatio-temporal data. Genericity is defined as invariance under transformations that preserve certain characteristics of spatio-temporal data (e.g., collinearity, distance, velocity, acceleration,...) that are relevant to a database user. These transformations also respect the monotone nature of time.
We investigate different genericity classes relative to the constraint database model for spatio-temporal databases and we identify sound and complete languages for the first-order, respectively the computable, queries in these genericity classes.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
D. Abel and B. C. Ooi (eds.), Advances in spatial databases— 3rd Symposium (SSD’93), Lecture Notes in Computer Science, vol. 692, Springer-Verlag, 1993.
J. F. Allen, Maintaining knowledge about temporal intervals, Communications of the ACM 26 (1983), no. 11, 832–843.
J. F. Allen and G. Ferguson, Actions and events in interval temporal logic, Journal of Logic and Computation 4 (1994), no. 5, 531–579.
M. H. Böhlen, Ch. S. Jensen, and M. Scholl (eds.), Proceedings of the international workshop on spatio-temporal database management (STDBM’99), Lecture Notes in Computer Science, vol. 1678, Springer, 1999.
A. Buchmann (ed.), Design and implementation of large spatial databases—1st Symposium (SSD’89), Lecture Notes in Computer Science, vol. 409, Springer-Verlag, 1989.
A. K. Chandra and D. Harel, Computable queries for relational data bases, Journal of Computer and System Sciences 21 (1980), no. 2, 156–178.
C. X. Chen and C. Zaniolo, SQLST: A spatio-temporal data model and query language, Conceptual Modeling (ER’00) (V. Storey, A. Laender, S. Liddle, eds.), Lecture Notes in Computer Science, vol. 1920, Springer-Verlag, 2000, pp. 96–111.
J. Chomicki and P. Revesz, Constraint-based interoperability of spatio-temporal databases, inA. Voisard (eds.), Advances in spatial databases—5th Symposium(SSD’97), Lecture Notes in Computer Science, vol. 1262, Springer-Verlag, 1997 [26], pp. 142–161.
J. Chomicki and P. Revesz, A geometric framework for specifying spatiotemporal objects, Proceedings of the 6th International Workshop on Temporal Representation and Reasoning, IEEE Computer Society, 1999, pp. 41–46.
M. J. Egenhofer and J. R. Herring (eds.), Advances in spatial databases—4th Symposium (SSD’95), Lecture Notes in Computer Science, vol. 951, Springer-Verlag, 1995.
M. Erwig, R. H. Güting, M. Schneider, and M. Vazirgiannis, Spatio-temporal data types: An approach to modeling and querying moving objects in databases, GeoIn-formatica 3 (1999), no. 3, 269–296.
A. Frank, S. Grumbach, R. Güting, C. Jensen, M. Koubarakis, N. Lorentzos, Y. Manopoulos, E. Nardelli, B. Pernici, H.-J. Schek, M. Scholl, T. Sellis, B. Theodoulidis, and P. Widmayer, Chorochronos: A research network for spa-tiotemporal database systems, SIGMOD Record 28 (1999), 12–21.
S. Grumbach, P. Rigaux, and L. Segoufin, Spatio-temporal data handling with constraints, Proceedings of the 6th international symposium on Advances in Geographic Information Systems (ACM-GIS’98) (R. Laurini, K. Makki, and N. Pissi-nou, eds.), 1998, pp. 106–111.
O. Gunther and H.-J. Schek (eds.), Advances in spatial databases—2nd Symposium (SSD’ 91), Lecture Notes in Computer Science, vol. 525, Springer-Verlag, 1991.
R. H. Güting, M. H. Bohlen, M. Erwig, C. S. Jensen, N. A. Lorentzos, M. Schneider, and M. Vazirgiannis, A foundation for representing and querying moving objects, ACM Transactions on Databases Systems 25 (2000), 1–42.
R.H. Güting (ed.), Advances in spatial databases—6th Symposium (SSD’99), Lecture Notes in Computer Science, vol. 1651, Springer-Verlag, 1999.
M. Gyssens, J. Van den Bussche, and D. Van Gucht, Complete geometric query languages, Journal of Computer and System Sciences 58 (1999), no. 3, 483–511.
P. C. Kanellakis, G. M. Kuper, and P.Z. Revesz, Constraint query languages, Journal of Computer and System Sciences 51 (1995), 26–52 (also in Proceedings of the 9th ACM Symposium on Principles of Database Systems (PODS’90), ACM Press, 1990, pp. 299–313).
B. Kuijpers and D. Van Gucht, Genericity in spatial databases, Chapter 12 inG. Kuper, and L. Libkin (eds.), Constraint databases, Springer-Verlag, 2000 [24], pp. 293–304.
B. Kuijpers, J. Paredaens, and D. Van Gucht, Towards a theory of movie database queries, Proceedings of the 7th International Workshop on Temporal Representation and Reasoning, IEEE Computer Society, 2000, pp. 95–102.
G. Kuper and M. Scholl, Geographic information systems, Constraint databases (J. Paredaens, G. Kuper, and L. Libkin, eds.), Springer-Verlag, 2000, pp. 175–198.
L. Libkin, Variable independence, quantifier elimination, and constraint representation, Automata, Languages and Programming, 27th International Colloquium (ICALP 2000) (U. Montanari, J. D. P. Rolim, and E. Welzl, eds.), Lecture Notes in Computer Science, vol. 1853, Springer-Verlag, 2000, pp. 260–271.
J. Paredaens, J. Van denBussche, and D. Van Gucht, Towards a theory of spatial database queries, Proceedings of the 13th ACM Symposium on Principles of Database Systems (PODS’94), ACM Press, 1994, pp. 279–288.
J. Paredaens, G. Kuper, and L. Libkin (eds.), Constraint databases, Springer-Verlag, 2000.
D. Pfoser and N. Tryfona, Requirements, definitions and notations for spatiotemporal application environments, Proceedings of the 6th International Symposium on Advances in Geographic Information Systems (ACM-GIS’98) (R. Laurini, K. Makki, and N. Pissinou, eds.), 1998, pp. 124–130.
M. Scholl and A. Voisard (eds.), Advances in spatial databases—5th Symposium (SSD’97), Lecture Notes in Computer Science, vol. 1262, Springer-Verlag, 1997.
W. Schwabhäuser, W. Szmielew, and A. Tarski, Metamathematische methoden in der geometrie, Springer-Verlag, 1983.
J. Van den Bussche, Constraint databases, queries and query languages, Chapter 2 inG. Kuper, and L. Libkin (eds.), Constraint databases, Springer-Verlag, 2000 [24], pp. 21–54.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Geerts, F., Haesevoets, S., Kuijpers, B. (2002). A Theory of Spatio-temporal Database Queries. In: Ghelli, G., Grahne, G. (eds) Database Programming Languages. DBPL 2001. Lecture Notes in Computer Science, vol 2397. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-46093-4_12
Download citation
DOI: https://doi.org/10.1007/3-540-46093-4_12
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-44080-2
Online ISBN: 978-3-540-46093-0
eBook Packages: Springer Book Archive