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) 

Data WareHouse Definition

A Data Warehouse (DW) is a database used for reporting. The data is offloaded from the operational systems for reporting. The data may pass through an operational data store for additional operations before it is used in the DW for reporting.