CENG0052 Advanced Topics in Database Management Systems

6 ECTS - 3-0 Duration (T+A)- . Semester- 3 National Credit

Information

Code CENG0052
Name Advanced Topics in Database Management Systems
Term 2022-2023 Academic Year
Term Spring
Duration (T+A) 3-0 (T-A) (17 Week)
ECTS 6 ECTS
National Credit 3 National Credit
Teaching Language İngilizce
Level Yüksek Lisans Dersi
Type Normal
Mode of study Yüz Yüze Öğretim
Catalog Information Coordinator
Course Instructor
1


Course Goal / Objective

The aim of this course is to review advanced level database management systems concepts.

Course Content

Advanced level database management systems concepts including relational model, query optimization, transaction management, concurrency control, recovery, parallel and distributed databases, object database systems, deductive databases, data warehousing, and no-sql systems.

Course Precondition

The student is required to know basic database management systems concepts.

Resources

Silberschatz, A., Korth, H.F., and Sudarshan, S., Database System Concepts, Mcgraw-Hill, 2010.

Notes

Related recent papers


Course Learning Outcomes

Order Course Learning Outcomes
LO01 Investigates advanced level database management systems concepts like query processing, concurrency control, data recovery.
LO02 Investigates parallel, object relational, deductive database management systems concepts.
LO03 Identifies NoSQL systems.
LO04 Investigates new technologies about database management systems.


Relation with Program Learning Outcome

Order Type Program Learning Outcomes Level
PLO01 Bilgi - Kuramsal, Olgusal On the basis of the competencies gained at the undergraduate level, it has an advanced level of knowledge and understanding that provides the basis for original studies in the field of Computer Engineering.
PLO02 Bilgi - Kuramsal, Olgusal By reaching scientific knowledge in the field of engineering, he/she reaches the knowledge in depth and depth, evaluates, interprets and applies the information. 3
PLO03 Yetkinlikler - Öğrenme Yetkinliği Being aware of the new and developing practices of his / her profession and examining and learning when necessary. 5
PLO04 Yetkinlikler - Öğrenme Yetkinliği Constructs engineering problems, develops methods to solve them and applies innovative methods in solutions.
PLO05 Yetkinlikler - Öğrenme Yetkinliği Designs and applies analytical, modeling and experimental based researches, analyzes and interprets complex situations encountered in this process. 2
PLO06 Yetkinlikler - Öğrenme Yetkinliği Develops new and / or original ideas and methods, develops innovative solutions in system, part or process design.
PLO07 Beceriler - Bilişsel, Uygulamalı Has the skills of learning.
PLO08 Beceriler - Bilişsel, Uygulamalı Being aware of new and emerging applications of Computer Engineering examines and learns them if necessary. 4
PLO09 Beceriler - Bilişsel, Uygulamalı Transmits the processes and results of their studies in written or oral form in the national and international environments outside or outside the field of Computer Engineering. 1
PLO10 Beceriler - Bilişsel, Uygulamalı Has comprehensive knowledge about current techniques and methods and their limitations in Computer Engineering. 2
PLO11 Beceriler - Bilişsel, Uygulamalı Uses information and communication technologies at an advanced level interactively with computer software required by Computer Engineering. 3
PLO12 Bilgi - Kuramsal, Olgusal Observes social, scientific and ethical values in all professional activities.


Week Plan

Week Topic Preparation Methods
1 Review of the relational model Reading the papers Öğretim Yöntemleri:
Anlatım, Tartışma
2 Query optimization Reading the papers Öğretim Yöntemleri:
Anlatım, Tartışma
3 Transaction management Reading the papers Öğretim Yöntemleri:
Anlatım, Tartışma
4 Concurrency control Reading the papers Öğretim Yöntemleri:
Anlatım, Tartışma
5 Data recovery Reading the papers Öğretim Yöntemleri:
Anlatım, Tartışma
6 Parallel and distributed databases Reading the papers Öğretim Yöntemleri:
Anlatım, Tartışma
7 Object database systems Reading the papers Öğretim Yöntemleri:
Anlatım, Tartışma
8 Mid-Term Exam Reading the papers Ölçme Yöntemleri:
Ödev, Sözlü Sınav
9 Object relational database systems Reading the papers Öğretim Yöntemleri:
Anlatım, Tartışma
10 Deductive databases Reading the papers Öğretim Yöntemleri:
Anlatım, Tartışma
11 Data warehousing Reading the papers Öğretim Yöntemleri:
Anlatım, Tartışma
12 No-sql systems Reading the papers Öğretim Yöntemleri:
Anlatım, Tartışma
13 Big Data Reading the papers Öğretim Yöntemleri:
Tartışma, Anlatım
14 Data analitics Reading the papers Öğretim Yöntemleri:
Tartışma, Anlatım
15 Blockchain databases Reading the papers Öğretim Yöntemleri:
Örnek Olay, Tartışma
16 Presentation of recent papers Reading the papers, preparing presentation Öğretim Yöntemleri:
Örnek Olay, Tartışma
17 Term Exams Reading the papers Ölçme Yöntemleri:
Yazılı Sınav


Student Workload - ECTS

Works Number Time (Hour) Workload (Hour)
Course Related Works
Class Time (Exam weeks are excluded) 14 3 42
Out of Class Study (Preliminary Work, Practice) 14 5 70
Assesment Related Works
Homeworks, Projects, Others 0 0 0
Mid-term Exams (Written, Oral, etc.) 1 15 15
Final Exam 1 30 30
Total Workload (Hour) 157
Total Workload / 25 (h) 6,28
ECTS 6 ECTS

Update Time: 16.11.2022 08:33