Dimension Enrichment with Factual Data During the Design of Multidimensional Models: Application to Bird Biodiversity [chapter]

Lucile Sautot, Sandro Bimonte, Ludovic Journaux, Bruno Faivre
2015 Lecture Notes in Business Information Processing  
Data warehouses (DW) and OLAP systems are business intelligence technologies allowing the on-line analysis of huge volume of data according to users' needs. The success of DW projects essentially depends on the design phase where functional requirements meet data sources (mixed design methodology) (Phipps and Davis, 2002) . However, when dealing with complex applications existing design methodologies seem inefficient since decision-makers define functional requirements that cannot be deduced
more » ... m data sources (data driven approach) and/or they have not sufficient application domain knowledge (user driven approach) (Sautot et al., 2014b) . Therefore, in this paper we propose a new mixed refinement design methodology where the classical data-driven approach is enhanced with data mining to create new dimensions hierarchies. A tool implementing our approach is also presented to validate our theoretical proposal.
doi:10.1007/978-3-319-29133-8_14 fatcat:e7ma2eepuba4jmxotbefkeswum