The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Olap Solutions: Building Multidimensional Information Systems
Olap Solutions: Building Multidimensional Information Systems
Representing spatiality in a conceptual multidimensional model
Proceedings of the 12th annual ACM international workshop on Geographic information systems
Metamodel-based model conformance and multiview consistency checking
ACM Transactions on Software Engineering and Methodology (TOSEM)
Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications (Data-Centric Systems and Applications)
An MDA Approach for the Development of Spatial Data Warehouses
DaWaK '08 Proceedings of the 10th international conference on Data Warehousing and Knowledge Discovery
Designing Data Warehouses for Geographic OLAP Querying by Using MDA
ICCSA '09 Proceedings of the International Conference on Computational Science and Its Applications: Part I
Modelling and querying geographical data warehouses
Information Systems
DOLAP 2011: overview of the 14th international workshop on data warehousing and olap
Proceedings of the 20th ACM international conference on Information and knowledge management
Enhancing coverage and expressive power of spatial data warehousing modeling: the SDWM approach
DaWaK'12 Proceedings of the 14th international conference on Data Warehousing and Knowledge Discovery
| Hi-index | 0.01 |
There are works that propose metamodels for SDW modeling. However, we observe that most of these works defines metamodels that mix concepts of DW modeling with concepts of the OLAP cube modeling. We disagree with this view, because we understand that a DW is essentially a database, which can be analyzed/queried by any data analysis tool. Moreover, we also note other limitations. For example: the most proposed metamodels 1) do not support important techniques for DW modeling and 2) represent the spatiality in a SDW stereotyping the dimensions and fact tables as spatial or hybrid, rather than simply stereotyping the attributes/measures as spatial. Aiming to solve these problems we propose a more straightforward and more expressive metamodel for SDW modeling, named Spatial Data Warehouse Metamodel (SDWM), which describes the constructors and the restrictions needed to model and validate a SDW schema. As a proof of concept, we implemented a CASE tool according to our metamodel and, with this CASE tool, we designed a SDW for the Meteorological Laboratory from the State of Pernambuco, in Brazil.