As per Querry Performance which type of schema is best? and Why?
As per Querry Performance which type of schema is best? and Why?
For performance wise, Its better to go for a Star Schema rather than going for Snow-flake schema.Originally Posted by raghuladdu
A Star Schema is simple data warehouse schema which consists of a single Fact table surronded by multiple dimensional tables.
Advantages:
- Easy to understand
- Easy to Navigate b/n the tables due to less number of joins.
Disadvantages:
- Occupies more space
A Snowflake schema is a Data warehouse Schema which consists of a single Fact table and multiple dimensional tables. These Dimensional tables are normalized.
Advantages:
- These tables are easier to maintain
- Saves the storage space.
Disadvantages:
- Due to large number of joins, it is complex to navigate
Last edited by sanghala; 05-16-2007 at 04:48 AM.
Sanghala
If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
Another schema beyond Star & Snow-flake
There is another popular schema called Constellation Schema in which one dimension table is accessed by one more than one Fact table.
In this type of schema, there may be one or more than one number of Fact tables and also Dimension Tables.
It sometimes also called as Galaxy Schema..
Sanghala
If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
Another schema beyond Star & Snow-flake
Constellation Schema :
This schema is used according to the requiremnt of the client.
Ex: Banking, Insurance, Travel & Hospitality etc.,
Last edited by sanghala; 05-16-2007 at 04:46 AM.
Sanghala
If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
Posting Permissions
Reply With Quote