Title: Representing spatial objects in data warehouses: a logical solution

Authors: Georgia Garani

Addresses: Department of Computer Science and Engineering, Technological Educational Institute of Thessaly, Larissa 41110, Greece

Abstract: Spatial data warehouse logical design involves mainly extending the techniques used in relational logical data warehouse design for the support of spatial objects, i.e., geometric objects in space. Spatial objects can have different geometric granularities and can be found at different hierarchical levels of a dimension in the logical model of a data warehouse. This paper addresses data warehouse logical design considerations for a consolidated representation of spatial and non-spatial data. The novelty of the model presented in this paper is the representation of spatial objects in a logical and semantically effective manner. With this approach, complex spatial objects can be modelled in a generic and user-friendly format. The model also includes ROLAP operations supporting the navigation across different dimensions' levels and the execution of queries. The functionality of the model is also provided by a number of example queries.

Keywords: spatial data warehouse; SDW; spatial object; starnest schema; logical modelling; ROLAP; spatial data management; spatial nested dimension; spatial attribute; dimension level path; spatial query language.

DOI: 10.1504/IJSTMIS.2019.103540

International Journal of Spatial, Temporal and Multimedia Information Systems, 2019 Vol.1 No.3, pp.232 - 252

Received: 13 Dec 2017
Accepted: 14 Sep 2018
Published online: 11 Nov 2019 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article