A Data Warehouse Conceptual Data Model for Multidimensional Aggregation
Enrico Franconi, Ulrike Sattler · Research Explorer (The University of Manchester) · 1999
This paper presents a proposal for a Data Warehouse Conceptual Data (CDWDM) Model which allows for the description of both the relevant aggregated entities of the domain---together with their properties and their relationships with other relevant entities---and the relevant dimensions involved in building the aggregated entities. The proposed CDWDM is able to capture the database schemata expressed in an extended version of the Entity-Relationship Data Model; it is able to introduce complex descriptions of the structure of aggregated entities and multiply hierarchically organised dimensions; it is based on Description Logics, a class of formalisms for which it is possible to study the expressivity in relation with decidability of reasoning problems and completeness of algorithms. 1 Introduction Data Warehouse---and especially OLAP---applications ask for the vital extension of the expressive power and functionality of traditional conceptual modelling formalisms in orde...