--%>
Assignment Help - homework help

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 : Control of the females body temperature

    How can the ovulation date be estimated with control of the female's body temperature?

    		•
  • Q : Explain Electronic Data Interchange or

    Electronic Data Interchange (EDI): The predecessor to electronic commerce, EDI has been appropriate only for big North American and European corporations and banks. Firms employing EDI are interconnected via a global computer network, independent of i

    		•
  • Q : Problem on enhancing marketing plan A)

    A) Illustrate the company’s competitors and strengths and weakness of each.B) Illustrate how you plan to differentiate your company from the closest competitor.C) Illustrate the company’s intention to be a leader or follower within the industry

    		•
  • Q : What is Prefeasibility Analysis

    Prefeasibility Analysis: Should include reports on potential projects: not too detailed – just sufficient to indicate general promise of alternative projects. could utilise project screening and project analysis grids as

    		•
  • Q : What is the life cycle of ascaris What

    What is the life cycle of ascaris?

    		•
  • Q : Function of crystalline cells Explain

    Explain the function of the crystalline cells?

    		•
  • Q : Uses of karyotyping Briefly mention

    Briefly mention some uses of karyotyping?

    		•
  • Q : Main classes in which phylum are divide

    Write down the main classes in which phylum are divide? Write down some examples of each and in which form (polyp or medusae) are they found?

    		•
  • Q : Explain Marketing Strategy and

    Marketing Strategy and Marketing plan: Before we proceed with outlining the market strategy and marketing plan, it is desirable to learn about the subtle difference between the two. The marketing strategy is a more comprehensive concept than marketing

    		•
  • Q : Throughput Factor-Group

    This refer to all aspects of the group processes and dynamics that result in task performance and member satisfaction. Some of these are the norms developed on groups, group cohesiveness, decision making processes used by the group and the extent of task and maintenance activities performed by th

    		•