CE 603 | Course Introduction and Application Information - M.SC. in Computer Engineering (With Thesis)

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

The students who succeeded in this course;

will be able to give an in-depth description of distributed database technology.
will be able to describe how to implement transaction management and concurrency control in distributed database management systems.
will be able to design distributed databases in the presence of fragmentation and replication.
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.
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

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

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

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

#	PC Sub	Program Competencies/Outcomes	* Contribution Level
#	PC Sub	Program Competencies/Outcomes	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	-	-	-	-

CE 603 | Course Introduction and Application Information

WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES

EVALUATION SYSTEM

ECTS / WORKLOAD TABLE

COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP

NEW GÜZELBAHÇE CAMPUS

GLOBAL CAREER

CONTRIBUTION TO SCIENCE

VALUING PEOPLE

BENEFIT TO SOCIETY