Article thumbnail

muenster.de

By Jose-norberto Mazón, Jens Lechtenbörger and Juan Trujillo

Abstract

Multidimensional analysis allows decision makers to effici-ently and effectively use data analysis tools, which mainly depend on multidimensional (MD) structures of a data ware-house such as facts and dimension hierarchies to explore the information and aggregate it at different levels of detail in an accurate way. A conceptual model of such MD structures serves as abstract basis of the subsequent implementation according to one specific technology. However, there is a se-mantic gap between a conceptual model and its implemen-tation which complicates an adequate treatment of summa-rizability issues, which in turn may lead to erroneous results of data analysis tools and cause the failure of the whole data warehouse project. To bridge this gap for relationships be-tween facts and dimension, we present an approach at the conceptual level for (i) identifying problematic situations in fact-dimension relationships, (ii) defining these relationships in a conceptual MD model, and (iii) applying a normaliza-tion process to transform this conceptual MD model into a summarizability-compliant model that avoids erroneous analysis of data. Furthermore, we also describe our Eclipse-based implementation of this normalization process

Topics: Categories and Subject Descriptors H.2.1 [Database Management, Logical Design—data mod- els, normal forms General Terms Design Keywords Multidimensional modeling, summarizability, data warehouse ∗Work supported by projects TIN2007-67078 (Spanish Min
Year: 2016
OAI identifier: oai:CiteSeerX.psu:10.1.1.940.4007
Provided by: CiteSeerX
Download PDF:
Sorry, we are unable to provide the full text but you may find it at the following location(s):
  • http://dbis-group.uni-muenster... (external link)
  • http://dbis-group.uni-muenster... (external link)
  • http://citeseerx.ist.psu.edu/v... (external link)
  • Suggested articles


    To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.