loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Noura Azaiez and Jalel Akaichi

Affiliation: ISG-University of Tunis, Tunisia

Keyword(s): Data Warehouse, Evolution Operations, Data Mart, Propagation Rules, Schema Versioning.

Related Ontology Subjects/Areas/Topics: Decision Support Systems ; Knowledge Engineering and Ontology Development ; Knowledge-Based Systems

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 inconsi stent 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. (More)

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 35.172.231.232

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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 (IC3K 2014) - KEOD; ISBN 978-989-758-049-9; ISSN 2184-3228, SciTePress, pages 428-435. DOI: 10.5220/0005158304280435

@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 (IC3K 2014) - KEOD},
year={2014},
pages={428-435},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005158304280435},
isbn={978-989-758-049-9},
issn={2184-3228},
}

TY - CONF

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