Ph.D. In Computer Engineering

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	-
National Occupation Classification	-
Course Coordinator	-
Course Lecturer(s)	Doç. Dr. Cem EVRENDİLEK
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

#	Content	PC Sub	* Contribution Level
#	Content	PC Sub	1	2	3	4	5
1	will be able to give an in-depth description of distributed database technology.
2	will be able to describe how to implement transaction management and concurrency control in distributed database management systems.
3	will be able to design distributed databases in the presence of fragmentation and replication.
4	will be able to use serializability theory for assessing the correctness of optimistic and pessimistic concurrency control algorithms which are based on either locking or timestamp ordering.
5	will be able to interpret the concept of the reliability of a distributed database management system and implement distributed recovery and commit protocols in the presence of site failures and network partitioning.

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.

Course Category	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	Learning Outcome
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	Weighting	LO 1	LO 2	LO 3	LO 4	LO 5
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

#	PC Sub	Program Competencies/Outcomes	* Contribution Level
#	PC Sub	Program Competencies/Outcomes	1	2	3	4	5
1	Understands and applies the foundational theories of Computer Engineering in a high level.		-	-	-	X	-
2	Possesses a great depth and breadth of knowledge about Computer Engineering including the latest developments.		-	-	-	-	X
3	Can reach the latest information in Computer Engineering and possesses a high level of proficiency in the methods and abilities necessary to comprehend it and conduct research with it.		-	X	-	-	-
4	Conducts a comprehensive study that introduces innovation to science and technology, develops a new scientific procedure or a technological product/process, or applies a known method in a new field.		X	-	-	-	-
5	Independently understands, designs, implements and concludes a unique research process in addition to managing it.		-	X	-	-	-
6	Contributes to science and technology literature by publishing the output of his/her academic studies in respectable academic outlets.		-	X	-	-	-
7	Interprets scientific, technological, social and cultural developments and relates them to the general public with a commitment to scientific objectivity and ethical responsibility.		-	X	-	-	-
8	Performs critical analysis, synthesis and evaluation of ideas and developments in Computer Engineering.		-	-	-	X	-
9	Performs verbal and written communications with professionals as well as broader scientific and social communities in Computer Engineering, by using English at least at the European Language Portfolio C1 General level, performs written, oral and visual communications and discussions in a high level.		-	X	-	-	-
10	Develops strategies, policies and plans about systems and topics that Computer Engineering uses, and interprets the outcomes.		-	X	-	-	-