COURSE UNIT TITLE

: OBJECT RELATIONAL DATABASE MANAGEMENT SYSTEMS

DEGREE PROGRAMMES

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
ELECTIVE

Offered By

Graduate School of Natural and Applied Sciences

Level of Course Unit

Second Cycle Programmes (Master's Degree)

Course Coordinator

ASSOCIATE PROFESSOR SEMIH UTKU

Offered to

Computer Engineering (Non-Thesis-Evening) (English)
Computer Engineering Non-Thesis (English)
Computer Engineering (English)
Computer Engineering (English)
COMPUTER ENGINEERING (ENGLISH)

Course Objective

The course focuses on the relational and object-relational databases, their query languages and expressive power.
The SQL language and its new standard (SQL3) are examined. The course also aims at guiding and encouraging students to do research on database fields such as temporal, spatial data modelling, moving objects and query languages.

Learning Outcomes of the Course Unit

1   Define Relational and Object-Relational Database Systems
2   Query language SQL and expressive power
3   Realize Temporal Databases and application areas
4   Realize Spatial Databases and application areas
5   Combine Temporal and Spatial Databases into Moving Object Databases

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 INTRODUCTION, E/R DATA MODEL, RELATIONAL DATABASES
2 QUERY LANGUAGES, SQL3 STANDARDS.
3 OBJECT RELATIONAL DATABASE MANAGEMENT SYSTEMS
4 TEMPORAL DATABASES, TEMPORAL EXTENSIONS TO SQL.
5 BITEMPORAL DATABASES
6 BITEMPORAL OBJECT-RELATIONAL DATABASE IMPLEMENTATION
7 SPATIAL DATA MODELS AND QUERY LANGUAGES
8 SPATIAL DATA MODELS AND QUERY LANGUAGES
9 SPATIAL-TEMPORAL DATABASES
10 SPATIAL-TEMPORAL DATABASES
11 MOVING OBJECT DATABASES
12 MOVING OBJECT DATABASES
13 STUDENT RESEARCH PAPER PRESENTATIONS
14 STUDENT RESEARCH PAPER PRESENTATIONS

Recomended or Required Reading

Database Systems: The Complete Book, H. Garcia-Molina, J. Ullman, J. Widom, Prentice Hall, 2002.
Principles of Database and Knowledgebase Systems, J. D. Ullman, Academic Press, 1988. A classic on database theory.
Database Systems, Sixth edition, R. Elmasri, S. Navathe, Addison-Wesley, 2011. Comprehensive coverage and easy to read.
Object relational DBMS - The Next Great Wave, M. Stonebraker, Morgan Kaufmann, 1996.
Bitemporal Databases: Modeling and Implementation, Atay C. E., Tansel A.U., VDM Verlag Dr. Müller, February 2009.
Spatial Databases: A Tour, Shekhar, S., Chawla, S., Prentice Hall, 2003.
Moving Object Databases, R. Guting, M. Schneider, Morgan Kauffman, 2005.

Planned Learning Activities and Teaching Methods

Presentation/Lecturing and Interactive discussion

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 ASG ASSIGNMENT
2 MTE MIDTERM EXAM
3 PRJ PROJECT
4 FCG FINAL COURSE GRADE ASG * 0.30 + MTE * 0.40 + PRJ * 0.30


Further Notes About Assessment Methods

None

Assessment Criteria

To be announced.

Language of Instruction

English

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

Dokuz Eylül University, Department of Computer Engineering
Tınaztepe Campus 35160 Buca, Izmir
Tel:+90-(232) 301 74 01

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 14 3 42
Preparation for midterm exam 1 30 30
Preparations before/after weekly lectures 14 3 42
Preparing presentations 1 30 30
Project Preparation 1 50 50
Midterm 1 2 2
TOTAL WORKLOAD (hours) 196

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11
LO.145434
LO.24223
LO.34223
LO.44223
LO.54223

CONTACT INFORMATION
Dokuz Eylül Üniversitesi Cumhuriyet Bulvarı No: 144 35210 Alsancak / İZMİR
Phone: +90(232) 412 12 12 - Fax: +90 (232) 464 81 35

Copyright 2015 DEÜ. BİD

HOME / ABOUT US / DEGREE PROGRAMMES / GENERAL INFORMATION FOR STUDENTS / INTERNATIONAL RELATIONS