Hierarchy-based Update Propagation in Decision Support Systems

Haitang Feng 1 Nicolas Lumineau 1 Mohand-Said Hacid 1 Richard Domps
1 BD - Base de Données
LIRIS - Laboratoire d'InfoRmatique en Image et Systèmes d'information
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 domain, some methods propagate updates in hierarchies when data sources are subject to modifications. However, very few works have been performed so far regarding update propagation from summaries to data sources. This paper proposes an algorithm named PAM algorithm, to efficiently propagate modifications on summaries. Experiments on an operational application (Anticipeo) have been performed to validate our algorithm.
Document type :
Conference papers
Complete list of metadatas

https://hal.archives-ouvertes.fr/hal-01352943
Contributor : Équipe Gestionnaire Des Publications Si Liris <>
Submitted on : Wednesday, August 10, 2016 - 4:16:10 PM
Last modification on : Tuesday, February 26, 2019 - 11:49:42 AM

Identifiers

Citation

Haitang Feng, Nicolas Lumineau, Mohand-Said Hacid, Richard Domps. Hierarchy-based Update Propagation in Decision Support Systems. Database Systems for Advanced Applications (DASFAA), Apr 2012, Busan, South Korea. pp.261-271, ⟨10.1007/978-3-642-29035-0_20⟩. ⟨hal-01352943⟩

Share

Metrics

Record views

120