6th October 2019

wikipedia
11

What is a snowflake schema?

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..

Correspondingly, what is a star schema?

In computing, the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts. The star schema consists of one or more fact tables referencing any number of dimension tables.

What is the difference between OLAP and OLTP When is each used?

In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF). - OLAP (On-line Analytical Processing) is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations.

What is a galaxy schema?

Galaxy schema is a combination of many data marts. Galaxy schema also know as fact constellation schema because it is the combination of both of star schema and Snow flake schema.
Write Your Answer

Rate

100% people found this answer useful, click to cast your vote.

5 / 5 based on 2 votes.

Bookmark

Press Ctrl + D to add this site to your favorites!

Share