Untitled

Introduce el texto aquí

1. Dimensional Modeling

   • Design technique for data warehouses,
     • Strengths
       • Reduces complexity of structure
       • Optimize query performance
     • Weaknesses
       • Restricts the way data can be analyzed
       • Not all inf. can be represented in dimensional form

2. Transformación ER Model - Dimensional

   • Classify Entities
     • Transaction
     • Component
     • Classification
   • high-level star schema design
     • Summarize
     • identify important dimensions
   • Design detailed fact table
     • D. Key
     • D. Facts
   • Design detailed dimension table
     • D. Dimensional key
     • Collapse hierarchies
     • Codes and abbreviations

3. Relationship

   • One can be transformed into the other one
   • Dimensional model is the restricted form of an ER
   • Subsetting, denormalization and summarization is the process to transform an ER

4. Why it works?

   • Organizes data into a separate star schemas
   • Hierarchy