Question: The data warehousing project group has invited you to provide
The data warehousing project group has invited you to provide an OLAP overview. The group’s members are particularly concerned about the OLAP client/server architecture requirements and how OLAP will fit the existing environment. Your job is to explain to them the main OLAP client/server components and architectures.
Answer to relevant QuestionsThe project group is ready to make a final decision between ROLAP and MOLAP. What should be the basis for this decision? Why?In the star schema context, what are attribute hierarchies and aggregation levels and what is their purpose?One of your vendors recommends using an MDBMS. How would you explain this recommendation to your project leader?What is the SQL command to list the total sales by customer, month and product, with subtotals by customer and by month and a grand total for all product sales? Give some example of database connectivity options and what they are used for.
Post your question