Abstract
Although many spatio-temporal conceptual models has been proposed in the last years, users must express their queries on the underlying physical data structures. In the context of the European project MurMur we developed a Query Editor tool that allows the creation of queries visually from the conceptual schema as well as the visualization of the query result. In this paper we describe the Query Translator module that is in charge of transforming the queries expressed for the conceptual schema into an operational query for a target DBMS or GIS (e.g., an SQL query or a PL/SQL program). It is composed of a Transformation module that translates a conceptual query into an equivalent logical query using only the concepts provided by the target software, and a Wrapper module that expresses the query in the Data Manipulation Language of the target platform.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Camossi, E., Bertolotto, M., Bertino, E., Guerrini, G.: A multigranular spatiotemporal data model. In: Proc. of the 11th ACM International Symposium on Advances in Geographic Information Systems, ACM GIS 2003, pp. 94–101 (2003)
Güting, R.H., Böhlen, M.H., Erwig, M., Jensen, C.S., Schneider, M., Lorentzos, N.A., Vazirgiannis, M.: A foundation for representing and querying moving objects. ACM Trans. on Database Systems 25(1), 1–42 (2000)
Khatri, V., Ram, S., Snodgrass, R.T.: ST USM: Bridging the semantic gap with a spatio-temporal conceptual model. Technical report, TimeCenter Research Report TR-64 (2001)
Minout, M., Zimányi, E.: A tool for transforming conceptual schemas of spatiotemporal databases with multiple representations. In: Proc. of the IASTED Int. Conf. on Database Applications, DBA 2004 (2004)
Open GIS Consortium, Inc. OpenGIS Geography Markup Language (GML) Implementation Specification. Version 3.0 (January 2003)
Parent, C.: Query language specification for the MADS model. Technical Report MM-WP3-DLA-008, INFORGE, Université de Lausanne, Switzerland, Deliverable 8, MurMur Project (January 2001)
Parent, C., Spaccapietra, S., Zimányi, E.: Spatio-temporal conceptual models: Data structures + space + time. In: Proc. of the 7th ACM Symposium on Advances in Geographic Information Systems, GIS 1999, pp. 26–33 (1999)
Parent, C., Zimányi, E., Minout, M., Aissaoui, A.: Implantation d’un modèle conceptuel avec multi-représentation. In: Ruas [11], ch. 7, pp. 131–147
Price, R., Tryfona, N., Jensen, C.S.: Extended spatiotemporal UML: Motivations, requirements, and constructs. Journal of Database Management 11(4), 14–27 (2000)
Rigaux, P., Scholl, M., Voisard, A.: Introduction to Spatial Databases: Applications to GIS. Morgan Kaufmann, San Francisco (2000)
Ruas, A. (ed.): Traité IGAT sur la représentation multiple et la généralisation. Hermès (2002)
Tryfona, N., Jensen, C.S.: Conceptual data modeling for spatiotemporal applications. GeoInformatica 3(3), 245–268 (1999)
Vangenot, C., Parent, C., Spaccapietra, S.: Modélisation et manipulation de données spatiales avec multi-représentation dans le modèle MADS. In: Ruas [11], ch. 5, pp. 93–112
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Minout, M., Zimányi, E. (2004). Algebra-to-SQL Query Translation for Spatio-Temporal Databases. In: Galindo, F., Takizawa, M., Traunmüller, R. (eds) Database and Expert Systems Applications. DEXA 2004. Lecture Notes in Computer Science, vol 3180. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30075-5_87
Download citation
DOI: https://doi.org/10.1007/978-3-540-30075-5_87
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-22936-0
Online ISBN: 978-3-540-30075-5
eBook Packages: Springer Book Archive