Context-aware generalization for cube measures

  • Authors:
  • Yoann Pitarch;Cécile Favre;Anne Laurent;Pascal Poncelet

  • Affiliations:
  • LIRMM - CNRS - University Montpellier, Montpellier, France;ERIC - University Lyon 2, Montpellier, France;LIRMM - CNRS - University Montpellier, Montpellier, France;LIRMM - CNRS - University Montpellier, Montpellier, France

  • Venue:
  • DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

Hierarchies are crucial for analysis in data warehouses. But they can hardly be defined on measure attributes. In this paper, we tackle this issue and we show that measure generalizations often depend on a context. For instance, a given blood pressure can be either low, normal or high regarding not only the collected measure but also characteristics of the patient such as the age. The contribution of this paper is threefold. (1) Thanks to an external database storing the expert knowledge, we propose an effective solution for considering these hierarchies. (2) In order to efficiently manage this knowledge, a Rich Internet Application is developed. (3) Finally, in order to provide a flexible analysis, query rewriting module is proposed. Thus, it is possible to answer queries such as: "Who had a low blood pressure last night?''