1. Can you provide a comparison between or differentiate database and data warehousing?
2. Explain and discuss the architecture of data warehousing?

3. What are the three primary components of data warehousing?

4. Can you define the term "subject-oriented" as it pertains to data warehousing?
 

Transcribed Image Text:

Source Data Systems Data Staging Area Data & Metadata Storage Area -------------- Extract Processing clean reconcile derive match Extract combine remove dups standardize transform Extract confo dimensions Internal External Cleaned dimension data Load L' Load Load E Extract export to data Load marts Load Data Mart Data Mart Data Mart Data Mart (1) (1) (1) (1) (1 Data Mart Model query results End-User Presentation Tools Ad hoc query tools matched to presentation format Report writers End-user applications Modeling/ mining tools Visualization tools Source Data Systems Data Staging Area Data & Metadata Storage Area -------------- Extract Processing clean reconcile derive match Extract combine remove dups standardize transform Extract confo dimensions Internal External Cleaned dimension data Load L' Load Load E Extract export to data Load marts Load Data Mart Data Mart Data Mart Data Mart (1) (1) (1) (1) (1 Data Mart Model query results End-User Presentation Tools Ad hoc query tools matched to presentation format Report writers End-user applications Modeling/ mining tools Visualization tools