Contract

• Input: source data descriptions, analytical questions, query patterns.
• Output: warehouse schema design + query optimisation notes.
• Side effects: none.
• Dependencies: none.
• Stop condition: schema saved; dimensions/facts defined.
• Risk: low.
• Boundary: designs schema; does not create warehouse resources.

Data Warehouse Modeling

Design an analytical warehouse schema — star / snowflake / OBT — with dimensions, facts, and query optimisation.

Process