Skip to content

Star

Benifits

  • Demoralized
  • Simplifies Queries
  • Fast aggregations

Drawbacks

  • Issues that come with demoralization
  • Data Integredy
  • Decrese query flexibility
  • Many to many relationship -- simplified

Goals of the Star Schema

  • Easy to understand
  • Fast analytical query performance

Sources