Open AccessIMPLEMENTING SPATIAL DATA WAREHOUSE HIERARCHIES IN OBJECT-RELATIONAL DBMSs
Author(s) -
Elzbieta Malinowski,
Esteban Zimányi
Publication year - 2007
Language(s) - English
Resource type - Conference proceedings
DOI - 10.5220/0002355401860191
Subject(s) - computer science , data warehouse , oracle , logical data model , conceptual schema , schema (genetic algorithms) , conceptual model , entity–relationship model , data modeling , relational database , theoretical computer science , database , information retrieval , software engineering , developmental psychology , gender schema theory , psychology
Spatial Data Warehouses (SDWs) allow to analyze historical data represented in a space supporting the decision-making process. SDW applications require a multidimensional view of data that includes dimensions with hierarchies and facts with associated measures. In particular, hierarchies are important since traversing them users can analyze detailed and aggregated measures. To better represent users’ requirements for SDWs, the conceptual model with spatial support should be used. Afterwards, the conceptual schema is translated to the logical and physical schemas. However, during the translation process the semantics can be lost. In this paper, we present the translation of spatial hierarchies from the conceptual to physical schemas represented in the MultiDimER model and Oracle 10g Spatial, respectively. Further, to ensure the semantic equivalence between the conceptual and the physical schemas, integrity constraints are exemplified mainly using triggers.
Accelerating Research
Robert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom
Address
John Eccles HouseRobert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom