Organizational Research By

Surprising Reserch Topic

What is Snow Flake Schema design in database? What’s the difference between Star and Snow flake schema?


Star schema is good when you do not have big tables in data warehousing. But when tables start becoming really huge it is better to denormalize. When you denormalize star schema it is nothing but snow flake design. For instance below customeraddress table is been normalized and is a child table of Customer table. Same holds true for Salesperson table.
asked Sep 13, 2013 in Database(DBMS) by rajesh
edited Sep 12, 2013
0 votes
34 views



Related Hot Questions



Government Jobs Opening


...