Star schema or snowflake schema or flat file?

[#1]

Hi,

I have only one short question regarding data model.

If we have small data set than it is probably not so important how we structure our data model (all data in a one flat file).

The question is: if we have larger data sets, should we always tray to build a star schema in our data model?

Snowflake has more joins (it is more normalized) and i think we could suffer some performance penalties in case of a larger data sets.

Is my thinking correct? Please write down some opinions.

Regards,

Jurij

[#2]

Here is a similar thread

which schema is best for data modeling betwen star and snowflake?

[#3]

And a link:

http://kulbirminhas.wordpress.com/2012/02/28/optimizing-data-model-qlikview/

[#4]

Star schema will always be better in terms of response time, RAM consumption and the actual run-time of the script versus snowflake or flat file when using large data sets.

[#5]

thanks!

[#6]

thanks!

[ashfaq_haseeb · Accepted solution]

Hi,

May be the attached document will help you.

Regards

ASHFAQ