CoDE Publications CoDE Publications
IRIDIA Publications IRIDIA Publications
SMG Publications
WIT Publications
WIT Publications
SMG Publications
Home People Research Activities Publications Teaching Resources
By Class By Topic By Year
By Class By Topic By Year
login
M. Minout and E. Zimányi. Algebra-to-SQL Query Translation for Spatio-Temporal Databases. In Proceedings of the 15th International Conference on Database and Expert Systems Applications, DEXA 2004, number 3180 in Lecture Notes in Computer Science, pages 904-913. Springer-Verlag, Zaragoza, Spain, August-September 2004.
© Springer-Verlag 2004 – http://dx.doi.org/10.1007/b99664

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.


Updated: 2017-03-27