Course
COE4216264
INTRODUCTION to DATA MANAGEMENT and PROCESSING
Computer Engineering
- LECTURE
- 3
- LAB
- 0
- CREDITS
- 3
- ECTS
- 6
REQUIRES
REQUIRED BY
None
TAUGHT IN
AIM
This course introduces the basics of data management and processing. It covers various important topics, including storage manangement, indexing, query processing and optimization, concurrency control, data recovery, data warehouses, data privacy and security.
CONTENT
This course contains; Week 1 10-02 Introduction to the course material, overview of data management and processing Week 2 17-02 Storage management and Indexing Week 3 24-02 Queries and query processing Week 4 03-03 Heuristic based Query optimization Quiz #1 Week 5 10-03 Cost based query optimzation Week 6 17-03 Transaction management Quiz #2 Week 7 24-03 Concurrency control Quiz #3 exam Week 8 14-04 Project Progress presentation Week 9 21-04 presentations by students Week 10 28-04 presentations by students Week 11 05-05 Concurrency and Recovery Week 12 12-05 Various Recovery Schemes Quiz #4 Week 13 19-05 Data security and privacy Quiz #5 Week 14 26-05 Project Presentations .
LEARNING OUTCOMES
- 1
After successful completion of the course, the student will be able to: 1 Understanding the basics of data storage and indexing 2 Understanding the basics of query processing and optimization 3 Understanding the basics of concurrency control 4 Understanding the basics of data recovery 5 Understanding of basics of data warehouse management 6 Understanding of basics of data privacy and security
WEEKLY PLAN
- WEEK 1
Week 1 10-02 Introduction to the course material, overview of data management and processing Week 2 17-02 Storage management and Indexing Week 3 24-02 Queries and query processing Week 4 03-03 Heuristic based Query optimization Quiz #1 Week 5 10-03 Cost based query optimzation Week 6 17-03 Transaction management Quiz #2 Week 7 24-03 Concurrency control Quiz #3 exam Week 8 14-04 Project Progress presentation Week 9 21-04 presentations by students Week 10 28-04 presentations by students Week 11 05-05 Concurrency and Recovery Week 12 12-05 Various Recovery Schemes Quiz #4 Week 13 19-05 Data security and privacy Quiz #5 Week 14 26-05 Project Presentations
Preparation: nothing
ASSESSMENT
- Rate of Midterm Exam to Success30%
- Rate of Final Exam to Success70%
READING
- Elmasri and Navathe Database Management systems, 7th edition
TEACHING STAFF
- Prof.Dr. Reda ALHAJJCOORDINATOR
- Prof.Dr. Reda ALHAJJ