COURSE UNIT TITLE

: DISTRIBUTED DATABASES

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
CME 4415 DISTRIBUTED DATABASES ELECTIVE 2 2 0 6

Offered By

Computer Engineering

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

PROFESSOR DOCTOR RECEP ALP KUT

Offered to

Computer Engineering

Course Objective

The objective of this course is to teach the students the fundamental issues in distributed systems with a strong emphasis on data management.

Learning Outcomes of the Course Unit

1   Define Distributed Transaction Management
2   Realize Enhanced Concurrency Control
3   Realize Data Replication
4   Realize Distributed Query Processing and Optimization
5   Realize Clustered, Federated and Parallel Database Systems

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

CME 3201 - DATABASE MANAGEMENT SYSTEMS

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Overview of Relational DBMS
2 Distributed DBMS Architecture
3 Distributed Database Design
4 Semantic Data Control
5 Overview of Query Processing
6 Query Decomposition and Data Localization
7 Optimization of Distributed Queries
8 Optimization of Distributed Queries
9 Google Case Study queries, MIDTERM.
10 Introduction to Transaction Management
11 Transaction Management in Distributed Databases.
12 Distributed Concurrency Control.
13 Database Interoperability.
14 Designing Distributed Systems: Google Case Study.

Recomended or Required Reading

Principles of Distributed Database Systems, M. Tamer Ozsu, Patrick Valduriez, ISBN-13: 9780136597070, Prentice Hall, 1999.
Distributed Systems Concepts and Design, G. Coulouris,J. Dollimore, T. Kindberg, G. Blair, Addison-Wesley, 2012.

Planned Learning Activities and Teaching Methods

Presentation/Lecturing and Interactive discussion

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE MIDTERM EXAM
2 ASG ASSIGNMENT
3 FIN FINAL EXAM
4 FCG FINAL COURSE GRADE MTE * 0.25 + ASG * 0.25 + FIN * 0.50
5 RST RESIT
6 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.25 + ASG * 0.25 + RST * 0.50


*** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

Further Notes About Assessment Methods

Given 3-4 homework lead to design project.

Assessment Criteria

Midterm, Homework, Final Exam

Language of Instruction

English

Course Policies and Rules

Participation is mandatory.

Contact Details for the Lecturer(s)

Prof. Dr. Alp KUT
Dokuz Eylül Üniversitesi Mühendislik Fakültesi Bilgisayar Mühendisliği Bölümü
Tınaztepe Kampusu, Buca 35160, Izmir
alp@cs.deu.edu.tr

Office Hours

Monday 13:00-15:00

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 14 2 28
Tutorials 14 2 28
Preparations before/after weekly lectures 14 2 28
Preparation for final exam 1 20 20
Preparing assignments 1 30 30
Preparation for midterm exam 1 12 12
Final 1 2 2
Midterm 1 2 2
TOTAL WORKLOAD (hours) 150

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10
LO.13554553
LO.233553
LO.35555255
LO.45224
LO.54