GeoMiner: a system prototype for spatial data mining
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Spatial data integrity constraints in object oriented geographic data modeling
Proceedings of the 7th ACM international symposium on Advances in geographic information systems
Spatial databases with application to GIS
Spatial databases with application to GIS
A foundation for capturing and querying complex multidimensional data
Information Systems - Data warehousing
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals
Data Mining and Knowledge Discovery
R-trees: a dynamic index structure for spatial searching
SIGMOD '84 Proceedings of the 1984 ACM SIGMOD international conference on Management of data
Object-Based Selective Materialization for Efficient Implementation of Spatial Data Cubes
IEEE Transactions on Knowledge and Data Engineering
Efficient OLAP Operations in Spatial Data Warehouses
SSTD '01 Proceedings of the 7th International Symposium on Advances in Spatial and Temporal Databases
Pre-aggregation in Spatial Data Warehouses
SSTD '01 Proceedings of the 7th International Symposium on Advances in Spatial and Temporal Databases
Extending Geographic Databases for a Query Language to Support Queries Involving Statistical Data
SSDBM '00 Proceedings of the 12th International Conference on Scientific and Statistical Database Management
Advanced SQL 1999: Understanding Object-Relational, and Other Advanced Features
Advanced SQL 1999: Understanding Object-Relational, and Other Advanced Features
Cooperation with geographic databases
Multidimensional databases
Spatial hierarchy and OLAP-favored search in spatial data warehouse
DOLAP '03 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP
Multidimensional data modeling for location-based services
The VLDB Journal — The International Journal on Very Large Data Bases
Representing spatiality in a conceptual multidimensional model
Proceedings of the 12th annual ACM international workshop on Geographic information systems
Fundamentals of Database Systems, Fourth Edition
Fundamentals of Database Systems, Fourth Edition
Conceptual Modeling for Traditional and Spatio-Temporal Applications: The MADS Approach
Conceptual Modeling for Traditional and Spatio-Temporal Applications: The MADS Approach
Hierarchies in a multidimensional model: from conceptual modeling to logical representation
Data & Knowledge Engineering - Special issue: WIDM 2004
Preserving semantics when transforming conceptual spatio-temporal schemas
OTM'05 Proceedings of the 2005 OTM Confederated international conference on On the Move to Meaningful Internet Systems
Spatial hierarchies and topological relationships in the spatial MultiDimER model
BNCOD'05 Proceedings of the 22nd British National conference on Databases: enterprise, Skills and Innovation
Spatial aggregation: Data model and implementation
Information Systems
Analyzing demographic and economic simulation model results: a semi-automatic spatial OLAP approach
ICCSA'11 Proceedings of the 2011 international conference on Computational science and its applications - Volume Part I
Spatial clustering to uncluttering map visualization in SOLAP
ICCSA'11 Proceedings of the 2011 international conference on Computational science and its applications - Volume Part I
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
Spatial Clustering in SOLAP Systems to Enhance Map Visualization
International Journal of Data Warehousing and Mining
| Hi-index | 0.00 |
The MultiDimER model is a conceptual model used for representing a multidimensional view of data for Data Warehouse (DW) and On-Line Analytical Processing (OLAP) applications. This model includes a spatial extension allowing spatiality in levels, hierarchies, fact relationships, and measures. In this way decision-making users can represent in an abstract manner their analysis needs without considering complex implementation issues and spatial OLAP tools developers can have a common vision for representing spatial data in a multidimensional model. In this paper we propose the transformation of a conceptual schema based on the MultiDimER constructs to an object-relational schema. We based our mapping on the SQL:2003 and SQL/MM standards giving examples of commercial implementation using Oracle 10g with its spatial extension. Further we use spatial integrity constraints to ensure the semantic equivalence of the conceptual and logical schemas. We also show some examples of Oracle spatial functions, including aggregation functions required for the manipulation of spatial data. The described mappings to the object-relational model along with the examples using a commercial system show the feasibility of implementing spatial DWs in current commercial DBMSs. Further, using integrated architectures, where spatial and thematic data is defined within the same DBMS, facilitates the system management simplifying data definition and manipulation.