--%>

Starschema and snowflake schema

When should a star schema be used and when a snowflake schema should be used, explain in brief?

E

Expert

Verified

A star schema refers to a simplest data warehouse schema. Snowflake schema is same as that of the star schema. It generally normalizes the dimension table in order to save the data storage space. It may be used in order to represent the hierarchies of the information.

   Related Questions in Biology

  • Q : Name of the DNA duplication procedure

    Write down the name of the DNA duplication procedure? And also write down the main enzyme which participates in it?

  • Q : Concentration of auxin in the plant

    What will happens when the concentration of the auxin in some of the structures of the plant is over the action range of hormone?

  • Q : Effects of the formation of

    Describe how does the formation of the enzyme-substrate complex elucidate the decrease of the activation energy of chemical reactions?

  • Q : What is Turnaround Management

    Turnaround Management: It is a group of administration methods employed by organizations in the financial distress. Professionals in the field are extremely trained and specialize in thecorporate organization and assessment. The primary goal in most t

  • Q : Thyroid-stimulating hormone blood level

    What occurs to the TSH (or thyroid-stimulating hormone) blood level in the hypothyroidism? Why is there enlargement of thyroid in the endemic goiter disease?

  • Q : Features of Health and Safety What are

    What are the features of Health and Safety (H & S) in a risky areas of an organization?

  • Q : Illustrate that hormones are only

    Explain, Are hormones only proteins?

  • Q : Shortages occur while price controls

    Why is it true that shortages generally occur mainly while price controls are in effect?In the absence of price controls the shortage generally goes away quickly since prices are bid up to eliminate the excess demand. But along with price contro

  • Q : Biological troubles which molluscs face

    Write down the biological troubles which molluscs face due to soft body?

  • Q : How is the gas exchange completed in

    How is the gas exchange completed in mammals? Answer: Mammals breathe via lungs, and their respiration is pulmonary.