Advanced Database Systems
Software Engineering
Faculty of Engineering
First Cycle (Bachelor's Degree)
| Course Unit Title | Course Unit Code | Type of Course Unit | Level of Course Unit | Year of Study | Semester | ECTS Credits |
|---|---|---|---|---|---|---|
| Advanced Database Systems | YZM418 | Elective | Bachelor's degree | 4 | Spring | 5 |
Name of Lecturer(s)
Assistant Prof. Dr. İrfan KÖSESOY
Learning Outcomes of the Course Unit
1) Express queries in different forms (relational algebra, SQL, etc).
2) Devise appropriate ways to store and index data
3) Show understanding of modern data processing paradigm such as NoSQL
4) Demonstrate understanding of issues surrounding query optimization
5) Show understanding of basic concepts of data mining
Program Competencies-Learning Outcomes Relation
| Program Competencies | |||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | ||
| Learning Outcomes | |||||||||||||
| 1 | Middle | Middle | Middle | Low | Low | Middle | Middle | No relation | Low | No relation | Middle | Low | |
| 2 | Middle | Middle | Middle | Low | Low | Middle | Middle | No relation | Low | No relation | Middle | Low | |
| 3 | Middle | Middle | Middle | Low | Low | Middle | Middle | No relation | Low | No relation | Middle | Low | |
| 4 | Middle | Middle | High | Low | Low | Middle | Middle | No relation | Low | No relation | Middle | No relation | |
| 5 | Middle | Middle | Middle | Low | Low | Middle | Middle | No relation | Low | No relation | Middle | Low | |
Mode of Delivery
Face to Face
Prerequisites and Co-Requisites
None
Recommended Optional Programme Components
Not Required
Course Contents
This lesson covers ;reviewing relational database models and introducing advanced topics in databases by focusing on object-relational databases (ORDB) – nested relations, complex types, inheritances, reference types, querying with complex types, functions and procedures, dbject oriented versus object-relational. ORDB enables storage and manipulation of user defined complex data types. We will take spatial data and databases as an application domain and make some in class applications.
Recommended or Required Reading
Planned Learning Activities and Teaching Methods
1) Lecture
2) Lecture
3) Question-Answer
4) Question-Answer
5) Discussion
6) Discussion
7) Lab / Workshop
8) Lab / Workshop
9) Problem Solving
10) Problem Solving
11) Project Based Learning
12) Project Based Learning
Assessment Methods and Criteria
Contribution of Semester Studies to Course Grade |
40% |
|||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||
Contribution of Final Examination to Course Grade |
60% |
|||||||||||
Total | 100% | |||||||||||
Language of Instruction
Turkish
Work Placement(s)
Not Required