Skip to main content

Data Warehouse Management

Manage data warehouse including star/snowflake schema design, fact/dimension tables, SCD handling, and OLAP optimization.

Complexity: Complex | Duration: 30m+ | Category: Devops

Tags: data-engineering data-warehouse olap dimensional-modeling

Workflow Diagram​

Steps​

Step 1: Dimensional modeling​

Agent: database

architect - Identify facts, dimensions, measures

Step 2: Schema design​

Agent: database

architect - Design star or snowflake schema

Step 3: SCD strategy​

Agent: database

architect - Choose SCD Type 1, 2, or 3 for dimensions

Step 4: Fact table design​

Agent: database

architect - Additive, semi-additive, non-additive measures

Step 5: Dimension table design​

Agent: database

architect - Slowly changing dimensions

Step 6: Indexing strategy​

Agent: database

architect - Bitmap indexes, partitioning

Step 7: Aggregation tables​

Agent: data

engineer - Pre-aggregate for performance

Step 8: Query optimization​

Agent: database

architect - Optimize common OLAP queries

Usage​

To execute this workflow:

/workflow devops/data-warehouse-management.workflow

See other workflows in this category for related automation patterns.