Algebra-to-SQL Query Translation for Spatio-Temporal Databases

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.

• Type: Conference
• Year: 2004
• Where: DEXA
• Authors: Mohammed Minout, Esteban Zimányi
• Keywords: Conceptual Schema, DEXA 2004, Query Editor Tool, Query Translator Module