6533b836fe1ef96bd12a156a
RESEARCH PRODUCT
Multidimensional Model Design using Data Mining: A Rapid Prototyping Methodology
Bruno FaivreSandro BimonteLudovic JournauxLucile Sautotsubject
Rapid prototypingData WarehouseUml ProfileComputer scienceEvolution02 engineering and technologycomputer.software_genreData WarehousesMethodologies and Tools020204 information systemsSchema (psychology)0202 electrical engineering electronic engineering information engineeringData Mining[INFO]Computer Science [cs]Conceptual-ModelOLAPOnline analytical processingInformationSystems_DATABASEMANAGEMENTUml profileClassificationData warehouseMultidimensional modelSupport vector machineHardware and Architecture020201 artificial intelligence & image processingData miningcomputerSupport-Vector-MachineSoftwaredescription
[Departement_IRSTEA]Ecotechnologies [TR1_IRSTEA]MOTIVE; International audience; 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.
| year | journal | country | edition | language |
|---|---|---|---|---|
| 2017-01-01 |