Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
- 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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Modern Database Management
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
12th edition
133544613, 978-0133544619
