A data model and query language for spatio-temporal decision support

"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 previo...

Descripción completa

Detalles Bibliográficos
Autores principales: Gómez, Leticia Irene, Kuijpers, Bart, Vaisman, Alejandro Ariel
Formato: Artículos de Publicaciones Periódicas acceptedVersion
Lenguaje:Inglés
Publicado: 2022
Materias:
Acceso en línea:https://ri.itba.edu.ar/handle/123456789/3996
Aporte de:
id I32-R138-123456789-3996
record_format dspace
spelling I32-R138-123456789-39962022-12-07T13:06:56Z A data model and query language for spatio-temporal decision support Gómez, Leticia Irene Kuijpers, Bart Vaisman, Alejandro Ariel OLAP BASES DE DATOS ESPACIO Y TIEMPO "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 intro ducing 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 Lt, 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." 2022-11-14T15:49:35Z 2022-11-14T15:49:35Z 2010 Artículos de Publicaciones Periódicas info:eu-repo/semantics/acceptedVersion 1384-6175 https://ri.itba.edu.ar/handle/123456789/3996 en info:eu-repo/semantics/altIdentifier/doi/10.1007/s10707-010-0110-7 application/pdf
institution Instituto Tecnológico de Buenos Aires (ITBA)
institution_str I-32
repository_str R-138
collection Repositorio Institucional Instituto Tecnológico de Buenos Aires (ITBA)
language Inglés
topic OLAP
BASES DE DATOS
ESPACIO Y TIEMPO
spellingShingle OLAP
BASES DE DATOS
ESPACIO Y TIEMPO
Gómez, Leticia Irene
Kuijpers, Bart
Vaisman, Alejandro Ariel
A data model and query language for spatio-temporal decision support
topic_facet OLAP
BASES DE DATOS
ESPACIO Y TIEMPO
description "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 intro ducing 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 Lt, 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."
format Artículos de Publicaciones Periódicas
acceptedVersion
author Gómez, Leticia Irene
Kuijpers, Bart
Vaisman, Alejandro Ariel
author_facet Gómez, Leticia Irene
Kuijpers, Bart
Vaisman, Alejandro Ariel
author_sort Gómez, Leticia Irene
title A data model and query language for spatio-temporal decision support
title_short A data model and query language for spatio-temporal decision support
title_full A data model and query language for spatio-temporal decision support
title_fullStr A data model and query language for spatio-temporal decision support
title_full_unstemmed A data model and query language for spatio-temporal decision support
title_sort data model and query language for spatio-temporal decision support
publishDate 2022
url https://ri.itba.edu.ar/handle/123456789/3996
work_keys_str_mv AT gomezleticiairene adatamodelandquerylanguageforspatiotemporaldecisionsupport
AT kuijpersbart adatamodelandquerylanguageforspatiotemporaldecisionsupport
AT vaismanalejandroariel adatamodelandquerylanguageforspatiotemporaldecisionsupport
AT gomezleticiairene datamodelandquerylanguageforspatiotemporaldecisionsupport
AT kuijpersbart datamodelandquerylanguageforspatiotemporaldecisionsupport
AT vaismanalejandroariel datamodelandquerylanguageforspatiotemporaldecisionsupport
_version_ 1765660932038459392