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

• 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