Course Detail
Course Detail
Course Description
| Course | Code | Semester | T+P (Hour) | Credit | ECTS |
|---|---|---|---|---|---|
| INTRODUCTION to DATA MANAGEMENT and PROCESSING | COE4216264 | Spring Semester | 3+0 | 3 | 6 |
| Course Program |
| Prerequisites Courses | |
| Recommended Elective Courses |
| Language of Course | English |
| Course Level | First Cycle (Bachelor'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 | nothing |
| 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 | 1. An ability to apply knowledge of mathematics, science, and engineering | ||||||
| 2 | 2. An ability to identify, formulate, and solve engineering problems | ||||||
| 3 | 3. An ability to design a system, component, or process to meet desired needs within realistic constraints such as economic, environmental, social, political, ethical, health and safety, manufacturability, and sustainability | ||||||
| 4 | 4. An ability to use the techniques, skills, and modern engineering tools necessary for engineering practice | ||||||
| 5 | 5. An ability to design and conduct experiments, as well as to analyze and interpret data | ||||||
| 6 | 6. An ability to function on multidisciplinary teams | ||||||
| 7 | 7. An ability to communicate effectively | ||||||
| 8 | 8. A recognition of the need for, and an ability to engage in life-long learning | ||||||
| 9 | 9. An understanding of professional and ethical responsibility | ||||||
| 10 | 10. A knowledge of contemporary issues | ||||||
| 11 | 11. The broad education necessary to understand the impact of engineering solutions in a global, economic, environmental, and societal context | ||||||
Assessment Methods
| Contribution Level | Absolute Evaluation | |
| Rate of Midterm Exam to Success | 30 | |
| Rate of Final Exam to Success | 70 | |
| 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 |
|---|---|---|---|---|---|
| INTRODUCTION to DATA MANAGEMENT and PROCESSING | COE4216264 | Spring Semester | 3+0 | 3 | 6 |
| Course Program |
| Prerequisites Courses | |
| Recommended Elective Courses |
| Language of Course | English |
| Course Level | First Cycle (Bachelor'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 | nothing |
| 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 | 1. An ability to apply knowledge of mathematics, science, and engineering | ||||||
| 2 | 2. An ability to identify, formulate, and solve engineering problems | ||||||
| 3 | 3. An ability to design a system, component, or process to meet desired needs within realistic constraints such as economic, environmental, social, political, ethical, health and safety, manufacturability, and sustainability | ||||||
| 4 | 4. An ability to use the techniques, skills, and modern engineering tools necessary for engineering practice | ||||||
| 5 | 5. An ability to design and conduct experiments, as well as to analyze and interpret data | ||||||
| 6 | 6. An ability to function on multidisciplinary teams | ||||||
| 7 | 7. An ability to communicate effectively | ||||||
| 8 | 8. A recognition of the need for, and an ability to engage in life-long learning | ||||||
| 9 | 9. An understanding of professional and ethical responsibility | ||||||
| 10 | 10. A knowledge of contemporary issues | ||||||
| 11 | 11. The broad education necessary to understand the impact of engineering solutions in a global, economic, environmental, and societal context | ||||||
Assessment Methods
| Contribution Level | Absolute Evaluation | |
| Rate of Midterm Exam to Success | 30 | |
| Rate of Final Exam to Success | 70 | |
| Total | 100 | |