Data Warehousing Schemas

A schema is a collection of database objects, including tables, views, indexes, and synonyms. You can arrange schema objects in the schema models designed for data warehousing in a variety of ways. The model of your source data and the requirements of your users help you design the schema. We can sometimes get the source model from your company's enterprise data model and reverse-engineer the logical data model for the data warehouse from that. The physical implementation of the logical data warehouse model may require some changes to adapt it to your system parameters—size of machine, number of users, storage capacity, type of network, and software.There are three types of schema
1) Star Shema
2) Snow flake Shema
3) Galaxy Shema