What are the different types of schema used in Qlikview?

There are two types of the schema used in Qlikview. They are Star Schema and Snowflaking schema. The schema in Qlikview is a dimensional model to store data.

• Star schema: It is a common dimensional model as it uses simple dimensions and facts to organize data. Both fact and dimension are interlinked just like front-end and back-end applications. A fact is an event that takes place when input data is given. The dimension stores the information the fact is associated with. For example, if a user logins a page then the login is the fact and the information entered is the dimension. This scheme is collected for a particular table and is represented in the form of a star. It contains facts and dimensions next to each other. When all of them is put together a start schema is formed.
• Snowflaking schema: It is just an extension to the star schema. As the data increases additional dimensions may have to be added. We can add these new dimensions on the star schema through a relational environment. In this, the dimensions become multiple relational dimensions. When we represent this type of schema, the external extensions from a star schema give a snowflake-like pattern. Hence, this is called Snowflaking schema.