Assignment

Write a 2-3 page paper to address the issues below.

"DBMS and Datawarehousing -- I"

While working as a database analyst for a national sales organization, you are asked to be part of its data warehouse project team.

1. Prepare a high-level summary of the main requirements to evaluate DBMS products for data warehousing.

2. Suppose you are selling the data warehouse idea to your users. How would you explain to them what multidimensional data analysis is and its advantages?

3. The Data Warehousing project group has invited you to provide an OLAP overview before making a commitment. The group's members are particularly concerned about the OLAP client/server architecture requirements and how OLAP will fit in the existing environment. Your job is to explain to them the main OLAP client/server components and architectures.