ProtOLAP: Rapid OLAP prototyping with on-demand data supply - INRAE - Institut national de recherche pour l’agriculture, l’alimentation et l’environnement Accéder directement au contenu
Communication Dans Un Congrès Année : 2013

ProtOLAP: Rapid OLAP prototyping with on-demand data supply

ProtOLAP : Prototypage OLAP rapide avec des données à la demande

Résumé

The approaches to data warehouse design are based on the assumption that source data are known in advance and available. While this assumption is true in common project situations, in some peculiar contexts it is not. This is the case of the French national project for analysis of energetic agricultural farms, that is the case study of this paper. Here, the above-mentioned methods can hardly be applied because source data can only be identified and collected once user requirements indicate a need. Besides, the users involved in this project found it very hard to express their analysis needs in abstract terms, i.e., without visualizing sample results of queries, which in turn would require availability of source data. To solve this deadlock we propose ProtOLAP, a tool-assisted fast prototyping methodology that enables quick and reliable test and validation of data warehouse schemata in situations where data supply is collected on users’ demand and users’ ICT skills are minimal. To this end, users manually feed sample realistic data into a prototype created by designers, then they access and explore these sample data using pivot tables to validate the prototype.

Mots clés

Fichier non déposé

Dates et versions

hal-02599690 , version 1 (16-05-2020)

Identifiants

Citer

S. Bimonte, E. Edoh-Alove, H. Nazih, M. Kang, S. Rizzi. ProtOLAP: Rapid OLAP prototyping with on-demand data supply. International workshop on Data warehousing and OLAP, Oct 2013, San Francisco, United States. pp.61-66. ⟨hal-02599690⟩
6 Consultations
0 Téléchargements

Partager

Gmail Facebook X LinkedIn More