FACULTY OF ENGINEERING
Department of Mechatronics Engineering
CE 370 | Course Introduction and Application Information
Course Name |
Distributed Database Systems
|
Code
|
Semester
|
Theory
(hour/week) |
Application/Lab
(hour/week) |
Local Credits
|
ECTS
|
CE 370
|
Fall/Spring
|
3
|
0
|
3
|
5
|
Prerequisites |
|
|||||||
Course Language |
English
|
|||||||
Course Type |
Service Course
|
|||||||
Course Level |
First Cycle
|
|||||||
Mode of Delivery | - | |||||||
Teaching Methods and Techniques of the Course | Problem SolvingLecture / Presentation | |||||||
Course Coordinator | - | |||||||
Course Lecturer(s) | - | |||||||
Assistant(s) | - |
Course Objectives | The objective of this course is to teach the students the fundamental issues in distributed systems with a strong emphasis on data management. After taking the course, students are expected to have an understanding of topics ranging from distributed transaction management and enhanced concurrency control to data replication and distributed query processing and optimization. |
Learning Outcomes |
The students who succeeded in this course;
|
Course Description | Distributed database design, distributed transaction management and concurrency control, data replication, distributed query processing and optimization. |
|
Core Courses | |
Major Area Courses | ||
Supportive Courses | ||
Media and Management Skills Courses | ||
Transferable Skill Courses |
WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES
Week | Subjects | Related Preparation |
1 | Overview of Relational DBMS | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 2) |
2 | Distributed DBMS Architecture | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 4) |
3 | Distributed Database Design | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 5) |
4 | Semantic Data Control | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 6) |
5 | Overview of Query Processing | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 7) |
6 | Query Decomposition and Data Localization | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 8) |
7 | Centralized Query Optimization | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 9.1, 9.2) |
8 | Midterm | |
9 | Optimization of Distributed Queries | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 9.3, 9.4) |
10 | Introduction to Transaction Management | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 10) |
11 | Distributed Concurrency Control | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 11) |
12 | Distributed DBMS Reliability | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 12.1, 12.2, 12.3, 12.4) |
13 | Distributed DBMS Reliability | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999 (Ch. 12.5, 12.6, 12.7, 12.8) |
14 | Project Presentations | |
15 | Semester Review | |
16 | Final Exam |
Course Notes/Textbooks | Ozsu, Valduriez, Principles of Distributed Database Systems, 2/e, Prentice Hall, 1999, 978-0136597070 |
Suggested Readings/Materials |
EVALUATION SYSTEM
Semester Activities | Number | Weigthing |
Participation | ||
Laboratory / Application | ||
Field Work | ||
Quizzes / Studio Critiques | ||
Portfolio | ||
Homework / Assignments | ||
Presentation / Jury | ||
Project |
1
|
20
|
Seminar / Workshop | ||
Oral Exams | ||
Midterm |
1
|
35
|
Final Exam |
1
|
45
|
Total |
Weighting of Semester Activities on the Final Grade |
2
|
55
|
Weighting of End-of-Semester Activities on the Final Grade |
1
|
45
|
Total |
ECTS / WORKLOAD TABLE
Semester Activities | Number | Duration (Hours) | Workload |
---|---|---|---|
Theoretical Course Hours (Including exam week: 16 x total hours) |
16
|
3
|
48
|
Laboratory / Application Hours (Including exam week: '.16.' x total hours) |
16
|
0
|
|
Study Hours Out of Class |
14
|
3
|
42
|
Field Work |
0
|
||
Quizzes / Studio Critiques |
0
|
||
Portfolio |
0
|
||
Homework / Assignments |
0
|
||
Presentation / Jury |
0
|
||
Project |
1
|
30
|
30
|
Seminar / Workshop |
0
|
||
Oral Exam |
0
|
||
Midterms |
1
|
10
|
10
|
Final Exam |
1
|
20
|
20
|
Total |
150
|
COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP
#
|
Program Competencies/Outcomes |
* Contribution Level
|
||||
1
|
2
|
3
|
4
|
5
|
||
1 | To have knowledge in Mathematics, science, physics knowledge based on mathematics; mathematics with multiple variables, differential equations, statistics, optimization and linear algebra; to be able to use theoretical and applied knowledge in complex engineering problems |
|||||
2 | To be able to identify, define, formulate, and solve complex mechatronics engineering problems; to be able to select and apply appropriate analysis and modeling methods for this purpose. |
|||||
3 | To be able to design a complex electromechanical system, process, device or product with sensor, actuator, control, hardware, and software to meet specific requirements under realistic constraints and conditions; to be able to apply modern design methods for this purpose. |
|||||
4 | To be able to develop, select and use modern techniques and tools necessary for the analysis and solution of complex problems encountered in Mechatronics Engineering applications; to be able to use information technologies effectively. |
|||||
5 | To be able to design, conduct experiments, collect data, analyze and interpret results for investigating Mechatronics Engineering problems. |
|||||
6 | To be able to work effectively in Mechatronics Engineering disciplinary and multidisciplinary teams; to be able to work individually. |
|||||
7 | To be able to communicate effectively in Turkish, both in oral and written forms; to be able to author and comprehend written reports, to be able to prepare design and implementation reports, to present effectively, to be able to give and receive clear and comprehensible instructions. |
|||||
8 | To have knowledge about global and social impact of engineering practices on health, environment, and safety; to have knowledge about contemporary issues as they pertain to engineering; to be aware of the legal ramifications of engineering solutions. |
|||||
9 | To be aware of ethical behavior, professional and ethical responsibility; information on standards used in engineering applications. |
|||||
10 | To have knowledge about industrial practices such as project management, risk management and change management; to have awareness of entrepreneurship and innovation; to have knowledge about sustainable development. |
|||||
11 | Using a foreign language, he collects information about Mechatronics Engineering and communicates with his colleagues. ("European Language Portfolio Global Scale", Level B1) |
|||||
12 | To be able to use the second foreign language at intermediate level. |
|||||
13 | To recognize the need for lifelong learning; to be able to access information; to be able to follow developments in science and technology; to be able to relate the knowledge accumulated throughout the human history to Mechatronics Engineering. |
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest