COMPUTER-AIDED DATA-MART DESIGN

Fatma Abdelhédi, Geneviève Pujolle, Olivier Teste, Gilles Zurfluh

2011

Abstract

With decision support systems, decision-makers analyse data in data marts extracted from production bases. The data-mart schema design is generally performed by expert designers (administrator or computer specialist). With data-driven, requirement-driven or hybrid-driven approaches, this designer builds a data-mart defining facts (analysis subjects) and analysis axes. This process, based on data sources and decision-makers requirements, often turns out to be approximate and complex. We propose to design a data-mart schema by the decision-maker himself, following a hybrid-driven approach. Using an assistance process that visualises successively intermediate schemas built from data sources, the decision-maker gradually builds his multidimensional schema. He determines measures to be analysed, dimensions hierarchies within dimensions. A CASE tool based on this concept has been developed.

Paper Citation

in Harvard Style

Abdelhédi F., Pujolle G., Teste O. and Zurfluh G. (2011). COMPUTER-AIDED DATA-MART DESIGN . In Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8425-53-9, pages 239-246. DOI: 10.5220/0003501902390246

in Bibtex Style

@conference{iceis11,
author={Fatma Abdelhédi and Geneviève Pujolle and Olivier Teste and Gilles Zurfluh},
title={COMPUTER-AIDED DATA-MART DESIGN},
booktitle={Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2011},
pages={239-246},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003501902390246},
isbn={978-989-8425-53-9},
}

in EndNote Style

TY - CONF
JO - Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - COMPUTER-AIDED DATA-MART DESIGN
SN - 978-989-8425-53-9
AU - Abdelhédi F.
AU - Pujolle G.
AU - Teste O.
AU - Zurfluh G.
PY - 2011
SP - 239
EP - 246
DO - 10.5220/0003501902390246