Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. 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

Hi,

May be the attached document will help you.

Regards

ASHFAQ

View solution in original post

6 Replies
Not applicable
Author

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

Hi,

May be the attached document will help you.

Regards

ASHFAQ

View solution in original post