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.