Data Warehousing

Dr. Kailash Joshi
215 CCB
University of Missouri-St. Louis
Phone: (314) 516-6123
E-mail: joshi@umsl.edu

Description

This course provides an introduction to data warehouse design. Topics in  data modeling, database design and database access are reviewed.  Issues in data warehouse planning, design, implementation, and administration are discussed in a seminar format.   The role of data warehouse in supporting Decision Support Systems (DSS) is also reviewed.

Texts

  1. The Data Warehouse Toolkit by Ralph Kimball - John Wiley & Sons Publications.
  2. Decision Support in the Data Warehouse by Paul Gray, Hugh J. Watson - Prentice Hall.

The course will be organized in a seminar format. Students will be required to undertake a data warehouse design and implementation study and submit a detailed project report. There will be one final examination at the end of the course.

Schedule

Grading

Final examination: 50%
Project: 30%
Class participation: 20%

Required Readings

  1. The Decision Maker's Goldmine: The Data Warehouse  DATAMATION, March 15, 1995, pp. S6-S13.
  2. An Introduction to Multi Dimensional Database Technology
  3. Understanding the need for On-Line Analytical Servers
  4. Providing OLAP(On-line Analytical Processing) to User-Analysts: An IT Mandate
  5. Patterns of Data Mart Development
  6. Data Warehouses, Ad Hoc Query Tools
  7. Prism Solutions
  8. Data Warehousing Technology
  9. Bringing Performance to Your Data Warehouse
  10. The Role of the OLAP Server
  11. Data Warehousing Technology
  12. Ten Mistakes to Avoid
  13. Case Study I - Harris Semiconductor
  14. Case Study II - The Woolworths Story
  15. Case Study III - The Ertl Story
  16. Data Mining: A technology Comes of Age
  17. Data Warehouse - A one-stop resource
  18. Dmreview - Online electronic version

 

Additional Sources

  1. White Papers
  2. Data Warehouse Information Center
  3. Index of Resources/Articles