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 | Gains accumulated knowledge on mathematics, science and mechatronics engineering; develops an ability to apply the theoretical and applied knowledge of mathematics, science and mechatronics engineering to model and analyze mechatronics engineering problems. | X | ||||
| 2 | Develops ability to differentiate, identify, formulate, and solve complex engineering problems; develops ability to select and implement proper analysis, modeling and implementation techniques for the identified engineering problems. | X | ||||
| 3 | Develops ability to design a complex system, product, component or process to meet the requirements under realistic constraints and conditions; develops ability to apply contemporary design methodologies; an ability to implement effective engineering creativity techniques in mechatronics engineering. (Realistic constraints and conditions includes economics, environment, sustainability, producibility, ethics, human health, social and political problems.) | X | ||||
| 4 | Gains ability to develop, select and use modern techniques, skills and tools for application of mechatronics engineering and robot technologies; develops ability to use information and communications technologies effectively. | X | ||||
| 5 | Develops ability to design experiments, perform experiments, collect and analyze data and assess the results for investigated problems on mechatronics engineering and robot technologies. | |||||
| 6 | Develops ability to work effectively on single disciplinary and multi-disciplinary teams; gains ability for individual work; develops ability to communicate and collaborate/cooperate effectively with other disciplines and scientific/engineering domains or working areas, ability to work with other disciplines. | |||||
| 7 | Develops ability to express creative and original concepts and ideas orally or written effectively, in Turkish and English language. | |||||
| 8 | Develops ability to reach information on different subjects required by the wide spectrum of applications of mechatronics engineering, criticize, assess and improve the knowledge-base; gains consciousness on the necessity of improvement and sustainability as a result of life-long learning; gains ability for monitoring the developments on science and technology; develops awareness on entrepreneurship, innovative and sustainable development and ability for continuous renovation. | |||||
| 9 | Gains ability to be conscious on professional and ethical responsibility, competency on improving professional consciousness and contributing to the improvement of profession itself. | |||||
| 10 | Gains 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 | Gains 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; develops consciousness on these issues and develops awareness of legal results of engineering solutions. | |||||
| 12 | Gains the competence 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 | Gains conciousness on the environmental and social responsibility and develops conciousness to be an individual in society. Gains ability to develop and implement projects and asses them with a critical view for their social implications and gains ability to change the related norms if necessary. | |||||
| 14 | Gains the competence on developing strategy, policy and application plans on the mechatronics engineering and evaluating the results in the context of quality standarts. | |||||
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 | ||