Hierarchy-Based update propagation in decision support systems

  • Authors:
  • Haitang Feng;Nicolas Lumineau;Mohand-Saíd Hacid;Richard Domps

  • Affiliations:
  • Université de Lyon, CNRS, Université Lyon 1, LIRIS, UMR5205, France and Anticipeo, Villejuif, France;Université de Lyon, CNRS, Université Lyon 1, LIRIS, UMR5205, France;Université de Lyon, CNRS, Université Lyon 1, LIRIS, UMR5205, France;Anticipeo, Villejuif, France

  • Venue:
  • DASFAA'12 Proceedings of the 17th international conference on Database Systems for Advanced Applications - Volume Part II
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

Sales forecasting systems are used by enterprise managers and executives to better understand the market trends and prepare appropriate business plans. These decision support systems usually use a data warehouse to store data and OLAP tools to visualize query results. A specific feature of sales forecasting systems regarding future predictions modification is backward propagation of updates, which is the computation of the impact of modifications on summaries over base data. In Data warehouses, some methods propagate updates in hierarchies when data sources are subject to modifications. However, very few works have been devoted so far, regarding update propagation from summaries to data sources. This paper proposes an algorithm called PAM (Propagation of Aggregate Modification), to efficiently propagate modifications on summaries over base data. Experiments on an operational application (Anticipeo) have been conducted.