TÜRKÇE
ENGLISH
Information
| Code | CENG0052 |
| Name | Advanced Topics in Database Management Systems |
| Term | 2023-2024 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 | ||