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 | Elective Courses |
| Course Level | Natural & Applied Sciences Master's Degree |
| 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 | X |
|---|---|
| Major Area Courses | |
| 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 | Accumulated knowledge on mathematics, science and mechatronics engineering; an ability to apply the theoretical and applied knowledge of mathematics, science and mechatronics engineering to model and analyze mechatronics engineering problems. | X | ||||
| 2 | An ability to differentiate, identify, formulate, and solve complex engineering problems; an ability to select and implement proper analysis, modeling and implementation techniques for the identified engineering problems. | X | ||||
| 3 | An ability to design a complex system, product, component or process to meet the requirements under realistic constraints and conditions; an ability to apply contemporary design methodologies; an ability to implement effective engineering creativity techniques in mechatronics engineering. (Realistic constraints and conditions may include economics, environment, sustainability, producibility, ethics, human health, social and political problems.) | X | ||||
| 4 | An ability to develop, select and use modern techniques, skills and tools for application of mechatronics engineering and robot technologies; an ability to use information and communications technologies effectively. | X | ||||
| 5 | An ability to design experiments, perform experiments, collect and analyze data and assess the results for investigated problems on mechatronics engineering and robot technologies. | |||||
| 6 | An ability to work effectively on single disciplinary and multi-disciplinary teams; an ability for individual work; ability to communicate and collaborate/cooperate effectively with other disciplines and scientific/engineering domains or working areas, ability to work with other disciplines. | |||||
| 7 | An ability to express creative and original concepts and ideas effectively in Turkish and English language, oral and written. | |||||
| 8 | An ability to reach information on different subjects required by the wide spectrum of applications of mechatronics engineering, criticize, assess and improve the knowledge-base; consciousness on the necessity of improvement and sustainability as a result of life-long learning; monitoring the developments on science and technology; awareness on entrepreneurship, innovative and sustainable development and ability for continuous renovation. | |||||
| 9 | Be conscious on professional and ethical responsibility, competency on improving professional consciousness and contributing to the improvement of profession itself. | |||||
| 10 | A knowledge on the applications at business life such as project management, risk management and change management and competency on planning, managing and leadership activities on the development of capabilities of workers who are under his/her responsibility working around a project. | |||||
| 11 | Knowledge about the global, societal and individual effects of mechatronics engineering applications on the human health, environment and security and cultural values and problems of the era; consciousness on these issues; awareness of legal results of engineering solutions. | |||||
| 12 | Competency on defining, analyzing and surveying databases and other sources, proposing solutions based on research work and scientific results and communicate and publish numerical and conceptual solutions. | |||||
| 13 | Consciousness on the environment and social responsibility, competencies on observation, improvement and modify and implementation of projects for the society and social relations and be an individual within the society in such a way that planing, improving or changing the norms with a criticism | |||||
| 14 | A competency on developing strategy, policy and application plans on the mechatronics engineering and evaluating the results in the context of qualitative processes. | |||||
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 | ||