Official government website of the Government of Kingdom of Saudi Arabia
Link to official Saudi websites end with edu.sa

All links to official educational websites in the Kingdom of Saudi Arabia end with sch.sa or edu.sa

Government websites use the HTTPS protocol for encryption and security.

Secure websites in the Kingdom of Saudi Arabia use the HTTPS protocol for encryption.

Registered with the Digital Government Authority under number:

20250417892
Main
UQU Programs
Data Science

Data Integration and Warehousing

DS2202
3 hours English

Data Integration and Warehousing

Data Integration and Warehousing
DS2201 Introduction to Database
3 hours No requisites
1 Heterogeneity of data
2 Autonomous and distributed data sources
3 Structured vs. unstructured data
4 Preprocessing and Cleaning
5 Data Integration: Mediated schemata and query rewrite
6 Data Integration: Schema matching
7 Data Integration: Schema mappings
8 Data Exchange and transformations
9 Basic Concepts of Data Warehousing
10 Data warehousing- Online analytical processing (OLAP) and data mining
11 Data Warehousing architecture, Design and modeling
12 Data marts architecture and design
13 Project Discussion
1.1 Mapped to: K1

Given a description of a situation requiring data integration students will be able to classify it as belonging to one of a number of standard scenarios.

Teaching Strategy Lectures, Lab sessions Problem sets
Assessment Methods Quizzes and/or Online Quizzes, Midterm, Final Exam Lab exam
1.2 Mapped to: K2

Know the definition and applications of a data warehouse and the architecture and processes of a data warehouse.

Teaching Strategy Lectures, Lab sessions Problem sets
Assessment Methods Quizzes and/or Online Quizzes, Midterm, Final Exam Lab exam
2.1 Mapped to: S1

Ability to compare & evaluate different data integration solutions & justify the choice of one solution over another.

Teaching Strategy Lectures Problem sets Project
Assessment Methods Quizzes and/or Online Quizzes, Midterm, Final Exam Lab exam
2.2 Mapped to: S1

Given a description of a data integration & exchange scenario where access to data is restricted, students will be able to design a scheme to provide approximate results to queries taking account of restricted access.

Teaching Strategy Lectures Problem sets Project
Assessment Methods Quizzes and/or Online Quizzes, Midterm, Final Exam Lab exam
2.3 Mapped to: S1

Given two database schemas students will be able to specify mappings between schemas & how to compose such mappings.

Teaching Strategy Lectures Problem sets Project
Assessment Methods Quizzes and/or Online Quizzes, Midterm, Final Exam Lab exam
2.4 Mapped to: S2

Understand dimensional modeling and design database schemas for a data warehouse.

Teaching Strategy Lectures Problem sets Project
Assessment Methods Quizzes and/or Online Quizzes, Midterm, Final Exam Project
3.1 Mapped to: V1

Use data integration software tools

Teaching Strategy Lab sessions
Assessment Methods Project
3.2 Mapped to: V1

Use data warehousing tools to design and create data marts

Teaching Strategy Lab sessions
Assessment Methods Project
Assessment
Weight
Quiz
20%
Midterm
20%
Final project
20%
Final exam
40%
Total
100%