loading
Papers

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Fatma Abdelhédi ; Geneviève Pujolle ; Olivier Teste and Gilles Zurfluh

Affiliation: University Toulouse 1 Capitole– IRIT (UMR 5505), France

ISBN: 978-989-8425-53-9

Keyword(s): Multidimensional model, Design process, Data-mart, Decision-makers’ requirements, Data-source.

Related Ontology Subjects/Areas/Topics: Data Warehouses and OLAP ; Databases and Information Systems Integration ; Enterprise Information Systems

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.

PDF ImageFull Text

Download
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 3.231.228.109

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:
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

@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},
}

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

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.