A star schema aims to separate the factual information about a business from its descriptive, or “dimensional” information. Prices, weights, speeds, and quantities are all considered factual data.

Yahoo’s data and business intelligence architect, Rohit Chatter, answers the latest debate, Star versus Snowflake schema, by breaking down the differences, one aspect at a time.

Ariga, an Israeli startup, has come up with a way to write database schema as code with an open source and SaaS version of the solution.