| Course Name |
Distributed Database Systems
|
|
Code
|
Semester
|
Theory
(hour/week) |
Application/Lab
(hour/week) |
Local Credits
|
ECTS
|
|
CE 370
|
FALL
|
3
|
0
|
3
|
5
|
| Prerequisites | CE 223 To succeed (To get a grade of at least DD) | |||||
| Course Language | English | |||||
| Course Type | ELECTIVE_COURSE | |||||
| Course Level | First Cycle | |||||
| Mode of Delivery | Face-to-face | |||||
| Teaching Methods and Techniques of the Course |
Problem Solving Lecture / Presentation |
|||||
| National Occupational Classification Code | - | |||||
| Course Coordinator |
|
|||||
| Course Lecturer(s) |
|
|||||
| Assistant(s) | - | |||||
| Course Objectives | The objective of this course is to teach the students the fundamental issues in distributed systems with a strong emphasis on data management. After taking the course, students are expected to have an understanding of topics ranging from distributed transaction management and enhanced concurrency control to data replication and distributed query processing and optimization. | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Learning Outcomes |
The students who succeeded in this course;
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Course Description | Distributed database design, distributed transaction management and concurrency control, data replication, distributed query processing and optimization. | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Related Sustainable Development Goals |
-
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
Core Courses |
|
| Major Area Courses |
X
|
|
| Supportive Courses |
|
|
| Media and Managment Skills Courses |
|
|
| Transferable Skill Courses |
|
| Week | Subjects | Required Materials | Learning Outcome |
| 1 | Overview of Relational DBMS | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 2) | LO1 |
| 2 | Distributed DBMS Architecture | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 4) | LO1 |
| 3 | Distributed Database Design | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 5) | LO3 |
| 4 | Semantic Data Control | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 6) | LO3 |
| 5 | Overview of Query Processing | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 7) | LO1 |
| 6 | Query Decomposition and Data Localization | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 8) | LO3 |
| 7 | Centralized Query Optimization | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 9.1, 9.2) | LO1 |
| 8 | Midterm | - | |
| 9 | Optimization of Distributed Queries | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 9.3, 9.4) | LO3 |
| 10 | Introduction to Transaction Management | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 10) | LO2 |
| 11 | Distributed Concurrency Control | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 11) | LO4 |
| 12 | Distributed DBMS Reliability | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 12.1, 12.2, 12.3, 12.4) | LO5 |
| 13 | Distributed DBMS Reliability | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 12.5, 12.6, 12.7, 12.8) | LO5 |
| 14 | Project Presentations | LO1 | |
| 15 | Semester Review | - | |
| 16 | Final Exam | - |
| Course Notes/Textbooks | Ozsu; Valduriez; Principles of Distributed Database Systems; 2/e; Prentice Hall; 1999; 978-0136597070 |
| Suggested Readings/Materials | - |
| Semester Activities | Number | Weighting | LO1 | LO2 | LO3 | LO4 | LO5 |
| Project | 1 | 20 | X | X | X | X | X |
| Midterm | 1 | 35 | X | X | |||
| Final Exam | 1 | 45 | X | X | X | ||
| Total | 3 | 100 |
| Semester Activities | Number | Duration (Hours) | Workload |
|---|---|---|---|
| Participation | - | - | - |
| Theoretical Course Hours | 16 | 3 | 48 |
| Laboratory / Application Hours | - | - | - |
| Study Hours Out of Class | 14 | 3 | 42 |
| Field Work | - | - | - |
| Quizzes / Studio Critiques | - | - | - |
| Portfolio | - | - | - |
| Homework / Assignments | - | - | - |
| Presentation / Jury | - | - | - |
| Project | 1 | 30 | 30 |
| Seminar / Workshop | - | - | - |
| Oral Exams | - | - | - |
| Midterms | 1 | 10 | 10 |
| Final Exam | 1 | 20 | 20 |
| Total | 150 |
| # | PC Sub | Program Competencies/Outcomes | * Contribution Level | ||||
| 1 | 2 | 3 | 4 | 5 | |||
| No program competency data found. | |||||||
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest
As Izmir University of Economics transforms into a world-class university, it also raises successful young people with global competence.
More..Izmir University of Economics produces qualified knowledge and competent technologies.
More..Izmir University of Economics sees producing social benefit as its reason for existence.
More..