Algebra-to-SQL Query Translation for Spatio-Temporal Databases [chapter]

Mohammed Minout, Esteban Zimányi
<span title="">2004</span> <i title="Springer Berlin Heidelberg"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/2w3awgokqne6te4nvlofavy5a4" style="color: black;">Lecture Notes in Computer Science</a> </i> &nbsp;
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
more &raquo; ... nto 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. Acknowledgements The authors would like to thanks Christine Parent and Stefano Spaccapietra, our colleagues of the MurMur project, for our fruitful collaboration. In particular, Christine Parent is the initiator of the MADS model and provided the original definition of the MADS algebra.
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1007/978-3-540-30075-5_87">doi:10.1007/978-3-540-30075-5_87</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/xguknazdhfbvvadjez76uuf5cu">fatcat:xguknazdhfbvvadjez76uuf5cu</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20040713111626/http://cs.ulb.ac.be:80/publications/P-04-07.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/ba/ec/baecae59138be86164d0f4f8767bc3e2be39bb5e.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1007/978-3-540-30075-5_87"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> springer.com </button> </a>