Course aims:

This course introduces fundamental concepts and implementation of object oriented database systems with focus on data distribution, query processing, transaction processing, concurrency control and recovery.
Incorporation of the object oriented model in the database management systems, exploiting the advantages of using this model
Ensuring the integrity, identity, security and persistence of data within object oriented databases
Identification of differences and similarities between relational databases and databases object oriented.
Deepening the principles of design, development and operation of management systems a object-oriented databases.

Course Entry Requirements:

Databases.

Course contents:

 Introduction, Concepts and Definitions  Normalization Techniques  Data Mining and Data warehouse  Transaction Processing  Concurrency Control  Distributed Databases  Database Security  Temporal database  Oracle system architecture  Updating an Oracle database  PL/SQL Language  Oracle Utilities  Oracle From Builder

Teaching methods:

Lecture, conversation, exemplification.

Learning outcomes:

 Apply normalization techniques.  Understand how transactions are processed in a database.  Discuss/explain the concepts of Distributed Databases and Data Warehousing.  Discuss/explain some database security issues.  Tune and Optimize some Database Applications.

Learning outcomes verification and assessment criteria:

Written exam – 50%; continuous assessment – 50%.

Recommended reading:

R. Ramakrishnan, J. Gehrke,, Database Management Systems., McGraw-Hill Publisher, third Edition Pub date: 2002, ISBN: 0-07-246563-8., New York, 2000, 200.
J.D. Ullman, Principles of Data and Knowledge Base Systems,, Volume 1, Computer Science Press., New York, 2000, 200.
H.F. Korth and A. Silberschat, Database System Concepts,, 2nd Edition, McGraw-Hill., New York, 2000, 200.
J. Widom and J. D. Ullman, A First Course in Database Systems,, Prentice-Hall., New York, 2003, 2000.
Cattell R., Barry D.K.,, The Object Data Management Standard: ODMG 3.0,, Morgan Kaufmann, New York, 2000, 200.