Ch. 2: Data Warenhousing

Ch. 2: Data Warenhousing

1. Definition

   • Pool of data produced to support decision making
     • Characteristics
       • Subject oriented
       • Integrated
       • Time variant
       • Nonvolatile
       • Web based
       • Relational/Multidimensional
       • Client / Server
       • Real time
       • Invlude Metadata

2. Major Components

   • Data sources
   • ETL Process
   • Data loading
   • Metadata
   • Middleware tools

3. DW Arquitectures

   • Two tier DW
   • Three tier DW
   • Highest level
     • Enterprise-wide DW
     • Data Marts

4. Data Integration & ETL

   • Enterprise Application integration
   • Enterprise Information Integration
   • Service-oriented architecture
   • Extraction, transformation and Load (ETL)

5. Implementation approaches

   • Inmon Model
     • Top-down development
   • Kimball Model
     • "Plan big, build small" - Department oriented scope
   • Analysis of Data
     • Online Analytical Processing : OLAP
     • Online Transactional Processing System ::OTLP

6. History

   • 1970: Rutine reporting
   • 1980: relational DBMS
   • 1990: Data Warehousing was born
   • 2000: BI popularized
   • 2010: Big Data Analytics

7. Types of DW

   • Data Marts
   • Operational Data Stores
   • Enterprise DW