Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Star schema or snowflake schema or flat file?

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

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Hi,

May be the attached document will help you.

Regards

ASHFAQ

View solution in original post

6 Replies
Not applicable
Author

Not applicable
Author

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.

Not applicable
Author

thanks!

Not applicable
Author

thanks!

ashfaq_haseeb
Champion III
Champion III

Hi,

May be the attached document will help you.

Regards

ASHFAQ