Page 79 - CITS - Computer Software Application -TT
P. 79
COMPUTER SOFTWARE APPLICATION - CITS
5 Star Schema
The star schema represents an alternative schema design approach for data organization. It excels in managing
and analyzing vast volumes of data and operates based on the concepts of “Facts” and “Dimensions”. In this
context, a fact corresponds to a numerical data point that drives business processes, while a dimension
provides context and description to the facts. The Star Schema is particularly effective for structuring data
within Relational Database Management Systems (RDBMS).
6 Snowflake Schema
The snowflake schema is a modification of the star schema. In the star schema, there exists a central “Fact”
table housing primary data points with references to its associated dimension tables. However, in the snowflake
schema, dimension tables have the potential to branch out into their own additional dimension tables, creating
a more intricate hierarchical structure.
66
CITS : IT&ITES - Computer software application - Lesson 18 - 36