MEDICINE
Bachelor	TR-NQF-HE: Level 6	QF-EHEA: First Cycle	EQF-LLL: Level 6

Course Introduction and Application Information

Course Code	Course Name	Semester	Theoretical	Practical	Credit	ECTS
CMP4502	Distributed Databases	Spring	3	0	3	6

This catalog is for information purposes. Course status is determined by the relevant department at the beginning of semester.

Basic information

Language of instruction:	English
Type of course:	Non-Departmental Elective
Course Level:	Bachelor’s Degree (First Cycle)
Mode of Delivery:	Face to face
Course Coordinator :	Dr. Öğr. Üyesi TARKAN AYDIN
Recommended Optional Program Components:	None
Course Objectives:	Communication paradigms: client/server protocols, remote procedure call (e.g., Java RMI), multicast protocols handling asynchronous communication and failures. Distributed transaction management requires enhanced concurrency control methods. Comparing algorithms proposed by researchers and commercial solutions. Replicating data to increase fault-tolerance and the performance of databases.

Learning Outcomes

The students who have succeeded in this course;
1. Be able to understand Distributed computing systems, their characteristics, and desired functionality
2. Become familiar with Distributed computer system models and architectures
3. Be able to understand Synchronization
4. Be able to understand Replication
5. Be able to use distributed naming
6. Be able to understand Fault-tolerance

Course Content

1.Introduction
2.DDBMS Architecture
3.Distributed Database Design
4.Semantic Integrity Control
5.Query decomposition and data localization
6.Optimization of Distributed Queries
7.Transactions
8.Concurrency Control
9.Reliability

Weekly Detailed Course Contents

Week	Subject	Related Preparation
1)	Introduction: syllabus, administration and organization of the course, general introduction in distributed DBMS	None
2)	DDBMS Architecture: definition of DDBMS architecture, ANSI/SPARC standard, global, local, external, and internal schemas, DDBMS architectures, components of DDBMS	None
3)	Distributed Database Design: conceptual design (what can be distributed, design patterns), top-down, bottom-up patterns, technical design (fragmentation, allocation and replication of fragments, optimality, heuristics)	None
4)	Semantic Integrity Control: view management, security control, integrity control	None
5)	Semantic Integrity Control: view management, security control, integrity control	None
6)	Midterm Exam 1	Review all the topics
7)	Query decomposition and data localization: normalization, analysis, elimination of redundancy, rewriting, reduction for HF, reduction for VF	None
8)	Optimization of Distributed Queries: basic concepts, distributed cost model, database statistics	None
9)	Optimization of Distributed Queries: ordering of joins and semijoins, query optimization algorithms, INGRES, System R, hill climbing	None
10)	Transactions: introduction to transactions, definition and examples, properties, classification, processing issues, execution	None
11)	Midterm Exam 2	Review all the topics
12)	Concurrency Control: definition, execution schedules, examples, locking based algorithms, timestamp ordering algorithm, deadlock management	None
13)	Reliability: definitions, basic concepts, local recovery management, distributed reliability protocols	None
14)	Reliability: distributed reliability protocols, 2PC protocol	None

Sources

Course Notes / Textbooks:	Principles of Distributed Database Systems by M. Tamer Özsu and Patrick Valduriez
References:	None

Evaluation System

Semester Requirements	Number of Activities	Level of Contribution
Project	1	% 10
Midterms	2	% 40
Final	1	% 50
Total		% 100
PERCENTAGE OF SEMESTER WORK		% 40
PERCENTAGE OF FINAL WORK		% 60
Total		% 100

Contribution of Learning Outcomes to Programme Outcomes

No Effect	1 Lowest	2 Low	3 Average	4 High	5 Highest

	Program Outcomes	Level of Contribution
1)	Integrates the knowledge, skills and attitudes acquired from basic and clinical medical sciences, behavioral sciences and social sciences, and uses them in health service delivery.
2)	In patient management, shows a biopsychosocial approach that takes into account the socio-demographic and sociocultural background of the individual, regardless of language, religion, race and gender.
3)	In the provision of health services, prioritizes the protection and development of the health of individuals and society.
4)	Taking into account the individual, societal, social and environmental factors affecting health; does the necessary work to maintain and improve the state of health.
5)	By recognizing the characteristics, needs and expectations of the target audience, provides health education to healthy/sick individuals and their relatives and other healthcare professionals.
6)	Shows a safe, rational and effective approach in health service delivery, prevention, diagnosis, treatment, follow-up and rehabilitation processes.
7)	Performs invasive and/or non-invasive procedures in diagnosis, treatment, follow-up and rehabilitation processes in a safe and effective way for the patient.
8)	Provides health services by considering patient and employee health and safety.
9)	In the provision of health services, takes into account the changes in the physical and socioeconomic environment on a regional and global scale, as well as the changes in the individual characteristics and behaviors of the people who apply to it.
10)	Takes good medical practice into account while carrying out his/her profession.
11)	Fulfills its duties and obligations within the framework of ethical principles, rights and legal responsibilities required by its profession.
12)	Demonstrates decisive behavior in providing high-quality health care, taking into account the integrity of the patient.
13)	Evaluates his/her performance in his/her professional practice by considering his/her emotions and cognitive characteristics.
14)	Advocates improving the provision of health services by considering the concepts of social reliability and social responsibility for the protection and development of public health.
15)	Can plan and carry out service delivery, training and consultancy processes related to individual and community health in cooperation with all components for the protection and development of health.
16)	Evaluates the impact of health policies and practices on individual and community health indicators and advocates increasing the quality of health services.
17)	The physician attaches importance to the protection of his/her own physical, mental and social health, and does what is necessary for this
18)	Shows exemplary behavior and leads the healthcare team during service delivery.
19)	Uses resources cost-effectively, for the benefit of society and in accordance with the legislation, in the planning, implementation and evaluation processes of health services in the health institution he/she is the manager of.
20)	Establishes positive communication within the health team it serves and assumes different team roles when necessary.
21)	Is aware of the duties and responsibilities of the health workers in the health team and acts accordingly.
22)	In the professional practices, works in harmony and effectively with the colleagues and other professional groups.
23)	Communicates effectively with patients, their relatives, healthcare professionals, other professional groups, institutions and organizations.
24)	Communicates effectively with individuals and groups that require a special approach and have different socio-cultural characteristics.
25)	In the diagnosis, treatment, follow-up and rehabilitation processes, shows a patient-centered approach that associates the patient with the decision-making mechanisms.
26)	Plans and implements scientific research, when necessary, for the population it serves, and uses the results and/or the results of other research for the benefit of the society.
27)	Reaches and critically evaluates current literature knowledge about his/her profession.
28)	Applies the principles of evidence-based medicine in clinical decision making.
29)	Uses information technologies to increase the effectiveness of its work on health care, research and education.
30)	Effectively manages individual work processes and career development.
31)	Demonstrates skills in acquiring and evaluating new knowledge, integrating it with existing knowledge, applying it to professional situations and adapting to changing conditions throughout professional life.
32)	Selects the right learning resources to improve the quality of the health service it offers, organizes its own learning process