GRADUATE SCHOOL
M.SC. in Computer Engineering (With Thesis)
CE 603 | Course Introduction and Application Information
| Course Name |
Advanced Distributed Database Systems
|
|
Code
|
Semester
|
Theory
(hour/week) |
Application/Lab
(hour/week) |
Local Credits
|
ECTS
|
|
CE 603
|
Fall/Spring
|
3
|
0
|
3
|
7.5
|
| Prerequisites |
None
|
|||||
| Course Language |
English
|
|||||
| Course Type |
Elective
|
|||||
| Course Level |
Third Cycle
|
|||||
| Mode of Delivery | - | |||||
| Teaching Methods and Techniques of the Course | - | |||||
| Course Coordinator | - | |||||
| Course Lecturer(s) | ||||||
| Assistant(s) | - | |||||
| Course Objectives | The objective of this course is to provide the students with an in-depth understanding of distributed database technology and to equip them with the background required to conduct research in the area of distributed databases. Topics ranging from distributed transaction management and enhanced concurrency control to data replication and distributed query processing and optimization will be discussed throughout the course. |
| Learning Outcomes |
The students who succeeded in this course;
|
| Course Description | In this course, topics ranging from distributed database design, distributed transaction management and enhanced concurrency control to data replication and distributed query processing and optimization will be discussed. |
|
|
Core Courses | |
| Major Area Courses |
X
|
|
| Supportive Courses | ||
| Media and Management Skills Courses | ||
| Transferable Skill Courses |
WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES
| Week | Subjects | Related Preparation |
| 1 | Overview of Relational DBMS | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 2) |
| 2 | Distributed DBMS Architecture | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 4) |
| 3 | Distributed Database Design | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 5) |
| 4 | Semantic Data Control | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 6) |
| 5 | Overview of Query Processing | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 7) |
| 6 | Query Decomposition and Data Localization | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 8) |
| 7 | Optimization of Distributed Queries | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 9) |
| 8 | Midterm | |
| 9 | Optimization of Distributed Queries | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 9) |
| 10 | Introduction to Transaction Management | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 10) |
| 11 | Distributed Concurrency Control | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 11.1, 11.2, 11.3) |
| 12 | Distributed Concurrency Control | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 11.4, 11.5, 11.6, 11.7) |
| 13 | Distributed DBMS Reliability | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 12.1, 12.2, 12.3, 12.4) |
| 14 | Distributed DBMS Reliability | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 12.5, 12.6, 12.7, 12.8) |
| 15 | Review | |
| 16 | - |
| Course Notes/Textbooks | The textbook referenced above and course slides |
| Suggested Readings/Materials | Related Research Papers |
EVALUATION SYSTEM
| Semester Activities | Number | Weigthing |
| Participation | ||
| Laboratory / Application | ||
| Field Work | ||
| Quizzes / Studio Critiques | ||
| Portfolio | ||
| Homework / Assignments |
6
|
30
|
| Presentation / Jury | ||
| Project | ||
| Seminar / Workshop | ||
| Oral Exams | ||
| Midterm |
1
|
30
|
| Final Exam |
1
|
40
|
| Total |
| Weighting of Semester Activities on the Final Grade |
60
|
|
| Weighting of End-of-Semester Activities on the Final Grade |
40
|
|
| Total |
ECTS / WORKLOAD TABLE
| Semester Activities | Number | Duration (Hours) | Workload |
|---|---|---|---|
| Theoretical Course Hours (Including exam week: 16 x total hours) |
16
|
3
|
48
|
| Laboratory / Application Hours (Including exam week: '.16.' x total hours) |
16
|
0
|
|
| Study Hours Out of Class |
15
|
5
|
75
|
| Field Work |
0
|
||
| Quizzes / Studio Critiques |
0
|
||
| Portfolio |
0
|
||
| Homework / Assignments |
6
|
8
|
48
|
| Presentation / Jury |
0
|
||
| Project |
0
|
||
| Seminar / Workshop |
0
|
||
| Oral Exam |
0
|
||
| Midterms |
1
|
20
|
20
|
| Final Exam |
1
|
34
|
34
|
| Total |
225
|
COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP
|
#
|
Program Competencies/Outcomes |
* Contribution Level
|
||||
|
1
|
2
|
3
|
4
|
5
|
||
| 1 | Accesses information in breadth and depth by conducting scientific research in Computer Engineering; evaluates, interprets and applies information. |
X | ||||
| 2 | Is well-informed about contemporary techniques and methods used in Computer Engineering and their limitations. | X | ||||
| 3 | Uses scientific methods to complete and apply information from uncertain, limited or incomplete data; can combine and use information from different disciplines. |
X | ||||
| 4 | Is informed about new and upcoming applications in the field and learns them whenever necessary. | X | ||||
| 5 | Defines and formulates problems related to Computer Engineering, develops methods to solve them and uses progressive methods in solutions. |
X | ||||
| 6 | Develops novel and/or original methods, designs complex systems or processes and develops progressive/alternative solutions in designs | X | ||||
| 7 | Designs and implements studies based on theory, experiments and modelling; analyses and resolves the complex problems that arise in this process. |
X | ||||
| 8 | Can work effectively in interdisciplinary teams as well as teams of the same discipline, can lead such teams and can develop approaches for resolving complex situations; can work independently and takes responsibility. |
X | ||||
| 9 | Engages in written and oral communication at least in Level B2 of the European Language Portfolio Global Scale. |
X | ||||
| 10 | Communicates the process and the results of his/her studies in national and international venues systematically, clearly and in written or oral form. |
X | ||||
| 11 | Is knowledgeable about the social, environmental, health, security and law implications of Computer Engineering applications, knows their project management and business applications, and is aware of their limitations in Computer Engineering applications. |
X | ||||
| 12 | Highly regards scientific and ethical values in data collection, interpretation, communication and in every professional activity. |
X | ||||
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest