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

ASSOCIATE PROFESSOR SEMIH UTKU

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 MTE1 MIDTERM EXAM 1
2 MTE2 MIDTERM EXAM 2
3 FIN FINAL EXAM
4 FCG FINAL COURSE GRADE MTE1 * 0.25 + MTE2 * 0.25 + FIN * 0.50
5 RST RESIT
6 FCGR FINAL COURSE GRADE (RESIT) MTE1 * 0.25 + MTE2 * 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

To be announced.

Language of Instruction

English

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

Asst. Prof. Dr. Canan Eren Atay
Dokuz Eylül Üniversitesi Mühendislik Fakültesi Bilgisayar Mühendisliği Bölümü
Tınaztepe Kampusu, Buca 35160, Izmir
(232)301 7412
canan@cs.deu.edu.tr

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 12 2 24
Tutorials 12 2 24
Preparations before/after weekly lectures 12 2 24
Preparation for final exam 1 20 20
Preparing assignments 1 30 30
Preparing presentations 1 13 13
Final 1 3 3
TOTAL WORKLOAD (hours) 138

Contribution of Learning Outcomes to Programme Outcomes

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