DATAWAREHOUSE (2/2 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to: Identify the basic concepts, components, environment, architecture and technologies of data warehouse; Explain the requirements and how to design data warehouse; Analyze collection of data and techniques for processing the data in data warehouse; Analyze the strategy of design and implement data warehouse appropriate to the need.

Topics:

1. Data Warehousing Concepts;
2. The Data Warehouse Environment;
3. Data Warehousing Design;
4. The Relational and the Multidimensional Models as a Basis for Database Design;
5. The Data Warehouse and the ODS;
6. Granularity in the Data Warehouse;
7. The Data Warehouse and Technology;
8. External/Unstructured Data and the Data Warehouse;
9. OLAP;
10. Migration to the Architected Environment;
11. The Distributed Data warehouse;
12. The Data Warehouse and the Web.