Toad World® Forums

Is Star Schema Simple in Database Design

Hello All, I want to know which is more simple in database design as between the star schema and snowflake schema. As I worked on the snowflake and its little bit more complex but I don't have an idea about star schema. Can anyone suggest to me.

Just a reminder, posters, that ToadWorld was meant to cater to product usability questions from Toad users, although we do try to help with general questions where we can. Toad product questions do get priority, please note.

That said, short answer is that, generally, star schema designs are simpler than snowflake designs. Major difference is that in star schemas, each dimension off the fact table is represented by one table. In a snowflake design, each dimension may need to be defined as multiple, normalized tables.

You'll find lots of good references online that will help explain this topic. Here's one I randomly selected: