Scribd
Upload
5 views12 pages

Notes

The document explains three data warehouse schemas: Star Schema, Snowflake Schema, and Fact Constellation Schema. The Star Schema features a simple design with fact and dimension tables forming a star-like structure, while the Snowflake Schema normalizes dimension tables to reduce redundancy. The Fact Constellation Schema supports complex analysis with shared dimensions across multiple fact tables, making it suitable for large enterprise data warehouses.

Uploaded by

nlvh.hana
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
5 views12 pages

Notes

The document explains three data warehouse schemas: Star Schema, Snowflake Schema, and Fact Constellation Schema. The Star Schema features a simple design with fact and dimension tables forming a star-like structure, while the Snowflake Schema normalizes dimension tables to reduce redundancy. The Fact Constellation Schema supports complex analysis with shared dimensions across multiple fact tables, making it suitable for large enterprise data warehouses.

Uploaded by

nlvh.hana
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd

You might also like