ECTS - Advanced Databases
Advanced Databases (CMPE541) Course Detail
| Course Name | Course Code | Season | Lecture Hours | Application Hours | Lab Hours | Credit | ECTS |
|---|---|---|---|---|---|---|---|
| Advanced Databases | CMPE541 | Area Elective | 3 | 0 | 0 | 3 | 5 |
| Pre-requisite Course(s) |
|---|
| N/A |
| Course Language | English |
|---|---|
| Course Type | Computer Engineering Elective Courses |
| Course Level | Ph.D. |
| Mode of Delivery | Face To Face |
| Learning and Teaching Strategies | Lecture. |
| Course Lecturer(s) |
|
| Course Objectives | The objective of this course is to introduce students to advanced concepts of designing and implementing database systems. |
| Course Learning Outcomes |
The students who succeeded in this course;
|
| Course Content | Database system concepts, transaction processing, concurrency control and database recovery, object-oriented and object-relational databases, semi-structured data and XML, parallel and distributed databases, advanced concepts of distributed databases, introduction to big data, temporal databases. |
Weekly Subjects and Releated Preparation Studies
| Week | Subjects | Preparation |
|---|---|---|
| 1 | Introduction | Lecture Notes |
| 2 | Transaction Processing Concepts | Lecture Notes Chapter 20 (Text Book 1) Chapter 17 (Text Book 2) |
| 3 | Transaction Processing Concepts | Lecture Notes Chapter 20 (Text Book 1) Chapter 17 (Text Book 2) |
| 4 | Concurrency Control Techniques | Lecture Notes Chapter 20 (Text Book 1) Chapter 18 (Text Book 2) |
| 5 | Concurrency Control Techniques | Lecture Notes Chapter 20 (Text Book 1) Chapter 18 (Text Book 2) |
| 6 | Database Recovery Techniques | Lecture Notes Chapter 20 (Text Book 1) Chapter 19 (Text Book 2) |
| 7 | Object-oriented and Object-relational databases | Lecture Notes Chapter 26, 27, 28 (Text Book 1) Chapter 10 (Text Book 2) |
| 8 | Semi-structured data and XML | Lecture Notes Chapter 30 (Text Book 1) Chapter 11 (Text Book 2) |
| 9 | Semi-structured data and XML | Lecture Notes Chapter 30 (Text Book 1) Chapter 11 (Text Book 2) |
| 10 | Parallel and Distributed Databases | Lecture Notes Chapter 22 (Text Book 1) Chapter 20 (Text Book 2) |
| 11 | Distributed Databases – Advanced Concepts | Lecture Notes Chapter 23 (Text Book 1) |
| 12 | Distributed Databases – Advanced Concepts | Lecture Notes Chapter 23 (Text Book 1) |
| 13 | Big Data – Apache Hadoop, MapReduce & Pig Latin | Lecture Notes |
| 14 | Temporal Databases | Lecture Notes |
| 15 | Review | |
| 16 | Review |
Sources
| Course Book | 1. “Database Systems: A practical Approach to Design, Implementation, and Management”, T. Collony & Carolyn Begg, 5th Edition, Addison-Wesley, 2010. |
|---|---|
| 2. Database Systems: The Complete Book, 2nd Ed, Garcia-Molina, Ullman and Widom, Pearson, 2008. | |
| Other Sources | 3. “Fundamentals of Database Systems”, 5th Edition, Ramez Elmasri & Shamkant B. Navathe, Addison-Wesley, 2006. |
| 4. Apache Hadoop Project, available at http://hadoop.apache.org/ |
Evaluation System
| Requirements | Number | Percentage of Grade |
|---|---|---|
| Attendance/Participation | - | - |
| Laboratory | - | - |
| Application | - | - |
| Field Work | - | - |
| Special Course Internship | - | - |
| Quizzes/Studio Critics | - | - |
| Homework Assignments | - | - |
| Presentation | - | - |
| Project | 3 | 30 |
| Report | - | - |
| Seminar | - | - |
| Midterms Exams/Midterms Jury | 1 | 35 |
| Final Exam/Final Jury | 1 | 35 |
| Toplam | 5 | 100 |
| Percentage of Semester Work | 65 |
|---|---|
| Percentage of Final Work | 35 |
| Total | 100 |
Course Category
| Core Courses | |
|---|---|
| Major Area Courses | X |
| Supportive Courses | |
| Media and Managment Skills Courses | |
| Transferable Skill Courses |
The Relation Between Course Learning Competencies and Program Qualifications
| # | Program Qualifications / Competencies | Level of Contribution | ||||
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||
| 1 | Comprehends the most advanced technology and literature in the field of software engineering research. | |||||
| 2 | Gains the ability to conduct world-class research in software engineering and publish scholarly articles in top conferences and journals in the area. | |||||
| 3 | Conducts quantitative and qualitative studies in software engineering. | |||||
| 4 | Develops and applies software engineering approaches to acquire the necessary skills to bridge the gap between academia and industry in the field of software engineering and to solve real-world problems. | |||||
| 5 | Gains the ability to access the necessary information to follow current developments in science and technology, and to conduct scientific research or develop projects in the field of software engineering. | X | ||||
| 6 | Gains awareness and a sense of responsibility regarding professional, legal, ethical, and social issues in the field of software engineering. | X | ||||
| 7 | Acquires project and risk management skills; gains awareness of the importance of entrepreneurship, innovation, and sustainable development; adapts international excellence standards for software engineering practices and methodologies. | X | ||||
| 8 | Gains awareness of the universal, environmental, social, and legal consequences of software engineering practices when making decisions. | X | ||||
| 9 | Develops, adopts, and supports the sustainable use of excellence standards for software engineering practices. | |||||
ECTS/Workload Table
| Activities | Number | Duration (Hours) | Total Workload |
|---|---|---|---|
| Course Hours (Including Exam Week: 16 x Total Hours) | 16 | 3 | 48 |
| Laboratory | |||
| Application | |||
| Special Course Internship | |||
| Field Work | |||
| Study Hours Out of Class | 16 | 3 | 48 |
| Presentation/Seminar Prepration | |||
| Project | |||
| Report | |||
| Homework Assignments | 3 | 4 | 12 |
| Quizzes/Studio Critics | |||
| Prepration of Midterm Exams/Midterm Jury | 1 | 8 | 8 |
| Prepration of Final Exams/Final Jury | 1 | 14 | 14 |
| Total Workload | 130 | ||