COURSE UNIT TITLE

: TOPICS IN DATABASES

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
CME 4413 TOPICS IN DATABASES ELECTIVE 2 2 0 6

Offered By

Computer Engineering

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

ASSOCIATE PROFESSOR SEMIH UTKU

Offered to

Computer Engineering

Course Objective

This course aims to cover Object-Oriented and Object-Relational Database standarts, languages and design that are needed by advance applications which are starting to have widespread use.

Learning Outcomes of the Course Unit

1   Define Object-Oriented and Object-Relational Database Systems.
2   Realize Temporal Databases and application areas.
3   Realize Spatial Databases and application areas.
4   Combine Temporal and Spatial Databases into Moving Object Databases.
5   Realize Data Mining and Data Warehousing applications.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

CME 3201 - DATABASE MANAGEMENT SYSTEMS

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Object-Oriented and Object-Relational Databases
2 Object-Oriented and Object-Relational Databases
3 Nested Relations
4 Query Processing and Optimization
5 Transaction Processing and Concurrency Control
6 Distributed Databases
7 NoSQL Databases and Big Data Storage Systems
8 Modelling Temporal Data
9 Temporal Databases Queries
10 Spatial Databases
11 Spatial Databases Queries
12 Moving Objects Databases and Queries
13 Data Warehousing, Decision Support & OLAP
14 Introduction to Information Retrieval and Extraction

Recomended or Required Reading

Fundamentals of Database Systems, R. Elmasri, S. B. Navathe, Addison - Wesley, 978-0-13-397077-7, 2016.

Database System Concepts, A.Silberschatz, H. F. Korth, S. Sudarshan, McGraw-Hill, 9780078022159, 2019.
Database Systems: Design, Implementation, and Management, C. Caronel, S. Morris, 978-1-305-62748-2, 2016.
Spatial Databases A Tour, S.Shekhar, S.Chawla, Prentice Hall, 0-13-017480-7, 2003.
Temporal Data and The Relational Model, C. J. Date, H. Darwen, N.A. Lorentzos, Morgan Kaufmann, 1-55860-855-9, 2003.
Moving Object Databases, R. H. Güting, M. Schneider, Morgan Kaufmann, 978-0-12-088799-6, 2005.

Planned Learning Activities and Teaching Methods

Presentation/Lecturing and Interactive discussions.

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE MIDTERM EXAM
2 PRJ PROJECT
3 FIN FINAL EXAM
4 FCG FINAL COURSE GRADE MTE * 0.20 + PRJ * 0.40 + FIN * 0.40
5 RST RESIT
6 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.20 + PRJ * 0.40 + RST * 0.40


Further Notes About Assessment Methods

None

Assessment Criteria

Midterm, Final Exam, Project

Language of Instruction

English

Course Policies and Rules

Participation is mandatory.

Contact Details for the Lecturer(s)

Assoc.Prof.Dr. Semih UTKU

Dokuz Eylül University
Engineering Faculty
Dept. of Computer Engineering
Tinaztepe Buca Izmir/TURKEY

semih@cs.deu.edu.tr

Office Hours

Monday 13.00 - 15.00

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 14 2 28
Tutorials 14 2 28
Preparation for final exam 1 20 20
Preparation for midterm exam 1 12 12
Preparations before/after weekly lectures 14 2 28
Project Preparation 1 30 30
Final 1 2 2
Midterm 1 2 2
TOTAL WORKLOAD (hours) 150

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10
LO.145434
LO.24323
LO.34323
LO.44323
LO.54323