Centre de documentation
scientifique

Logical representation of a conceptual model for spatial data warehouses / E. Malinowski in Geoinformatica, vol 11 n° 4 (December 2007)  

Public [article]  inGeoinformatica > vol 11 n° 4 (December 2007) . - pp 431 - 457 Titre : Logical representation of a conceptual model for spatial data warehouses Type de document : Article/Communication Auteurs : E. Malinowski, Auteur ; E. Zimanyi, Auteur Année de publication : 2007 Article en page(s) : pp 431 - 457 Note générale : Bibliographie Langues : Anglais (eng) Descripteur : [Vedettes matières IGN] Bases de données localisées [Termes IGN] contrainte d'intégrité [Termes IGN] entrepôt de données localisées [Termes IGN] modèle conceptuel de données localisées [Termes IGN] modèle logique de données [Termes IGN] modèle relationnel [Termes IGN] OLAP [Termes IGN] Oracle 10G [Termes IGN] SQL Résumé : (Auteur) 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 implemen-tation using Oracle lOg 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. Copyright Springer Numéro de notice : A2007-469 Affiliation des auteurs : non IGN Thématique : GEOMATIQUE/INFORMATIQUE Nature : Article DOI : 10.1007/s10707-007-0022-3 En ligne : https://doi.org/10.1007/s10707-007-0022-3 Format de la ressource électronique : URL article Permalink : https://documentation.ensg.eu/index.php?lvl=notice_display&id=28832 [article]

Exemplaires(1)

Code-barres	Cote	Support	Localisation	Section	Disponibilité
057-07041	RAB	Revue	Centre de documentation	En réserve L003	Disponible