Welcome to the data-warehouse wiki!

Inmon data warehouse

• Defined by Bill Inmon
• Top-Down Approach
  • design an enterprise-wide data model/view first
  • align with waterfall
  • Seek for executive sponsor for a centralized data warehouse as Single source of truth first.
• Uses a normalized data model
• Adopter: Converged database (Oracle)

Kimball data warehouse

aka. Business dimensional lifestyle approach

• Defined by Ralph Kimball
• Bottom-Up Approach start from downstream (e.g. Data Proudct, user-friendly data structures)
• Build denormalized or dimensional data marts first. Combine into data warehouse later.

links

• data model
• table column types