Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q 7 . 1 1 Explain the following parts of the data warehouse definition ( 4 points ) : structured repository integrated subject - oriented
Q Explain the following parts of the data warehouse definition points:
structured repository
integrated
subjectoriented
enterprisewide
historical
timevariant
developed for the retrieval of analytical information
may include the data at the fine level of detail or summary data or both
Q What are the major components of a data warehousing system? point
Q What is a data mart? point
Q What is the difference between a dependent and an independent data mart? point
Q What are the steps in the development of data warehouses? point
Q Explain the iterative nature of the warehouse requirements collection, definition, and visualization process. point
Q Briefly describe the process of creating a data warehouse. point
Q Briefly describe the process of creating ETL infrastructure. point
Q Briefly describe the process of developing data warehouse frontend BI applications. point
Q What takes place during data warehouse deployment? point
Q What constitutes data warehouse use? point
Q Give examples of data warehouse administration and maintenance activities. point
Q What are the similarities and differences between the development of the initial and subsequent versions of the data warehouse? point
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