self assessment: Data Warehouse

Self Assessment Questions/Discussion Topics

1. Define a data warehouse, and list some of its characteristics.
2. What is the difference between a database and a data warehouse?
3. Describe OLAP.
4. Discuss the relationship between multiple sources of data, including external data, and the data warehouse.
5. Explain the relationship between SQL and a DBMS
6. Describe multidimensionality and explain its potential benefits for MSS/DSS.