User Tools

Site Tools


glossary:s:star_schema
  • Bookmark "Star Schema" at del.icio.us
  • Bookmark "Star Schema" at Digg
  • Bookmark "Star Schema" at Furl
  • Bookmark "Star Schema" at Reddit
  • Bookmark "Star Schema" at Ask
  • Bookmark "Star Schema" at Google
  • Bookmark "Star Schema" at Netscape
  • Bookmark "Star Schema" at StumbleUpon
  • Bookmark "Star Schema" at Technorati
  • Bookmark "Star Schema" at Live Bookmarks
  • Bookmark "Star Schema" at Yahoo! Myweb
  • Bookmark "Star Schema" at Facebook
  • Bookmark "Star Schema" at Newsvine
  • Bookmark "Star Schema" at Yahoo! Bookmarks
  • Bookmark "Star Schema" at Twitter
  • Bookmark "Star Schema" at myAOL
  • Bookmark "Star Schema" at Slashdot
  • Bookmark "Star Schema" at Mister Wong

Star Schema

The star schema is a special type of database model, witch represent multidimensional data with the objective to optimise read operations in an efficient way. Main field of application is data warehouse and OLAP.

The name “star schema” comes from the fact that the tables (data’s in dimensions) are arranges in a star. In the centre is the fact table, around which several dimension tables. An improvement is the Snow Flake Schema. Thereby multidimensional tables are linked with join queries.

The advantage of this model is slicing down, perfomance increase and easy understanding of data.

  • Bookmark "Star Schema" at del.icio.us
  • Bookmark "Star Schema" at Digg
  • Bookmark "Star Schema" at Furl
  • Bookmark "Star Schema" at Reddit
  • Bookmark "Star Schema" at Ask
  • Bookmark "Star Schema" at Google
  • Bookmark "Star Schema" at Netscape
  • Bookmark "Star Schema" at StumbleUpon
  • Bookmark "Star Schema" at Technorati
  • Bookmark "Star Schema" at Live Bookmarks
  • Bookmark "Star Schema" at Yahoo! Myweb
  • Bookmark "Star Schema" at Facebook
  • Bookmark "Star Schema" at Newsvine
  • Bookmark "Star Schema" at Yahoo! Bookmarks
  • Bookmark "Star Schema" at Twitter
  • Bookmark "Star Schema" at myAOL
  • Bookmark "Star Schema" at Slashdot
  • Bookmark "Star Schema" at Mister Wong
glossary/s/star_schema.txt · Last modified: 2014/10/19 13:38 (external edit)