scholarly journals Spatial Data Warehouse Modelling

2011 ◽  
pp. 282-300
Author(s):  
Maria Luisa Damiani ◽  
Stefano Spaccapietra
Keyword(s):  
Data Warehouse ◽  
Spatial Data ◽  
Data Model ◽  
Spatial Dimension ◽  
Research Area ◽  
Multidimensional Data ◽  
Spatial Data Warehouse ◽  
Definition Of ◽  
Spatial Data Warehouses ◽  
Current Standards

This chapter is concerned with multidimensional data models for spatial data warehouses. Over the last few years different approaches have been proposed in the literature for modelling multidimensional data with geometric extent. Nevertheless, the definition of a comprehensive and formal data model is still a major research issue. The main contributions of the chapter are twofold: First, it draws a picture of the research area; second it introduces a novel spatial multidimensional data model for spatial objects with geometry (MuSD – multigranular spatial data warehouse). MuSD complies with current standards for spatial data modelling, augmented by data warehousing concepts such as spatial fact, spatial dimension and spatial measure. The novelty of the model is the representation of spatial measures at multiple levels of geometric granularity. Besides the representation concepts, the model includes a set of OLAP operators supporting the navigation across dimension and measure levels.

scholarly journals Spatial Data Warehouse Modelling

2011 ◽  
pp. 1-27 ◽  
Author(s):  
Maria Luisa Damiani ◽  
Stefano Spaccapietra
Keyword(s):  
Data Warehouse ◽  
Spatial Data ◽  
Data Model ◽  
Spatial Dimension ◽  
Research Area ◽  
Multidimensional Data ◽  
Spatial Data Warehouse ◽  
Definition Of ◽  
Spatial Data Warehouses ◽  
Current Standards

This chapter is concerned with multidimensional data models for spatial data warehouses. Over the last few years different approaches have been proposed in the literature for modelling multidimensional data with geometric extent. Nevertheless, the definition of a comprehensive and formal data model is still a major research issue. The main contributions of the chapter are twofold: First, it draws a picture of the research area; second it introduces a novel spatial multidimensional data model for spatial objects with geometry (MuSD – multigranular spatial data warehouse). MuSD complies with current standards for spatial data modelling, augmented by data warehousing concepts such as spatial fact, spatial dimension and spatial measure. The novelty of the model is the representation of spatial measures at multiple levels of geometric granularity. Besides the representation concepts, the model includes a set of OLAP operators supporting the navigation across dimension and measure levels.

scholarly journals Spatial Data Warehouse Modelling

2008 ◽  
pp. 659-678
Author(s):  
Maria Luisa Damiani ◽  
Stefano Spaccapietra
Keyword(s):  
Data Warehouse ◽  
Spatial Data ◽  
Data Model ◽  
Spatial Dimension ◽  
Research Area ◽  
Multidimensional Data ◽  
Spatial Data Warehouse ◽  
Definition Of ◽  
Spatial Data Warehouses ◽  
Current Standards

This chapter is concerned with multidimensional data models for spatial data warehouses. Over the last few years different approaches have been proposed in the literature for modelling multidimensional data with geometric extent. Nevertheless, the definition of a comprehensive and formal data model is still a major research issue. The main contributions of the chapter are twofold: First, it draws a picture of the research area; second it introduces a novel spatial multidimensional data model for spatial objects with geometry (MuSD – multigranular spatial data warehouse). MuSD complies with current standards for spatial data modelling, augmented by data warehousing concepts such as spatial fact, spatial dimension and spatial measure. The novelty of the model is the representation of spatial measures at multiple levels of geometric granularity. Besides the representation concepts, the model includes a set of OLAP operators supporting the navigation across dimension and measure levels.

AN ARCHITECTURE FOR DATA WAREHOUSING SUPPORTING DATA INDEPENDENCE AND INTEROPERABILITY

2001 ◽  
Vol 10 (03) ◽  
pp. 377-397 ◽  
Author(s):  
LUCA CABIBBO ◽  
RICCARDO TORLONE
Keyword(s):  
Data Warehouse ◽  
Data Model ◽  
Data Warehousing ◽  
Heterogeneous Data ◽  
Multidimensional Data ◽  
Multidimensional Databases ◽  
Level Of Aggregation ◽  
High Level ◽  
Data Independence ◽  
Logical Architecture

We report on the design of a novel architecture for data warehousing based on the introduction of an explicit "logical" layer to the traditional data warehousing framework. This layer serves to guarantee a complete independence of OLAP applications from the physical storage structure of the data warehouse and thus allows users and applications to manipulate multidimensional data ignoring implementation details. For example, it makes possible the modification of the data warehouse organization (e.g. MOLAP or ROLAP implementation, star scheme or snowflake scheme structure) without influencing the high level description of multidimensional data and programs that use the data. Also, it supports the integration of multidimensional data stored in heterogeneous OLAP servers. We propose [Formula: see text], a simple data model for multidimensional databases, as the reference for the logical layer. [Formula: see text] provides an abstract formalism to describe the basic concepts that can be found in any OLAP system (fact, dimension, level of aggregation, and measure). We show that [Formula: see text] databases can be implemented in both relational and multidimensional storage systems. We also show that [Formula: see text] can be profitably used in OLAP applications as front-end. We finally describe the design of a practical system that supports the above logical architecture; this system is used to show in practice how the architecture we propose can hide implementation details and provides a support for interoperability between different and possibly heterogeneous data warehouse applications.

Distributed Data Warehouse for Geo-spatial Services

2003 ◽  
pp. 132-145 ◽  
Author(s):  
Iftikhar U. Sikder ◽  
Aryya Gangopadhyay
Keyword(s):  
Decision Making ◽  
Data Warehouse ◽  
Spatial Data ◽  
System Integration ◽  
Prototype System ◽  
Distributed Data ◽  
Distributed Environment ◽  
Spatial Decision Making ◽  
Spatial Data Warehouse ◽  
Access To Data

This chapter introduces the research issues on spatial decision-making in the context of distributed geo-spatial data warehouse. Spatial decision-making in a distributed environment involves access to data and models from heterogeneous sources and composing disparate services into a meaningful integration. The chapter reviews system integration and interoperability issues of spatial data and models in a distributed computing environment. We present a prototype system to illustrate the collaborative access to data and as a model for supporting spatial decision-making.

scholarly journals Data Warehouse Schemas using Multidimensional Data Model for Retail

2017 ◽  
Vol 2 (1) ◽  
pp. 84
Author(s):  
Kheri Arionadi Shobirin ◽  
Adi Panca Saputra Iskandar ◽  
Ida Bagus Alit Swamardika
Keyword(s):  
Decision Making ◽  
Real Time ◽  
Data Warehouse ◽  
Data Model ◽  
Transaction Processing ◽  
Multidimensional Data ◽  
Complex Query ◽  
On Line ◽  
Analytical Processing ◽  
Operational Data

A data warehouse are central repositories of integrated data from one or more disparate sources from operational data in On-Line Transaction Processing (OLTP) system to use in decision making strategy and business intelligent using On-Line Analytical Processing (OLAP) techniques. Data warehouses support OLAP applications by storing and maintaining data in multidimensional format. Multidimensional data models as an integral part of OLAP designed to solve complex query analysis in real time.

Sign in / Sign up

Export Citation Format

Share Document