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.