What is star schema in SQL?

devquora
devquora

Posted On: Feb 22, 2018

 

The star schema in computing is the basic data mart schema style. It is commonly used for developing both dimensional data marts and data warehouses. It is made up of either 1 or more than one fact table. It references any of the numbers at the dimension tables. The importance of star schema to snowflake schema case can not be overstated. The handling of simpler queries is effectively carried out more with star schema. The name "star schema" is gotten from the physical shape of a star and at its centre has a fact table. It is surrounded by the dimension tables which represent the points of the star.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    SQL Server Interview Questions

    What are a database and a data warehouse?

    A database, in general, is a collection of information in a more organized form for better access...

    SQL Server Interview Questions

    What is normalization according to you and explain its different levels?

    In order to remove the redundant data, normalization is used. It also reduces the null values and enables the efficiency of indexing...

    SQL Server Interview Questions

    What do you understand by the denormalisation?

    Denormalization is the inverse process of normalization...