Categories

Dec 27, 2019 in Data Science

Q: star schema and snowflake schema

1 Answer

Dec 27, 2019

It is a traditional database schema with a central table. Satellite tables map IDs to physical names or descriptions and can be connected to the central fact table using the ID fields; these tables are known as lookup tables and are principally useful in real-time applications, as they save a lot of memory. Sometimes star schemas involve several layers of summarization to recover information faster.

In computing, a snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake shape. The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.
Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

Madanswer
Dec 27, 2019 in Data Science
Oct 20, 2019 in Dataware house
May 17 in Python
...