Representing spatial objects in data warehouses: a logical solution. (5th November 2019)

• Record Type: Journal Article
• Authors: Garani, Georgia
• Is Part Of: International journal of spatial, temporal and multimedia information systems. Volume 1:Number 3(2019)
• Page Start: 232
• Page End: 252
• Publication Date: 2019-11-05
• Subjects: 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; Geographic information systems -- Periodicals; Temporal databases -- Periodicals; Multimedia systems -- Periodicals; 005.753
• Languages: English
• ISSNs: 2052-3556

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.