Data Warehouse Schemas
Create star schema and snowflake schema diagrams for data warehouse documentation. Use ERD tables and auto-layout to visualise fact and dimension tables.
Data warehouse schemas organise data for analytics and reporting. NeoArc Studio supports star schema and snowflake schema diagrams using ERD tables with specialised layouts.
Star Schema
A star schema consists of a central fact table surrounded by dimension tables. The layout resembles a star with the fact table at the centre.
Creating a Star Schema
Snowflake Schema
A snowflake schema normalises dimension tables, creating additional levels of hierarchy. Dimension tables branch out from the fact table like snowflake arms.
Creating a Snowflake Schema
Visual Conventions
Use visual conventions to distinguish table types:
Auto-Layout for Data Warehouse
Use NeoArc's auto-layout options: