Course Detail
Course Description
| Course | Code | Semester | T+P (Hour) | Credit | ECTS |
|---|---|---|---|---|---|
| ALGORITHMS for DATA MANAGEMENT and PROCESSING | COED1216286 | Spring Semester | 3+0 | 3 | 8 |
| Course Program |
| Prerequisites Courses | |
| Recommended Elective Courses |
| Language of Course | English |
| Course Level | Second Cycle (Master's Degree) |
| Course Type | Elective |
| Course Coordinator | Prof.Dr. Reda ALHAJJ |
| Name of Lecturer(s) | Prof.Dr. Reda ALHAJJ |
| Assistant(s) | |
| 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. |
| Course 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 . |
| Course Learning Outcomes | Teaching Methods | Assessment Methods |
| 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 |
| Teaching Methods: | |
| Assessment Methods: |
Course Outline
| Order | Subjects | Preliminary Work |
|---|---|---|
| 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 | none |
| Resources |
| Elmasri and Navathe Database Management Systems, 7th edition |
Course Contribution to Program Qualifications
| Course Contribution to Program Qualifications | |||||||
| No | Program Qualification | Contribution Level | |||||
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | Develop and deepen the current and advanced knowledge in the field with original thought and/or research and come up with innovative definitions based on Master's degree qualifications. | ||||||
| 2 | Conceive the interdisciplinary interaction which the field is related with ; come up with original solutions by using knowledge requiring proficiency on analysis, synthesis and assessment of new and complex ideas. | ||||||
| 3 | Evaluate and use new information within the field in a systematic approach and gain advanced level skills in the use of research methods in the field. | ||||||
| 4 | Develop an innovative knowledge, method, design and/or practice or adapt an already known knowledge, method, design and/or practice to another field. | ||||||
| 5 | Broaden the borders of the knowledge in the field by producing or interpreting an original work or publishing at least one scientific paper in the field in national and/or international refereed journals. | ||||||
| 6 | Contribute to the transition of the community to an information society and its sustainability process by introducing scientific, technological, social or cultural improvements. | ||||||
| 7 | Independently perceive, design, apply, finalize and conduct a novel research process. | ||||||
| 8 | Ability to communicate and discuss orally, in written and visually with peers by using a foreign language at least at a level of European Language Portfolio C1 General Level. | ||||||
| 9 | Critical analysis, synthesis and evaluation of new and complex ideas in the field. | ||||||
| 10 | Recognizes the scientific, technological, social or cultural improvements of the field and contribute to the solution finding process regarding social, scientific, cultural and ethical problems in the field and support the development of these values. | ||||||
Assessment Methods
| Contribution Level | Absolute Evaluation | |
| Rate of Midterm Exam to Success | 50 | |
| Rate of Final Exam to Success | 50 | |
| Total | 100 | |
| ECTS / Workload Table | ||||||
| Activities | Number of | Duration(Hour) | Total Workload(Hour) | |||
| Course Hours | 0 | 0 | 0 | |||
| Guided Problem Solving | 0 | 0 | 0 | |||
| Resolution of Homework Problems and Submission as a Report | 0 | 0 | 0 | |||
| Term Project | 0 | 0 | 0 | |||
| Presentation of Project / Seminar | 0 | 0 | 0 | |||
| Quiz | 0 | 0 | 0 | |||
| Midterm Exam | 0 | 0 | 0 | |||
| General Exam | 0 | 0 | 0 | |||
| Performance Task, Maintenance Plan | 0 | 0 | 0 | |||
| Total Workload(Hour) | 0 | |||||
| Dersin AKTS Kredisi = Toplam İş Yükü (Saat)/30*=(0/30) | 0 | |||||
| ECTS of the course: 30 hours of work is counted as 1 ECTS credit. | ||||||
Detail Informations of the Course
Course Description
| Course | Code | Semester | T+P (Hour) | Credit | ECTS |
|---|---|---|---|---|---|
| ALGORITHMS for DATA MANAGEMENT and PROCESSING | COED1216286 | Spring Semester | 3+0 | 3 | 8 |
| Course Program |
| Prerequisites Courses | |
| Recommended Elective Courses |
| Language of Course | English |
| Course Level | Second Cycle (Master's Degree) |
| Course Type | Elective |
| Course Coordinator | Prof.Dr. Reda ALHAJJ |
| Name of Lecturer(s) | Prof.Dr. Reda ALHAJJ |
| Assistant(s) | |
| 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. |
| Course 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 . |
| Course Learning Outcomes | Teaching Methods | Assessment Methods |
| 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 |
| Teaching Methods: | |
| Assessment Methods: |
Course Outline
| Order | Subjects | Preliminary Work |
|---|---|---|
| 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 | none |
| Resources |
| Elmasri and Navathe Database Management Systems, 7th edition |
Course Contribution to Program Qualifications
| Course Contribution to Program Qualifications | |||||||
| No | Program Qualification | Contribution Level | |||||
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | Develop and deepen the current and advanced knowledge in the field with original thought and/or research and come up with innovative definitions based on Master's degree qualifications. | ||||||
| 2 | Conceive the interdisciplinary interaction which the field is related with ; come up with original solutions by using knowledge requiring proficiency on analysis, synthesis and assessment of new and complex ideas. | ||||||
| 3 | Evaluate and use new information within the field in a systematic approach and gain advanced level skills in the use of research methods in the field. | ||||||
| 4 | Develop an innovative knowledge, method, design and/or practice or adapt an already known knowledge, method, design and/or practice to another field. | ||||||
| 5 | Broaden the borders of the knowledge in the field by producing or interpreting an original work or publishing at least one scientific paper in the field in national and/or international refereed journals. | ||||||
| 6 | Contribute to the transition of the community to an information society and its sustainability process by introducing scientific, technological, social or cultural improvements. | ||||||
| 7 | Independently perceive, design, apply, finalize and conduct a novel research process. | ||||||
| 8 | Ability to communicate and discuss orally, in written and visually with peers by using a foreign language at least at a level of European Language Portfolio C1 General Level. | ||||||
| 9 | Critical analysis, synthesis and evaluation of new and complex ideas in the field. | ||||||
| 10 | Recognizes the scientific, technological, social or cultural improvements of the field and contribute to the solution finding process regarding social, scientific, cultural and ethical problems in the field and support the development of these values. | ||||||
Assessment Methods
| Contribution Level | Absolute Evaluation | |
| Rate of Midterm Exam to Success | 50 | |
| Rate of Final Exam to Success | 50 | |
| Total | 100 | |