Conceptual, Logical, and Physical Design of Data Warehouses

1. Conceptual, Logical, and Physical Design ofData Warehouses DOLAP 2004 Sergio Luján-Mora

2. Current DW modeling Own formalisms None accepted as a standard • Conceptual modeling recognized as an important phase for DW design • Different approaches for conceptual modeling: • Golfarelli, Rizzi • Husemann et al. • Sapia et al. • Tryfona et al. • Abello et al. • Trujillo et al. • … Extend standard formalisms

3. Current DW modeling • Rich conceptual models • Ability to represent as many important semantic features as possible . • For example: complex classification hierarchies (e.g. Non-strict, non-covering, etc.)

4. Current DW modeling • Logical models? • Star schema • Multidimensional models • Physical models? • Practically, no research • Implementation? • Not all the important features of rich conceptual models are directly supported by most of commercial tools

5. Ideal DW modeling • Tackle the conceptual, logical, and physical design in an integrated framework • Same modeling language • Different levels of abstraction • Overlapping diagrams and automatic mapping transformation between diagrams

6. Ideal DW modeling • Automatically generate different information (as much as possible) • Database schema • Metadata • Query navigation patterns • Information accepted by DW platforms • Is CWM the solution? • Enough information? • Metrics to provide quality feedback in the design process