A requirement-driven approach to the design and evolution of data warehouses
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