Wednesday, January 23, 2019

Galaxy schema


  • Is a combination of both star schema and snow flake schema
  • Has many fact table and some common dimension table
  • Can also be referred as a combination of many data marts
  • It is also known as fact constellation schema 

1 comment:

  1. I remember struggling so much with data warehousing concepts during my university days, and this exact topic used to confuse me until a friend explained it just like this. This breakdown makes understanding a galaxy schema so much easier, especially how it links multiple fact tables together. I actually had to write a massive research paper on database architectures last semester and realized that getting external help makes a huge difference when you are stuck. If any students here are currently overwhelmed with their technical database write-ups, I highly recommend using Assignment Help Canada to save a lot of time and stress.

    ReplyDelete