Data Ware House Schemas

Schema:

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.

Data Ware House Architectures

Data warehouses and their architectures vary depending upon the specifics of an organization's
situation. Three common architectures are:
 

• Data Warehouse Architecture (Basic)
• Data Warehouse Architecture (with a Staging Area)
• Data Warehouse Architecture (with a Staging Area and Data Marts)