|
| Course Description |
|
| Course Name |
: |
Advanced Topics in Database Management Systems |
|
| Course Code |
: |
CENG-553 |
|
| Course Type |
: |
Optional |
|
| Level of Course |
: |
Second Cycle |
|
| Year of Study |
: |
1 |
|
| Course Semester |
: |
Fall (16 Weeks) |
|
| ECTS |
: |
6 |
|
| Name of Lecturer(s) |
: |
Asst.Prof.Dr. SELMA AYŞE ÖZEL
|
|
| Learning Outcomes of the Course |
: |
Learns advanced and recent topics about database management systems.
Makes applications over new database systems.
Has basic knowledge level about parallel and distributed database systems, object-database systems, deductive databases, data warehousing and decision support, XML data management, spatial databases, advanced transaction processing, mobile databases, main memory databases, multimedia databases, temporal databases.
Has knowledge about data storage, indexing, and query processing techniques used in the new database systems.
Develops new algorithms for data stoage, indexing, and query processing for the new database systems.
|
|
| Mode of Delivery |
: |
Face-to-Face |
|
| Prerequisites and Co-Prerequisites |
: |
None |
|
| Recommended Optional Programme Components |
: |
None |
|
| Aim(s) of Course |
: |
The objective of this course is to learn and discuss more advanced and recent topics about the database management systems. For this purpose, to have basic knowledge about parallel and distributed database systems, object based database systems, deductive database systems, data warehouses and decision support systems, XML data management, spatial database systems, advanced database processes, mobile databases, main memory databases, multimedia databases and temporal databases. |
|
| Course Contents |
: |
Data storage, indexing, and query processing techniques for parallel and distributed database systems, object-database systems, deductive databases, data warehousing and decision support, XML data management, spatial databases, advanced transaction processing, mobile databases, main memory databases, multimedia databases, temporal databases.
|
|
| Language of Instruction |
: |
English |
|
| Work Place |
: |
Room. |
|
|
Course Outline /Schedule (Weekly) Planned Learning Activities |
| Week | Subject | Student's Preliminary Work | Learning Activities and Teaching Methods |
|
1 |
Parallel and distributed database systems |
Reading the lecture notes |
Lecture, discussion |
|
2 |
Object-database systems |
Reading the lecture notes |
Lecture, discussion |
|
3 |
Deductive databases |
Reading the lecture notes, making research for the presentation topic |
Lecture, discussion |
|
4 |
Data warehousing and decision support, |
Reading the lecture notes, making research for the presentation topic |
Lecture, discussion |
|
5 |
XML data management |
Reading the lecture notes, making research for the presentation topic |
Lecture, discussion |
|
6 |
Spatial databases |
Reading the lecture notes, preparing the oral presentation. |
Lecture, discussion |
|
7 |
Advanced transaction processing |
Reading the lecture notes, preparing the oral presentation. |
Lecture, discussion |
|
8 |
Mobile databases |
Reading the lecture notes, implementing the Project work |
Lecture, discussion |
|
9 |
Main memory databases |
Reading the lecture notes, implementing the Project work |
Lecture, discussion |
|
10 |
Multimedia databases |
Reading the lecture notes, implementing the Project work |
Lecture, discussion |
|
11 |
Temporal databases |
Reading the lecture notes, implementing the Project work |
Lecture, discussion |
|
12 |
Recent topics in database systems and student presentations |
Reading the lecture notes, preparing the Project report |
Student oral presentations and discussion sessions. |
|
13 |
Recent topics in database systems and student presentations |
Reading the lecture notes, preparing the Project report |
Student oral presentations and discussion sessions. |
|
14 |
Case studies and Project presentations |
Reading the lecture notes, preparing the Project presentation |
Student oral presentations and discussion sessions. |
|
15 |
Case studies and Project presentations |
Reading the lecture notes, preparing the Project presentation |
Student oral presentations and discussion sessions. |
|
16/17 |
Final Exam |
Reading the lecture notes |
In class written exam |
|
|
|
Required Course Resources |
| Resource Type | Resource Name |
| Recommended Course Material(s) |
 R. Ramakrishnan, J. Gehrke, "Database Management Systems", Third edition, McGrawHill, 2003
E. Bertino, B. C. Ooi, R. Sacks-Davis, K-L Tan, J. Zobel, B. Shidlovsky, D. Andronico, "Indexing Techniques for Advanced Database Systems", Kluwer, 1997.
C. T. Yu, W. Meng, "Principles of Database Query Processing for Advanced Applications", Morgan Kaufmann, 1997.
|
| |
| Required Course Material(s) | |
|
|
|
Assessment Methods and Assessment Criteria |
|
Semester/Year Assessments |
Number |
Contribution Percentage |
|
Mid-term Exams (Written, Oral, etc.) |
0 |
0 |
|
Homeworks/Projects/Others |
3 |
100 |
|
Total |
100 |
|
Rate of Semester/Year Assessments to Success |
40 |
| |
|
Final Assessments
|
100 |
|
Rate of Final Assessments to Success
|
60 |
|
Total |
100 |
|
|
| Contribution of the Course to Key Learning Outcomes |
| # | Key Learning Outcome | Contribution* |
|
1 |
Reaches wide and deep knowledge through scientific research in the field of computer engineering, evaluates, implements, and comments. |
5 |
|
2 |
Describes and uses information hidden in limited or missing data in the field of computer engineering by using scientific methods and integrates it with information from various disciplines. |
5 |
|
3 |
Follows new and emerging applications of computer engineering profession, if necessary, examines and learns them |
5 |
|
4 |
Develops methods and applies innovative approaches in order to formulate and solve problems in computer engineering. |
5 |
|
5 |
Proposes new and/or original ideas and methods in the field of computer engineering in developing innovative solutions for designing systems, components or processes. |
5 |
|
6 |
Designs and implements analytical modeling and experimental research and solves the complex situations encountered in this process in the field of Computer Engineering |
5 |
|
7 |
works in multi disciplinary teams and takes a leading role and responsibility. |
4 |
|
8 |
Learns at least one foreign language at the European Language Portfolio B2 level to communicate orally and written |
5 |
|
9 |
Presents his/her research findings systematically and clearly in oral and written forms in national and international meetings. |
3 |
|
10 |
Describes social and environmental implications of engineering practice. |
4 |
|
11 |
Considers social, scientific and ethical values in collection, interpretation and announcement of data. |
5 |
|
12 |
Acquires a comprehensive knowledge about methods and tools of computer engineering and their limitations. |
5 |
| * Contribution levels are between 0 (not) and 5 (maximum). |
|
|
| Student Workload - ECTS |
| Works | Number | Time (Hour) | Total Workload (Hour) |
| Course Related Works |
|
Class Time (Exam weeks are excluded) |
14 |
3 |
42 |
|
Out of Class Study (Preliminary Work, Practice) |
14 |
3 |
42 |
| Assesment Related Works |
|
Homeworks, Projects, Others |
3 |
16 |
48 |
|
Mid-term Exams (Written, Oral, etc.) |
0 |
0 |
0 |
|
Final Exam |
1 |
20 |
20 |
|
Total Workload: | 152 |
| Total Workload / 25 (h): | 6.08 |
| ECTS Credit: | 6 |
|
|
|