caa a22 4500 445331852 CHVBK 20180317142740.0 cr unu---uuuuu 170323e20110701xx s 000 0 eng 10.1007/s10707-010-0110-7 doi (NATIONALLICENCE)springer-10.1007/s10707-010-0110-7 A data model and query language for spatio-temporal decision support [Elektronische Daten] [Leticia Gómez, Bart Kuijpers, Alejandro Vaisman] In recent years, applications aimed at exploring and analyzing spatial data have emerged, powered by the increasing need of software that integrates Geographic Information Systems (GIS) and On-Line Analytical Processing (OLAP). These applications have been called SOLAP (Spatial OLAP). In previous work, the authors have introduced Piet, a system based on a formal data model that integrates in a single framework GIS, OLAP (On-Line Analytical Processing), and Moving Object data. Real-world problems are inherently spatio-temporal. Thus, in this paper we present a data model that extends Piet, allowing tracking the history of spatial data in the GIS layers. We present a formal study of the two typical ways of introducing time into Piet: timestamping the thematic layers in the GIS, and timestamping the spatial objects in each layer. We denote these strategies snapshot-based and timestamp-based representations, respectively, following well-known terminology borrowed from temporal databases. We present and discuss the formal model for both alternatives. Based on the timestamp-based representation, we introduce a formal First-Order spatio-temporal query language, which we denote $\mathcal{L}_t,$ able to express spatio-temporal queries over GIS, OLAP, and trajectory data. Finally, we discuss implementation issues, the update operators that must be supported by the model, and sketch a temporal extension to Piet-QL, the SQL-like query language that supports Piet. Springer Science+Business Media, LLC, 2010 OLAP nationallicence Spatio-temporal databases nationallicence GIS nationallicence SOLAP nationallicence Gómez Leticia Instituto Tecnológico de Buenos Aires, Av. Madero 399, Buenos Aires, Argentina aut Kuijpers Bart Hasselt University and Transnational University of Limburg, Gebouw D, 3590, Diepenbeek, Belgium aut Vaisman Alejandro Universidad de Buenos Aires, Ciudad Universitaria, Pabellon I, 1428, Buenos Aires, Argentina aut GeoInformatica Springer US; http://www.springer-ny.com 15/3(2011-07-01), 455-496 1384-6175 15:3<455 2011 15 10707 https://doi.org/10.1007/s10707-010-0110-7 text/html Onlinezugriff via DOI 1 research-article jats NATIONALLICENCE 856 40 https://doi.org/10.1007/s10707-010-0110-7 text/html Onlinezugriff via DOI NATIONALLICENCE 700 1- Gómez Leticia Instituto Tecnológico de Buenos Aires, Av. Madero 399, Buenos Aires, Argentina aut NATIONALLICENCE 700 1- Kuijpers Bart Hasselt University and Transnational University of Limburg, Gebouw D, 3590, Diepenbeek, Belgium aut NATIONALLICENCE 700 1- Vaisman Alejandro Universidad de Buenos Aires, Ciudad Universitaria, Pabellon I, 1428, Buenos Aires, Argentina aut NATIONALLICENCE 773 0- GeoInformatica Springer US; http://www.springer-ny.com 15/3(2011-07-01), 455-496 1384-6175 15:3<455 2011 15 10707 Metadata rights reserved Springer special CC-BY-NC licence nationallicence BK010053 XK010053 XK010000 NATIONALLICENCE NATIONALLICENCE NL-springer