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.

tut

Using the powerpoint slides and the text as resources to help you, answer the following six questions about the model used in activity 1 above:

1. If someone asked you what type of decision-making model this was, how would you describe it?
2. Does this modelling tool (influence diagrams) cater for multiple goals?
3. Is your model allowing for uncertainty? if so, how?
4. Is this decision probabilistic? Explain why or why not.
5. What are heuristics?
6. Does this modelling tool allow for Heuristics? Explain