A Novel Query-Based Approach for Addressing Summarizability Issues in XOLAP

Abstract : The business intelligence and decision-support systems used in many application domains casually rely on data warehouses, which are decision-oriented data repositories modeled as multidimensional (MD) structures. MD structures help navigate data through hierarchical levels of detail. In many real-world situations, hierarchies in MD models are complex, which causes data aggregation issues, collectively known as the summarizability problem. This problem leads to incorrect analyses and critically affects decision making. To enforce summarizability, existing approaches alter either MD models or data, and must be applied a priori, on a case-by-case basis, by an expert. To alter neither models nor data, a few query-time approaches have been proposed recently, but they only detect summarizability issues without solving them. Thus, we propose in this paper a novel approach that automatically detects and processes summarizability issues at query time, without requiring any particular expertise from the user. Moreover, while most existing approaches are based on the relational model, our approach focus on an XML MD model, since XML data is customarily used to represent business data and its format better copes with complex hierarchies than the relational model. Finally, our experiments show that our method is likely to scale better than a reference approach for addressing the summarizability problem in the MD context.
Type de document :
Communication dans un congrès
CSI. 18th International Conference on Management of Data (COMAD 2012), Dec 2012, Pune, India. pp.56-67, 2012
Liste complète des métadonnées

Littérature citée [30 références]  Voir  Masquer  Télécharger

https://hal.archives-ouvertes.fr/hal-00855773
Contributeur : Jérôme Darmont <>
Soumis le : vendredi 30 août 2013 - 09:13:55
Dernière modification le : mercredi 5 septembre 2018 - 15:18:27
Document(s) archivé(s) le : jeudi 6 avril 2017 - 10:37:32

Fichiers

comad_2012.pdf
Fichiers produits par l'(les) auteur(s)

Identifiants

  • HAL Id : hal-00855773, version 1
  • ARXIV : 1308.6682

Collections

Citation

Marouane Hachicha, Chantola Kit, Jérôme Darmont. A Novel Query-Based Approach for Addressing Summarizability Issues in XOLAP. CSI. 18th International Conference on Management of Data (COMAD 2012), Dec 2012, Pune, India. pp.56-67, 2012. 〈hal-00855773〉

Partager

Métriques

Consultations de la notice

132

Téléchargements de fichiers

117