A spatial SQL extension for continuous field querying

Abstract

In the last decade, a growing interest has been devoted to the management of data referring to geographic scenarios. However, the attention of recent research has been focused on discrete data disregarding continuous data, because of their intrinsic complexity. In this paper, we introduce an extension of a spatial SQL, which provides users with the capability to pose queries about both discrete and continuous data.

Extension geographic representation based on dynamic field

“…Furthermore, many common spatial database products such as Oracle and PostgreSQL have offered simple support for geometry or field object access [7]. Although a great deal of work on field, current researches mainly concentrate on static field model and few related work concerns the field implementation with time dimension [7,8]. Also, the integration problem for the continuous and discrete models should be taken into account [9].…”

“…B considered the temporal attribute and added it into the design process of spatial query language as to field objects. Furthermore, many common spatial database products such as Oracle and PostgreSQL have offered simple support for geometry or field object access [7]. Although a great deal of work on field, current researches mainly concentrate on static field model and few related work concerns the field implementation with time dimension [7,8].…”

OLAPing Field Data: a Theoretical and Implementation Framework

“…In order to explore this kind of databases they also define a declarative language based on SQL. A similar approach was also presented in [23] [34] [33] which was also extended to be used by visual languages in [36]. An approach managing continuous fields by means of raster data type was presented by Liu et al in [28].…”

“…In order to benefit from data warehousing and OLAP decision support technologies [23] also in the context of spatial data, some work extended them leading to the concept of Spatial OLAP (SOLAP), which integrates OLAP and Geographic Information Systems (GIS) functionalities into a unique framework [2]. As for the model underlying SOLAP systems, several research issues from theoretical and implementation point of view have risen, while recent focus has been on indexing [40] and visualization techniques [9].…”

Conceptual design and implementation of spatial data warehouses integrating regular grids of points

“…Note that the distinction between the field and the vector is primarily a distinction of convenience and perspective because movement from one representation to a second representation according to the analysis needs is easy (Camara et al, 1995). To implement the continuity of fields, two categories of representations of fields have been proposed in the literature: the incomplete representation and the complete representation (Laurini et al, 1992). The first representation involves assigning a numerical value to each point of the space.…”