Computer Science Homework Help

Q1 What is the primary purpose of a data warehouse?

Q2 Why is a data warehouse created as a separate data store?

Q3 Describe the difference in queried amounts of data and frequency of queries between

operational and analytical data.

Q4 Describe the data redundancy difference between operational and analytical data.

Q5 Explain the following parts of the data warehouse definition:

-structured repository

-integrated

-subject-oriented

-enterprise-wide

-historical

-time-variant

-developed for the retrieval of analytical information

-may include the data at the fine level of detail or summary data or both

Q6. In no less than 150 words write about the main differences of dimensional modeling versus relational modeling. SQL Datawharehouses and Business analytics using dimensional modeling . Why is that? Talk about redundancy and the Fact table. Is it better relational modeling than dimensional modeling? Explain anyone please search online and leave a link.