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.
Never Miss an Articles from us.
A database, in general, is a collection of information in a more organized form for better access...
In order to remove the redundant data, normalization is used. It also reduces the null values and enables the efficiency of indexing...
Denormalization is the inverse process of normalization...