ST4SQL: a spatio-temporal query language dealing with granularities

Abstract

In many different application fields the amount and importance of spatio-temporal data (i.e., temporally and/or spatially qualified data) is increasing in last years and users need new solutions for their management. In a previous work a framework for modeling spatio-temporal data in relational databases has been proposed. The model is based on the notions of temporal, spatial, and spatio-temporal granularities. Once data have been modeled, they must be queried through query languages that are also able to exploit their spatio-temporal components. In this paper we propose a spatio-temporal query language, called ST4SQL. The proposed language extends the well-known SQL syntax and the T4SQL temporal query language. The proposed query language deals with different temporal, spatial and spatio-temporal semantics. These semantics allow one to specify how the system must manage temporal and spatial dimensions for evaluating the queries. Moreover, the query language introduces new constructs for grouping data with respect to temporal and spatial dimensions. Both semantics and grouping constructs take into account and exploit data qualified with granularities