Data Literacy Geek
Navigation
  • Home
  • The Geeks
  • Insightclopedia
  • Blog
  • Search
  • Home
  • The Geeks
  • Insightclopedia
  • Blog
  • Search
A B C D E F G H I J K L M N O P Q R S T U V W X Z
-->

Star schema

A modeling technique used in dimensional modeling. A relational design in which from one central table (fact table) there are references to one or more other tables (dimension tables). Descriptive characteristics: qualities. Analysis variables (measured values): quantities. All joins are only 1 level deep. The analysis variables can be found in the fact table (below the line). The fact table also contains references to the dimension tables (these references are called “foreign key” and are above the line). In the dimension tables you will find the descriptive characteristics.

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OK