COURSE UNIT TITLE

: ADVANCED DISTRIBUTED DATABASES

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
ELECTIVE

Offered By

Graduate School of Natural and Applied Sciences

Level of Course Unit

Second Cycle Programmes (Master's Degree)

Course Coordinator

ASSOCIATE PROFESSOR SEMIH UTKU

Offered to

Computer Engineering (Non-Thesis-Evening) (English)
Computer Engineering Non-Thesis (English)
Computer Engineering (English)
Computer Engineering (English)
COMPUTER ENGINEERING (ENGLISH)

Course Objective

The main objectives of this course are centralization versus decentralization in databases, transparent functionalities of distributed databases, data fragmentation, distributed query processing, update synchronization and concurrency control, homogeneous and heterogeneous distributed databases: global network schema, schema mappings and query processing strategies.

Learning Outcomes of the Course Unit

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

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

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

Recomended or Required Reading

Textbook:
Özsu, M. Tamer, and Patrick Valduriez. "Correction to: principles of distributed database systems." Principles of Distributed Database Systems. Springer, Cham, 2020. C1-C2.
Özsu, M. T., & Valduriez, P. (2020). NoSQL, NewSQL, and polystores. In Principles of distributed database systems (pp. 519-558). Springer, Cham.
Ceri, S. (2017). Distributed databases. Tata McGraw-Hill Education.

Complementary Books:
Özsu, M. Tamer, and Patrick Valduriez. Principles of distributed database systems. Vol. 2. Englewood Cliffs: Prentice Hall, 1999.
Santiago, M. (2021). Review on Distributed Database Systems. Mateo Santiago.(2021). REVIEW ON DISTRIBUTED DATABASE SYSTEMS. International Journal of Innovations in Engineering Research and Technology, 8(07), 334-336.
Okardi, B., & Asagba, O. OVERVIEW OF DISTRIBUTED DATABASE SYSTEM.
References:
* Malard-Adam, J., Harms, J., & Medema, W. (2022). Distributed databases for citizen science (No. EGU22-5147). Copernicus Meetings.
* Ge, Z., Loghin, D., Ooi, B. C., Ruan, P., & Wang, T. (2022). Hybrid blockchain database systems: design and performance. Proceedings of the VLDB Endowment, 15(5), 1092-1104.
* Ruan, P., Dinh, T. T. A., Loghin, D., Zhang, M., Chen, G., Lin, Q., & Ooi, B. C. (2021, June). Blockchains vs. distributed databases: dichotomy and fusion. In Proceedings of the 2021 International Conference on Management of Data (pp. 1504-1517).
* Chakraborty, S., Ali, D., & Murali, B. (2022). A Novel Distributed Database Architectural Model for Mobile Cloud Computing. In International Conference on Computational Techniques and Applications (pp. 155-161). Springer, Singapore.
* Domdouzis, K., Lake, P., & Crowther, P. (2021). Distributed Databases. In Concise Guide to Databases (pp. 213-222). Springer, Cham.
Other course materials:
* Ahmed, Z. J., & Alluhaibi, S. H. T. (2022). Review of Distributed Database from Different Perspectives. Journal of Optoelectronics Laser, 41(8), 468-483.

Planned Learning Activities and Teaching Methods

Lectures
Presentation
Homeworks
Project

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 ASG ASSIGNMENT
2 PRS PRESENTATION
3 FCG FINAL COURSE GRADE ASG * 0.50 + PRS * 0.50


Further Notes About Assessment Methods

None

Assessment Criteria

In-semester studies will be evaluated with a midterm exam and project / homework activities. There will four homework assignments. Each one will make up a various percentage of the weight of the total homework assignments.The final exam will cover all course topics.

Language of Instruction

English

Course Policies and Rules

1. Participation is mandatory (%70 theoretical courses and 80% practices).
2. Instructor reserves the right to quizzes. Notes should be added to these examinations, midterm and final exam grades.

Contact Details for the Lecturer(s)

Assoc.Prof.Dr. Semih UTKU
Dokuz Eylül Üniversitesi
Bilgisayar Mühendisliği Bölümü
Tınaztepe Yerleşkesi 35160 BUCA/IZMIR
Tel: (232) 301 74 28
E-Posta: semih@cs.deu.edu.tr

Office Hours

Tuesday 10:00 - 12:00
Thursday 12:00 - 17:00

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 14 3 42
Project Preparation 1 55 55
Preparing report 1 30 30
Preparations before/after weekly lectures 14 3 42
Preparing presentations 1 20 20
TOTAL WORKLOAD (hours) 189

Contribution of Learning Outcomes to Programme Outcomes

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