Question: Can you provide a comparison between or differentiate database and data warehousing? Explain and discuss the architecture of data warehousing? 3. What are the three

  1. Can you provide a comparison between or differentiate database and data warehousing?
  2. Explain and discuss the architecture of data warehousing?
Source Data Systems Data Staging Area Data & Metadata Storage Area --------------


Extract Processing clean reconcile derive match Extract combine remove dups standardize transform


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

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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!