FACULTY OF ENGINEERING

Department of Industrial 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
  CE 223 To succeed (To get a grade of at least DD)
Course Language
English
Course Type
Elective
Course Level
First Cycle
Mode of Delivery -
Teaching Methods and Techniques of the Course Problem Solving
Lecture / 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;
  • will be able to explain distributed database technology comprehensively.
  • will be able to describe transaction management and concurrency control in distributed database management systems.
  • will be able to design distributed databases when fragmentation and/or replication are required.
  • will be able to assess the correctness of optimistic and pessimistic concurrency control algorithms which are based on either locking or timestamp ordering.
  • will be able to apply distributed recovery and commit protocols in the presence of site failures and network partitioning.
Course Description Distributed database design, distributed transaction management and concurrency control, data replication, distributed query processing and optimization.

 



Course Category

Core Courses
Major Area Courses
X
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 adequate knowledge in Mathematics, Science and Industrial Engineering; to be able to use theoretical and applied information in these areas to model and solve Industrial Engineering problems.

X
2

To be able to identify, formulate and solve complex Industrial Engineering problems by using state-of-the-art methods, techniques and equipment; to be able to select and apply proper analysis and modeling methods for this purpose.

X
3

To be able to analyze a complex system, process, device or product, and to design with realistic limitations to meet the requirements using modern design techniques.

X
4

To be able to choose and use the required modern techniques and tools for Industrial Engineering applications; to be able to use information technologies efficiently.

X
5

To be able to design and do simulation and/or experiment, collect and analyze data and interpret the results for investigating Industrial Engineering problems and Industrial Engineering related research areas.

X
6

To be able to work efficiently in Industrial Engineering disciplinary and multidisciplinary teams; to be able to work individually.

X
7

To be able to communicate effectively in Turkish, both orally and in writing; 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 contemporary issues and the global and societal effects of Industrial Engineering practices on health, environment, and safety; to be aware of the legal consequences of Industrial Engineering solutions.

X
9

To be aware of professional and ethical responsibility; to have knowledge of the standards used in Industrial Engineering practice.

X
10

To have knowledge about business life practices such as project management, risk management, and change management; to be aware of entrepreneurship and innovation; to have knowledge about sustainable development.

11

To be able to collect data in the area of Industrial Engineering; to be able to communicate with colleagues in a foreign language.

X
12

To be able to speak a second foreign at a medium level of fluency efficiently.

13

To recognize the need for lifelong learning; to be able to access information, to be able to stay current with developments in science and technology; to be able to relate the knowledge accumulated throughout the human history to Industrial Engineering.

X

*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest

 


SOCIAL MEDIA

NEWS |ALL NEWS

Izmir University of Economics
is an establishment of
izto logo
Izmir Chamber of Commerce Health and Education Foundation.
ieu logo

Sakarya Street No:156
35330 Balçova - İzmir / Turkey

kampus izmir

Follow Us

İEU © All rights reserved.