Dokuz Eylül University Information Package / Courses Catalog

Description of Individual Course Units

Course Unit Code	Course Unit Title	Type Of Course	D	U	L	ECTS
CSE 5055	OBJECT RELATIONAL DATABASE MANAGEMENT SYSTEMS	ELECTIVE	3	0	0	8

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

*** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

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/LO	PO.1	PO.2	PO.3	PO.4	PO.6	PO.8
LO.1	4	5	4	3		4
LO.2	4	2		2	3
LO.3	4	2		2	3
LO.4	4	2		2	3
LO.5	4	2		2	3

COURSE UNIT TITLE

DEGREE PROGRAMMES

Description of Individual Course Units

Offered By

Level of Course Unit

Course Coordinator

Offered to

Course Objective

Learning Outcomes of the Course Unit

Mode of Delivery

Prerequisites and Co-requisites

Recomended Optional Programme Components

Course Contents

Recomended or Required Reading

Planned Learning Activities and Teaching Methods

Assessment Methods

Further Notes About Assessment Methods

Assessment Criteria

Language of Instruction

Course Policies and Rules

Contact Details for the Lecturer(s)

Office Hours

Work Placement(s)

Workload Calculation

Contribution of Learning Outcomes to Programme Outcomes

CONTACT INFORMATION