A requirement-driven approach to the design and evolution of data warehouses
作者：
Highlights：
• We present a semi-automatic approach for an iterative design of MD schemas from a set of information requirements.
• We introduce novel algorithms for integrating MD schemata, each schema satisfying one or more requirements.
• Produced schemas are guaranteed to subsume all requirements, preserve the MD integrity constraints, and meet the user defined objectives.
• We introduce the traceability metadata to systematically record information about the best integration opportunities.
• We evaluate our approach by using a prototype and empirical tests which demonstrated the need for automated MD design.
摘要
Highlights•We present a semi-automatic approach for an iterative design of MD schemas from a set of information requirements.•We introduce novel algorithms for integrating MD schemata, each schema satisfying one or more requirements.•Produced schemas are guaranteed to subsume all requirements, preserve the MD integrity constraints, and meet the user defined objectives.•We introduce the traceability metadata to systematically record information about the best integration opportunities.•We evaluate our approach by using a prototype and empirical tests which demonstrated the need for automated MD design.
论文关键词：DW,ETL,Multidimensional design,Conceptual design
论文评审过程：Available online 24 January 2014.
论文官网地址：https://doi.org/10.1016/j.is.2014.01.004
