DEPARTMENT OF TECHNOLOGY
COMPUTER INFORMATION SYSTEMS 4013
4013 Data Warehousing, 3 hours credit
The strategies and processes for Data Warehousing of large relational databases. Topics include: understanding the role of data warehousing to businesses, understand data warehousing as a management tool, data warehousing as an emerging architecture and a data warehouse as it is designed to support the decision support system (DSS) function.
Prerequisite: CIS 3183 or departmental permission.
EXPANDED COURSE DESCRIPTION:
The strategies and processes for Data Warehousing of large relational databases.
|Upon completion of the course students should:||PROGRAM OBJECTIVE|
|.... Understand the role of data warehousing to businesses and the compelling need for data warehousing.||I2,P3|
|.... Understand data warehousing as a management tool and know what are the building blocks of a data warehouse.||I2,I3|
|.... Understand data warehousing as an emerging architecture and what the trends are in data warehousing.||I2,I3|
|.... Know how to plan a data warehouse project and what are the differences in this project as to other IT projects.||A3|
|.... Understand the architectural components and infrastructure of data warehousing.||I3,I2|
|.... Understand Data Design and the Data Preparation involved in data warehousing.||A1|
|.... Understand how data warehouse is designed to support the decision support system function and how to get information from the data warehouse.||A3|
|.... Know how to implement and maintain a data warehouse.||I3|
|.... Apply the techniques learned on a potential/real business problem using a data warehouse.||A3|
This is a participatory class -- assignments will be given weekly, and students need to be present to assure comprehension.
Marakas, George, Modern Data Warehousing, Mining & Visualization, Pren Hall 2002, ISBN: 0-13-101459-5.
Bischoff, Joyce & Alexander, Ted.