MET CS 689 Designing and Implementing a Data Warehouse
Description: This course provides students with the technical skills required to plan, implement, and maintain a data warehouse using a DBMS such as Oracle Warehouse Builder. It describes basic data warehousing concepts. Key topics: Design a data warehousing system; implement a database designed with a star schema, gather data from primary data sources, transform data, and load data in to a DBMS. Students will create a cube using OLAP and analyze cube data using client applications. Upon successful completion, students will be familiar with the typical data warehouse components and architecture, and have an understanding of the practical uses of data warehousing. 4 credits.