First Cycle - Faculty of Engineering - Computer Engineering (English)
Y : Year of Study S : Semester
Course Unit Code Course Unit Title Type of Course Y S ECTS
CSE4054 Distributed Databases Compulsory 4 7 5
Objectives of the Course
This course aims to strengthen the knowledge of students on database systems. The commonly used database architecture of distributed databases will be elaborated in the course.
Learning Outcomes
1 Acquire the ability to develop a distributed database system
2 Acquire the knowledge of efficient load balancing in distributed database systems
3 Comprehend the transaction and query processing in distributed databases and the ways to optimize them
4 Understand the additional complexities induced by distributed database systems and the ways to handle them
5 Understand the nature of distributed databases and why this arcitecture is necessary
Mode of Delivery
Formal Education
Recommended Optional Programme Components
None
Course Contents
Architectural models for distributed DBMS, transparencies, alternative design strategies, distribution design issues, semantic data control, security, integrity, query decomposition and data localization, optimization of distributed queries, centralized and distributed algorithms, transaction management and distributed concurrency control. Distributed reliability protocols, distributed multi-database systems. Current trends.
Weekly Detailed Course Contents
Week Theoretical Practice Laboratory
1 Meeting and course objectives
2 Introduction to distributed databases
3 Distributed database design
4 Database integration
5 Data and access control
6 Overview of query processing
7 Quesry decomposition
8 Midterm
9 Optimization of distributed queries
10 Multidatabase query processing
11 Transaction management in distributed databases
12 Distributed concurrency control
13 Distributed DBMS reliability
14 Distributed DBMS reliability
15 Data replication
16 Final Exam Study
17 Final Exam
Recommended or Required Reading
Özsu, M.T., Valduriez, P. (2011) Principles of Distributed Database Systems, 3rd. ed., Springer.
Planned Learning Activities and Teaching Methods
Course slides, 1 midterm, 1 final, homeworks
Assessment
AssessmentQuantityWeight
Term (or Year) Learning Activities60
End Of Term (or Year) Learning Activities40
Total100
Term (or Year) Learning ActivitiesQuantityWeight
Midterm Exam150
Project150
Total100
End Of Term (or Year) Learning ActivitiesQuantityWeight
Final Exam1100
Total100
Language of Instruction
Language Codes
Work Placement(s)
None
Workload Calculation
Activities Number Time (hours) Total Work Load (hours)
Theoretical 14 3 42
Post Class Self Study 14 1 14
Midterm Preparation 1 25 25
Final Preparation 1 30 30
Project 1 20 20
Total 31 79 131
Contribution of Learning Outcomes to Programme Outcomes
PO 1PO 2PO 3PO 4PO 5PO 6PO 7PO 8PO 9PO 10PO 11PO 12PO 13PO 14PO 15PO 16
LO 10000000000000000
LO 20000000000000000
LO 30000000000000000
LO 40000000000000000
LO 50000000000000000

^