Schema - What is a schema and what is it used for?

A schema is essentially the top level structure (topology) of a database.

It is what defines what tables will hold what and how they join together from table to table.

It is prevalent in all types of databases and also in data warehouse structures. It is this which is debated at design level in order to get the best out of the database and/or data warehouse.

There are different types of Schema including Start and Snowflake.

By using, you agree to our use of cookies to enhance your experience.