Multidimensional Model Design using Data Mining: A Rapid Prototyping Methodology

Sandro Bimonte, Lucile Sautot, Ludovic Journaux and Bruno Faivre
Additional contact information
Sandro Bimonte: IRSTEA, Clermont Ferrand, France
Lucile Sautot: TETIS, AgroParisTech, Montpellier, France
Ludovic Journaux: LE21, AgroSupDijon, Dijon, France
Bruno Faivre: University of Burgundy Franche-Comté, Dijon, France

International Journal of Data Warehousing and Mining (IJDWM), 2017, vol. 13, issue 1, 1-35

Abstract: Designing and building a Data Warehouse (DW), and associated OLAP cubes, are long processes, during which decision-maker requirements play an important role. But decision-makers are not OLAP experts and can find it difficult to deal with the concepts behind DW and OLAP. To support DW design in this context, we propose: (i) a new rapid prototyping methodology, integrating two different DM algorithms, to define dimension hierarchies according to decision-maker knowledge; (ii) a complete UML Profile, to define a DW schema that integrates both the DM algorithms; (iii) a mapping process to transform multidimensional schemata according to the results of the DM algorithms; (iv) a tool implementing the proposed methodology; (v) a full validation, based on a real case study concerning bird biodiversity. In conclusion, we confirm the rapidity and efficacy of our methodology and tool in providing a multidimensional schema to satisfy decision-maker analytical needs.

Date: 2017
References: Add references at CitEc
Citations:

Downloads: (external link)
http://services.igi-global.com/resolvedoi/resolve. ... 018/IJDWM.2017010101 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:igg:jdwm00:v:13:y:2017:i:1:p:1-35

Access Statistics for this article

International Journal of Data Warehousing and Mining (IJDWM) is currently edited by Eric Pardede

More articles in International Journal of Data Warehousing and Mining (IJDWM) from IGI Global
Bibliographic data for series maintained by Journal Editor ().