Date of Award

Spring 5-1-2003

Document Type

Thesis

Degree Name

Master of Science in Information Systems (MSIS)

First Advisor

Ronghua Shan

Second Advisor

Terry Dennis

Third Advisor

Stephen Krebsbach

Fourth Advisor

Sartaj H. Iram

Abstract

I have been working in the field of Information Technology since my graduation in Computer Sciences from Gomal University of Pakistan in 1992. I have been working as an Oracle Database Administrator since 1995 and databases is one of my favorite subjects and that is why I chose Data Management concentration in MSIS program. After attending INFS 684, INFS 786 and INFS 787, I decided to work on data warehouse project as part of MSIS partial requirement. I was already aware of the data warehouse importance as being the part of database management. In this competing business environment the information technology is playing a major role and data warehouse or decision support systems have the leading edge on business competitors. However, this is also true that several companies are still struggling to build the data warehouses and decision support systems. In my whole experience as an Oracle OBA, I saw very few companies who developed some of the state of the art decision support systems. Some companies are just dumping their online transaction systems in separate databases as it is. When such databases grow, the reports run forever because of not having proper data warehouse design which could have data spread across dimensions and some de-normalization according to reports requirements. In this project, I have tried to design a data warehouse for Solocup, which will address all of the issues discussed above.

Comments

dsu-th-023

Download

Share

COinS