Datenwarehouse (EN)

Technology

Central database for structured corporate data

Architecture

flowchart TD     A[Data sources] --> B[ETL process]     B --> C[Staging area]     C --> D[Data warehouse]     D --> E[OLAP system]     D --> F[Data marts]     E --> G[BI tools/Reporting]     F --> G     G --> H[End users]

Characteristics

Subject-oriented
Time-oriented (historical data)
Integrated (data from various sources)
Non-volatile (data is not deleted)
Optimized for queries and analyses

Quelle: AI Generated