Definition: A schema is a collection of tables, views, indexes and synonyms. Each of these individuals are called schema objects. In simple terms terms we could say a schema is collection of database objects.
Schema plays a very important role when we design a data warehouse, because that would decide if the data warehouse we are building would serve its purpose. There are quite a few terminologies or types of schema. I am going to cover here a few which are very commonly used or reffered.
Before we get into that, it is important to note these are just design principles which are good to know but are not hard rules. Feel free to adapt as per your business requirements.
Commonly used schema types are:
Schema plays a very important role when we design a data warehouse, because that would decide if the data warehouse we are building would serve its purpose. There are quite a few terminologies or types of schema. I am going to cover here a few which are very commonly used or reffered.
Before we get into that, it is important to note these are just design principles which are good to know but are not hard rules. Feel free to adapt as per your business requirements.
Commonly used schema types are:
No comments:
Post a Comment