Course MI 103 · Year I · Summer 2019-2020

OBJECT-ORIENTED DATABASES

Compulsory course in Advanced programming and databases, taught by Adriana Bîrluțiu.

This course page is from 2019-2020 and is archived.
See current courses for this faculty and study cycle

Overview

Lecturer
Adriana Bîrluțiu
Seminar tutor
Adriana Bîrluțiu
Type of course
Compulsory
Language of instruction
English
Erasmus language
English
Domain
Computer Science - Masters
Field of study
Advanced programming and databases
Form of education
Full-time
Form of instruction
Class
Credit awarded by
Grade
Teaching methods
Lecture, conversation, exemplification.
Entry requirements
Databases.

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 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

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.

Assessment

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

Recommended reading

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