This course has been designed to show the student the differences between designing data warehouses and traditional systems for the online transaction processing (OLTP) environment.
It will emphasize the need for understanding business requirements and developing an appropriate warehouse architecture
as the foundation for the warehouse. An enterprise or subject area data model serves as the starting point for designing the warehouse. The course will then discuss the design of the various types of structures found within a typical data warehouse, such as detail data, summary data, multi-dimensional data, external data, specialized subsets, etc.
The tradeoffs in designing for efficient data retrieval, loading, and data management will be considered. The maintenance and use of metadata throughout the life cycle will be considered. It will also discuss partitioning, parallel processing, replication, and other issues.