1

Isra University

Faculty Information Technology

Department of Computer Science

Course Plan

______

Course No.:
601322 / Course Classification:
Department Compulsory (CIS)
Course Name:
Data Warehousing / Time Division:
3 Lectures
Course Website: www.elearn.isra.edu.jo / Semester &Year: Second 2011/2012

Course Description

(3 credit hours, Prerequisite: 605333/ Database)

Data Warehouse design approach based on solid software engineering principles. How to interview end users, construct conceptual schemata and translate them into relational schemata, and design state-of-the-art ETL procedures. How to integrate heterogeneous data sources, implement star and snowflake schemata, manage dynamic and irregular hierarchies, and fine-tune performance by materializing and fragmenting views.

Course Intended Outcomes

At the end of the course, students are expected to learn:

·  Work with data- and requirement-driven methodological approaches

·  Create a reconciled database to boost data mart architecture

·  Capture and expressively represent end-user requirements

·  Build a conceptual data mart schema using the Dimensional Fact Model

·  Estimate data mart volume and workload

·  Improve performance using advanced logical modeling techniques

·  Extract, transform, cleanse, and load data from operational sources

·  Use sophisticated indexing techniques to optimize query execution plans

·  Comprehensively document data warehouse projects

Course Outline

Week

/

ROOM: 4142

SUN/9:00-9:50

/ ROOM: 4142
TUE/9:00-9:50 /

ROOM: 4142

THU/ 9:00-9:50

1

/

Introduction to Data Warehousing

/ Data Warehouse Architecture / Accessing Data Warehouses
2 / Data Warehouse System Lifecycle / Data Mart Design Phases / Methodological Framework
3 / Analysis and Reconciliation of Data Sources / The Integration Problem / Integration Phases
4 / User Requirement Analysis / Requirement Analysis / Requirement Analysis
5 / Conceptual Modeling and Design / Advanced Modeling / Events and Aggregation
6 / Conceptual Design / Schema based Design / Mixed Approach Design
7 / Review for First Exam / First Exam
(Th 24/11/2011) / Return and Discussion of
First Exam Results
8 / Workload and Data Volume / Workload / Data Volume
9 / Logical Modeling and Design / Logical Modeling / Logical Design
10 / Data-staging Design / Populating tables / Data Cleansing
11 / Review for Second Exam / Second Exam
(Tu 27/12/2011) / Return and Discussion of
Second Exam Results
12 / Indexes for the Data Warehouse and Physical Design / Types of Indexes / The Physical Design
13 / Data Warehouse Project Documentation / Data Warehouse level / Data Mart Level
14 / Exam Review / Exam Review / Third Exam
( TBA)
15 / Final Exams

Textbook

Data Warehouse Design: Modern Principles and Methodologies.

Matteo Golfarelli, Stefano Rizzi, McGraw-Hill Osborne Media; latest edition.

Suggested references

1.  The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights, Robert Laberge. McGraw-Hill Osborne Media, 1st edition, 2011.

2.  Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema, Lawrence Corr, Jim Stagnitto, DecisionOne Press, 2011.

3.  Data Warehouse Design Solutions, Michael Venerable, Christopher Adamson. Wiley, 1998.

Marking

First Exam 25 marks

Second Exam 25 marks

Activity 10 marks

Final Exam 40 marks

Regulations

1.  There will be three term exams given during this semester. The best two out of three will be considered for the First and Second Exam. This means: there will be NO makeup exams! Missing one of the two left exams means a ZERO grade will be given for that exam.

2.  There are no makeup for quizzes

3.  Attendance is mandatory and University regulations will be enforced.

4.  All Cheating incidents will be reported to the chair. The following activities are considered cheating:

a.  Turning in assignment that includes parts of someone else's work.

b.  Turning in someone else’s assignment as your own.

c.  Giving assignment to someone else to turn in as their own.

d.  Copying answers in a test or quiz.

e.  Taking a test or quiz for someone else.

f.  Having someone else take a test or quiz for you.

5.  See Student handbook for other regulations.

Assignments and/or Projects

Assignments / Quizzes / Description / Due Date / Marking
In each major section the students will be given assignments for practicing and developing a good concept of the topic. Assignments’ deadlines and method of delivery will be specified by instructors throughout the course.

Emailing Guidelines:

1.  All homework, assignments, projects, etc., are sent by email to the email address shown below ( under Instructor’s Information).

2.  Be sure to send them before the due date.

3.  Fill in the subject field of the email using the following format:

CIS201_Family-Name_First-Name_Subject , where:

a) CIS201 is abbreviation for the course. Other courses should have similar abbreviations

b) Family-Name and First-Name are replaced by your family name and your first name.

c) Subject is replaced by the title of the assignment, project, etc.

4.  You may also use the email to ask questions about the course. In this case, just type the world “question” in the place of _Subject as described in 3-c above.

Instructor's Information

Section: 1 Lecture Room : 4142 Time:09:00-10:50 (SUN)

Lab : 4319 Time:09:00-10:50 (TUE/THR)

Instructor's Name: Dr. Mohammad Ali H. Eljinini Office No.: 4106

Email:

Office Hours: Sun [11:00-12:00] Mon [09:00-10:00, 11:00-12:00]

Tue [1:00-2:00] Wed[ 10:00-11:00,12:00-1:00]

Other office hours are available by appointment

Important: The content of this syllabus may not be changed during the current semester

Instructor Council Chair