How to Guarantee Analysis Results Coherence after Data Warehouse Schema Changes Propagation towards Data Marts?

Noura Azaiez, Jalel Akaichi

2014

Abstract

Data Warehouse, accompanied with Online analytical processing, is considered as the core of the modern Decision support systems. The emergence of new analytical requirements and changes in organization business processes push the underlying information sources, destined to feed the data warehouse, to modify not only their data, but also their structure. This, obviously, has a direct impact on Data Warehouse and its associated Data Marts. Maintaining Data Warehouse structure becomes, therefore, a must; however, it is not sufficient. In fact, evolutions performed on the Data Warehouse schema have to be propagated on the related Data Marts in order to minimize costs, time-consuming and to guarantee the coherence of provided analysis results; this presents our first vision issue for which, we aim to provide an adequate solution. Another issue, which is as important as the precedent one, focuses on modeling a continuous temporal evolution phenomenon and therefore reducing inconsistent Online analytical processing queries results. Indeed, data returned by queries can be the result of an evolution phenomenon continued in several time intervals. Therefore, we nominate the versioning approach as a solution to keep traces of Data Warehouse / Data Mart schemas’ modifications. Solving these two issues presents the key of organization Decision support systems durability and its material prosperity.

Paper Citation

in Harvard Style

Azaiez N. and Akaichi J. (2014). How to Guarantee Analysis Results Coherence after Data Warehouse Schema Changes Propagation towards Data Marts? . In Proceedings of the International Conference on Knowledge Engineering and Ontology Development - Volume 1: KEOD, (IC3K 2014) ISBN 978-989-758-049-9, pages 428-435. DOI: 10.5220/0005158304280435

in Bibtex Style

@conference{keod14,
author={Noura Azaiez and Jalel Akaichi},
title={How to Guarantee Analysis Results Coherence after Data Warehouse Schema Changes Propagation towards Data Marts?},
booktitle={Proceedings of the International Conference on Knowledge Engineering and Ontology Development - Volume 1: KEOD, (IC3K 2014)},
year={2014},
pages={428-435},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005158304280435},
isbn={978-989-758-049-9},
}

in EndNote Style

TY - CONF
JO - Proceedings of the International Conference on Knowledge Engineering and Ontology Development - Volume 1: KEOD, (IC3K 2014)
TI - How to Guarantee Analysis Results Coherence after Data Warehouse Schema Changes Propagation towards Data Marts?
SN - 978-989-758-049-9
AU - Azaiez N.
AU - Akaichi J.
PY - 2014
SP - 428
EP - 435
DO - 10.5220/0005158304280435