topic Re: Star schema or snowflake schema or flat file? in QlikView

Star schema or snowflake schema or flat file?

Thu, 05 Jun 2014 16:23:37 GMT

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

Re: Star schema or snowflake schema or flat file?

Thu, 05 Jun 2014 16:28:05 GMT

Here is a similar thread

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

Re: Star schema or snowflake schema or flat file?

Thu, 05 Jun 2014 16:29:28 GMT

And a link:

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

Re: Star schema or snowflake schema or flat file?

Thu, 05 Jun 2014 16:34:35 GMT

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.

Re: Star schema or snowflake schema or flat file?

Thu, 05 Jun 2014 17:30:45 GMT

thanks!

Re: Star schema or snowflake schema or flat file?

Thu, 05 Jun 2014 17:30:54 GMT

thanks!

Re: Re: Star schema or snowflake schema or flat file?

ashfaq_haseeb — Thu, 05 Jun 2014 17:45:54 GMT

Hi,

May be the attached document will help you.

Regards

ASHFAQ